Kudilizwa idatha kusuka 1c Excel: izindlela 5 ukusebenza

Akusiyo imfihlo ukuthi phakathi izisebenzi zasemahhovisi, ikakhulukazi labo abahlanganyela emjondolo sphere zezimali, izinhlelo Excel ne 1c yizona ezithandwa kakhulu. Ngakho-ke, ngokuvamile kuyadingeka ukushintshanisa idatha phakathi lezi zinhlelo zokusebenza. Kodwa, ngeshwa, akuzona zonke abasebenzisi bazi ukuthi angalenza kanjani ngokushesha. Ake sithole ukuthi kwakungani ulayisha kanjani idatha kusuka 1c kuya Excel umculu.

Kulayishwa ulwazi kusuka 1c Excel

Uma umthwalo idatha kusuka Excel e 1c yinqubo kunalokho nzima, ungakwazi ukushintsha kuphela izixazululo third-party ke inqubo reverse, okungukuthi athula ka 1c kuya Excel iqoqo elula yezenzo. It Kungafezani kalula usebenzisa esakhelwe amathuluzi izinhlelo ngenhla, futhi ungakwenza lokhu ngezindlela eziningana, kuye ngokuthi yiziphi izidingo umsebenzisi izodluliselwa khona. Cabangela nendlela okwenziwa ngezibonelo ezithile e 1c version 8.3.

Indlela 1: Kopisha Cell sokuqukethwe

Omunye iyunithi idatha eziqukethwe iseli 1c. It angadluliselwa Excel nge evamile ukukopisha indlela.

1. Thina ukugqamisa iseli 1c, okuqukethwe ufuna ukukopisha. Chofoza inkinobho yegundane kwesokudla. Esikhathini imenyu yengqikithi, khetha "Kopisha" lento. Ungasebenzisa futhi indlela jikelele ukuthi wenza ezinhlelweni eziningi egijima on Windows OS: Vele ukhethe okuqukethwe kweseli bese uthayipha inhlanganiselazihlonzi kukhibhodi Ctrl + C.



2. Vula nalutho uhlu Excel noma idokhumenti lapho udinga ukufaka okuqukethwe. Nge inkinobho yegundane kwesokudla futhi imenyu umongo ukuthi kuvela e nemingcele Ukufakwa, ukhethe "Londoloza kuphela umbhalo" into, okuyinto uvezwa ngesimo pictogram ngesimo incwadi enkulu "A".

   

   Kunalokho, isenzo ingasetshenziswa ngemuva kokukhetha iseli ngenkathi "Ekhaya" ithebhu, chofoza "Faka" uphawu, esemgwaqweni eteyipini e block ebhodini lokunamathisela.

   

   Ungasebenzisa futhi ngendlela jikelele futhi ushayele Ctrl + V okhiye kukhibhodi emva kweselula ezigqanyisiwe.

Okuqukethwe kuseli 1c ozofakwa Excel.

Indlela 2: Ukufaka uhlu eNcwadini Excel ekhona

Kodwa indlela ngenhla ngeke isudi kuphela uma udinga ukudlulisa idatha kwesinye isitokisi bazifake. Lapho kudingeka wenze nokudluliswa lonke uhlu, kufanele usebenzise enye indlela, ngoba ukukopishela omunye isici kuzothatha isikhathi esiningi.

1. Vula noma iyiphi uhlu, lwamakholi noma incwadi isithenjwa 1c. Chofoza inkinobho ethi "Zonke Izenzo", okuyinto kufanele zitholakale phezulu amalungu afanayo idatha ezenziwayo. Imenyu iqalisiwe. Khetha kuwo into "Bonisa ohlwini".



2. Kuvulwa iwindi elincane lokukhipha. Lapha ungenza ezinye izilungiselelo.

   Inkambu ye- "Display B" inamanani amabili:

   • Idokhumenti ye-Tabular;
   • Umbhalo wombhalo.

   Okuzenzakalelayo kuyindlela yokuqala. Ukudlulisa idatha ku-Excel, kufanelekile nje, ngakho-ke lapha asiguquki lutho.

   Ku-Block "Khombisa Izikhulumi" Block, ungacacisa ukuthi yiziphi izikhulumi ezivela ohlwini ofuna ukuzihumushela ku-Excel. Uma uzokwenza yonke imininingwane, futhi awuthinti lokhu kulungiselelwa. Uma ufuna ukuguqulwa ngaphandle kwekholomu ethile noma amakholomu amaningana, bese ususa umkhaza kusuka ezintweni ezihambisanayo.

   Ngemuva kokuthi amasethingi eseqediwe, chofoza inkinobho ethi "Kulungile".



3. Lapho-ke uhlu luboniswa ngendlela yethebula. Uma ufuna ukuwudlulisela kufayela elilungele ukulungele, vele ukhethe yonke imininingwane kulo nesikhombisi ngenkinobho yegundane kwesobunxele, bese uchofoza inkinobho yegundane kwesokudla bese ukhetha into ethi "Kopisha" kumenyu evuliwe. Ungasebenzisa futhi inhlanganisela yezinkinobho ezishisayo ze-CTRL + S.



4. Ukuvula i-Microsoft Excel Sheet bese ukhetha uhla olungenhla lwesobunxele lobubanzi lapho imininingwane izofakwa khona. Bese uchofoza inkinobho ethi "Namathisela" ethepheni kuthebhu yasekhaya noma thayipha inhlanganisela ye-CTRL + V.

Uhlu lufakwa kudokhumenti.

Indlela 3: Ukwakha incwadi entsha ye-Excel ngohlu

Futhi, uhlu lwezinhlelo ze-1C lungaboniswa ngokushesha kufayela elisha le-Excel.

1. Sifeza zonke lezo zinyathelo ezichazwe ngendlela eyedlule ngaphambi kokwenza uhlu ku-1C kwinguqulo yeTabular efakiwe. Emva kwalokho, sichofoza inkinobho yemenyu yokushayela imenyu, etholakala phezulu kwewindi ngesimo sonxantathu esibhalwe endilinga e-orange. Emenyu yemenyu yemenyu, ngokulandelana kwehle nge- "File" futhi "Gcina njenge ...".

   

   Kulula ngisho nokwenza ushintsho ngokuchofoza inkinobho ethi "Gcina", okunombono wefloppy futhi itholakala kubha yamathuluzi ayi-1C phezulu kwewindi. Kepha le ndlela itholakala kuphela kubasebenzisi abasebenzisa uhlelo lwenguqulo 8.3. Ezinguqulweni zangaphambili, ungasebenzisa kuphela inketho yangaphambilini.

   

   Futhi kunoma yiziphi izinhlobo zohlelo lokuqala ukuqala iwindi longa, ungachofoza inhlanganisela kakhiye we-CTRL + S.

2. Ifayela ekulondolozeni iwindi iqala. Iya lwemibhalo lapho sihlela ugcine incwadi uma indawo akuyona aneliseke ezenzakalelayo. Esikhathini Uhlobo lwefayela ensimini, ngokuzenzakalela iyona "Tablebook dokhumenti (* .mxl)". It kungahlali nathi, ngakho-ke khetha kusuka uhlu olwehlayo "Excel (* .xls) ishidi noma" Excel 2007 ishidi "... (* .xlsx)." Uma ufisa, ungakhetha nezakhiwo ezindala kakhulu - "Excel 95" noma "Excel 97 ishidi". Ngemva londoloza izilungiselelo ekhiqizwa, qhafaza inkinobho ethi "Londoloza".

Yonke uhlu uyakusindiswa ngokwamukela incwadi ehlukile.

Indlela 4: Ukukopisha ububanzi ohlwini 1c kuya Excel

Kukhona amacala lapho udinga ukudlulisela hhayi lonke uhlu, kodwa kuphela imigqa noma idatha ngabanye range. Lolu khetho ngeke futhi ihlanganise ngokuphelele esakhelwe amathuluzi.

1. Khetha izintambo noma uhla idatha ohlwini. Ukuze wenze lokhu, bamba inkinobho Shift uphinde uchofoze kwesokunxele igundane inkinobho emigceni izodluliselwa khona. Chofoza inkinobho ethi "Zonke Izenzo". Esikhathini imenyu ukuthi kuvela, khetha "Bonisa ohlwini ..." lento.



2. Iwindi uhlu okukhipha yethulwa. Izilungiselelo kuwo akhiqizwa ngendlela efanayo njengoba ku izindlela ezimbili eyedlule. I ehilelekile kuphela ukuthi udinga ukufaka umkhaza mayelana "abazinikezele kuphela" ipharamitha. Ngemuva kwalokho, chofoza inkinobho ethi "Kulungile".



3. Njengoba ubona, uhlu ehlanganisa kuphela imigca akhethiwe isuselwe. Ngaphezu kwalokho, sizodinga ukwenza ncamashi izenzo kuyafana indlela 2 noma indlela 3, kuncike ekutheni sifuna ukwengeza ohlwini yebhuku elikhona Excel noma udale idokhumenti entsha.

Indlela 5: Ukulondoloza imibhalo Excel format

Ku-Excel, ngezinye izikhathi udinga ukulondoloza uhlu hhayi kuphela, kodwa futhi ezidalwe 1c imibhalo (ama-akhawunti, oda phezulu lokukhokha, njll). Lokhu kungenxa yokuthi i-abasebenzisi eziningi hlela idokhumenti kulula Excel. Ngaphezu kwalokho, ungakwazi ukususa idatha kuphelile Excel futhi, ukunyathelisa dokhumenti, ulisebenzise uma kunesidingo njengoba ifomu zokugcwalisa mathupha.

1. Ngo 1c ngesimo ukudala noma idokhumenti kukhona inkinobho ukuphrinta. Iqukethe isithonjana ngesimo isithombe iphrinta. Ngemva idokhumenti singenelwe idokhumenti futhi igcinwa, chofoza lesi sithonjana.



2. Ifomu ukuphrinta liyavuleka. Kodwa thina, njengoba sikhumbula, udinga ukuphrinta idokhumenti, kodwa ukuguqula it Excel. Indlela elula ku version 1c 8.3 kwenziwa ngokuchofoza inkinobho ye- "Londoloza" ngesimo a iflophidiski.

   

   Ukuze izinguqulo ngaphambili, sisebenzisa inhlanganisela okhiye ashisayo Ctrl S noma ngokucindezela imenyu inkinobho okukhipha ngesimo unxantathu nabokhulumile phezulu ewindini, silandela ifayela "Ifayela" futhi "Londoloza".



3. Iwindi lokusindisa idokhumenti livula. Njengasezinganeni ezedlule, idinga ukucacisa indawo yefayela eligciniwe. Emkhakheni wohlobo lwefayela, kufanele ucacise enye yezindlela ze-Excel. Ungakhohlwa ukunikeza igama ledokhumenti ku- "Ifayela Lefayela". Ngemuva kokwenza zonke izilungiselelo, cindezela inkinobho ethi "Gcina".

Lo mbhalo uzosindiswa ngefomethi ye-Exel. Leli fayela manje lingavulwa kulolu hlelo, futhi ukucutshungulwa okwengeziwe sekuvele kulo.

Njengoba ukwazi ukubona, ukulayisha imininingwane kusuka ku-1c ngefomethi ye-Excel akunzima. Kuyadingeka ukwazi kuphela i-algorithm yezenzo, kusukela, ngeshwa, akuqondakali kahle kubo bonke abasebenzisi. Usebenzisa amathuluzi owakhelwe ngaphakathi 1C kanye ne-Excel, ungakopisha okuqukethwe kwamaseli, uhlu namabanga kusuka kuhlelo lokusebenza lokuqala kuya kwesibili, kanye nokonga uhlu kanye nemibhalo ezinhlakeni ezihlukile. Izinketho zokongiwa kwemvelo ziningi kakhulu futhi ukuze umsebenzisi azithole efanelekile ngesimo sayo, asikho isidingo sokusebenzisa ekusetshenzisweni kwesoftware yangaphandle noma ukufaka inhlanganisela eyinkimbinkimbi yezenzo.