Akuyona imfihlo ukuthi izinhlelo ze-Excel nezinhlelo ze-1C zithandwa kakhulu phakathi kwabasebenzi basehhovisi, ikakhulukazi labo ababandakanyeka emkhakheni wezimali kanye nezimali. Ngakho-ke, kuvame ukushintshanisa idatha phakathi kwalezi zicelo. Kodwa, ngeshwa, akubona bonke abasebenzisi abakwazi ukukwenza ngokushesha. Ake sithole ukuthi ungalayisha kanjani idatha kusuka ku-1C kwidokhumenti ye-Excel.
Ilayisha ulwazi kusuka ku-1C kuya ku-Excel
Uma ukulayishwa kwedatha kusuka ku-Excel kuya ku-1C kuyinkambinkimbi eyinkimbinkimbi kakhulu, engasetshenziswa ngokuzenzakalelayo ngokusebenzisa izixazululo zenkampani yangaphandle, inqubo ehlanekezelayo, okungukuthi ukulandwa kusuka ku-1C kuya ku-Excel kuyisethi esilula. Kungenziwa kalula ngokusebenzisa amathuluzi akhiwe ngaphakathi kwezinhlelo ezingenhla, futhi lokhu kungenziwa ngezindlela eziningana, kuye ngokuthi yini umsebenzisi adinga ukuyidlulisela. Cabangela indlela yokwenza lokhu ngezibonelo ezithile ku-1C version 8.3.
Indlela Yoku-1: Kopisha Okungaphakathi Kwamaselula
Iyunithi eyodwa yedatha equkethwe kuseli 1C. Kungadluliselwa ku-Excel ngendlela ejwayelekile yokukopisha.
- Khetha iseli ku-1C, okuqukethwe ofuna ukukopisha. Chofoza kuso nge inkinobho yegundane kwesokudla. Kumenyu yesimo, khetha into "Kopisha". Ungasebenzisa futhi indlela ejwayelekile esebenza ezinhlelweni eziningi ezisebenza ku-Windows: khetha nje okuqukethwe kweseli bese uthayipha inhlanganisela yokhiye ekhibhodi Ctrl + C.
- Vula ishidi le-Excel elingenalutho noma idokhumenti lapho ufuna ukunamathisela okuqukethwe. Chofoza inkinobho yesokudla yegundane nasemenyu yemongo evela ezinketho zokufaka, khetha into "Gcina umbhalo kuphela"okuyinto ekhonjiswe ngesimo sesithonjana ngendlela yombhalo omkhulu "A".
Kunalokho, ungakwenza lokhu ngemuva kokukhetha iseli, ngenkathi kuthebhu "Ikhaya"chofoza kusithonjana Namathiselaesitholakala ku-tape ku-block "Ibhodi lokunamathisela".
Ungasebenzisa futhi indlela yendawo yonke bese uthayipha isinqamuleli sekhibhodi ekhibhodi Ctrl + V ngemuva kokuthi iseli sigcizelelwe.
Okuqukethwe kweseli 1C kuzofakwa ku-Excel.
Indlela 2: Namathisela uhlu ibe yincwadi ekhona ye-Excel
Kodwa indlela engenhla ifanelekile kuphela uma udinga ukudlulisa idatha kusuka kwelinye iseli. Uma udinga ukudlulisa uhlu lonke, kufanele usebenzise enye indlela, ngoba ukukopisha into eyodwa ngesikhathi kuzothatha isikhathi esiningi.
- Vula noma yiluphi uhlu, iphephabhuku noma isiqondisi ku-1C. Chofoza inkinobho "Zonke izenzo"okuyinto okufanele itholakale phezulu kwedatha yedatha esetshenzisiwe. Imenyu iqala. Khetha into kuwo "Bonisa uhlu".
- Ibhokisi elincane lohlu luvula. Lapha ungenza izilungiselelo ezithile.
Inkambu "Umkhiqizo" unezincazelo ezimbili:
- Idokhumenti yamathebhu;
- Umbhalo wombhalo.
Ikhetho lokuqala lifakiwe ngokuzenzakalelayo. Ukudluliselwa kwedatha ku-Excel, kulungile, ngakho-ke asishintshi lutho.
Ku-block "Bonisa amakholomu" Ungacacisa ukuthi yimaphi amakholomu ohlwini ofuna ukuguqula ku-Excel. Uma uzodlulisela yonke idatha, ke lokhu kulungiselelwa nakho akuthinti. Uma ufuna ukuguqula ngaphandle kwekholomu noma amakholomu amaningana, ke ungahloli izingxenye ezihambelanayo.
Ngemuva kokuthi izilungiselelo ziqediwe, chofoza inkinobho. "Kulungile".
- Khona-ke uhlu luboniswa kwifomu ye-tabular. Uma ufuna ukuyithumela efayeleni e-Excel eyenziwe ngomumo, bese ukhetha yonke idatha kuyo ngesikhombisi ngenkathi ubambe inkinobho yegundane lesokunxele, bese uchofoza ekukhetheni inkinobho yegundane efanele bese ukhetha into kwimenyu evuliwe "Kopisha". Ungasebenzisa futhi inhlanganisela yamakhi ashisayo njengendlela yangaphambilini. Ctrl + C.
- Vula ishidi le-Microsoft Excel bese ukhetha iseli eliphezulu ngakwesokunxele ebangeni lapho idatha izofakwa khona. Bese uchofoza inkinobho Namathisela kwi-Ribbon kuthebhu "Ikhaya" noma ukuthayipha isinqamuleli Ctrl + V.
Uhlu lufakwe kulo mbhalo.
Indlela 3: Dala ibhuku elisha le-Excel ngolwazi
Futhi, uhlu oluvela ohlelweni lwe-1C lungasuswa ngokushesha kufayela elisha le-Excel.
- Sifeza zonke izinyathelo eziboniswe endleleni yangaphambilini ngaphambi kokwakhiwa kohlu ku-1C kwinguqulo ye-tabular ehlanganisiwe. Ngemuva kwalokho, chofoza inkinobho yemenyu, etholakala phezulu kwewindi ngesimo santantathu ebhalwe ngumbuthano we-orange. Emenyu yokuqala, iya ezintweni "Ifayela" futhi "Londoloza njengo ...".
Ngisho lula ukwenza ushintsho ngokuchofoza inkinobho "Gcina"okubukeka sengathi i-floppy disk futhi ifakwe ebhokisini lamathuluzi le-1C phezulu kakhulu kwewindi. Kodwa lesi sici sitholakala kuphela kubasebenzisi abasebenzisa inguqulo yohlelo 8.3. Ezinguqulo zangaphambili, kuphela inguqulo yangaphambilini ingasetshenziswa.
Futhi kunoma yiluphi uhlobo lwehlelo lokuqala ukulondoloza iwindi, ungacindezela inhlanganisela yokhiye I-Ctrl + S.
- Ifayela lefayela elilondoloza liqala. Iya kusiqondisi esilungiselela ukusindisa le ncwadi, uma indawo ezenzakalelayo inganelisekile. Ensimini "Uhlobo lwefayela" inani elizenzakalelayo liyi "Umbhalo wethebula (* .mxl)". Awuhambisani nathi, ngakho-ke kusukela kuhlu lokudonsa phansi, khetha into "I-Excel sheet (* .xls)" noma "Iphepha lokusebenzela le-Excel 2007 - ... (* .xlsx)". Futhi, uma ufisa, ungakhetha amafomethi amadala kakhulu - "I-Excel 95 Ishidi" noma "I-Excel 97 Ishidi". Emva kokulondoloza izilungiselelo ezenziwe, chofoza inkinobho. "Gcina".
Uhlu lonke luzogcinwa njengencwadi ehlukile.
Indlela 4: Kopisha ububanzi kusukela kuhlu lwe-1C ku-Excel
Kukhona amacala lapho kudingekile ukudlulisa uhlu lonke, kodwa kuphela imigqa eyodwa noma uhla lwemininingwane. Lolu khetho luyabonakala ngokugcwele ngosizo lwamathuluzi akhiwe ngaphakathi.
- Khetha imigqa noma uhla lwemininingwane ohlwini. Ukwenza lokhu, gcina inkinobho Shift bese uchofoza inkinobho yesinxele segundane emigqeni ofuna ukuyihambisa. Sicindezela inkinobho "Zonke izenzo". Emenyu evelayo, khetha into "Bonisa uhlu ...".
- Ifasitela lokukhipha ohlwini liqala. Izilungiselelo ezikuyo zenziwa ngendlela efanayo nezindlela ezimbili zangaphambilini. I-caveat kuphela ukuthi udinga ukuhlola ibhokisi "Okukhethiwe Kuphela". Emva kwalokho, chofoza inkinobho "Kulungile".
- Njengoba ubona, uhlu oluhlanganisa kuphela imigqa ekhethiwe luboniswa. Okulandelayo sidinga ukwenza izinyathelo ezifanayo ngokufanayo Indlela 2 noma ku Indlela 3kuye ngokuthi sizofaka uhlu ohlwini lwe-Excel noma udale idokhumenti entsha.
Indlela 5: Gcina amadokhumenti efomethi ye-Excel
E-Excel, ngezinye izikhathi udinga ukulondoloza uhlu kuphela, kodwa futhi amadokhumenti adalwe ku-1C (ama-invoyisi, ama-invoyisi, njll.). Lokhu kungenxa yokuthi kubasebenzisi abaningi kulula ukuhlela idokhumenti ku-Excel. Ngaphezu kwalokho, ku-Excel, ungakwazi ukususa idatha egcwalisiwe futhi, uma ushicilele idokhumenti, uyisebenzise, uma kunesidingo, njengefomu lokugcwalisa ngesandla.
- Ku-1C, ngendlela yokwakha noma yimuphi umbhalo kunenkinobho yokuphrinta. Kuzo kufakwe i-pictogram ngesimo somfanekiso wephrinta. Ngemuva kokuthi idatha edingekayo ingeniswe kudokhumenti futhi ilondoloziwe, chofoza kulesi sithonjana.
- Ifomu lokunyathelisa livula. Kodwa thina, njengoba sikhumbula, akudingeki ukuphrinta idokhumenti, kodwa uyiguqulele ku-Excel. Ilula ku-version 1C 8.3 yenza lokhu ngokucindezela inkinobho "Gcina" ngendlela ye-floppy disk.
Ngezinguqulo zangaphambili zisebenzisa inhlanganisela yezihluthulelo ezishisayo. I-Ctrl + S noma ngokucindezela inkinobho yemenyu ngesimo soxantathu ophikisiwe engxenyeni engenhla yewindi, iya ezintweni "Ifayela" futhi "Gcina".
- Iwindi yedokhumenti yokulondoloza ivula. Njengezindlela zangaphambilini, kubalulekile ukucacisa indawo yefayela elilondoloziwe. Ensimini "Uhlobo lwefayela" ucacise enye yefomethi ye-Excel. Ungakhohlwa ukunikeza igama lwedokhumenti ensimini "Igama lefayela". Ngemva kokwenza zonke izilungiselelo chofoza inkinobho "Gcina".
Idokhumenti izogcinwa kufomethi ye-Excel. Leli fayela manje lingavulwa kulolu hlelo, futhi ukuqhutshwa okuqhubekayo kusevele kukhona.
Njengoba ubona, ukulayisha ulwazi kusuka ku-1C kuya ku-Excel akusho neze ubunzima. Udinga kuphela ukwazi i-algorithm yezenzo, ngoba, ngeshwa, akuyona inembile kubo bonke abasebenzisi. Ukusebenzisa amathuluzi akhiwe ngaphakathi ku-1C naku-Excel, ungakwazi ukukopisha okuqukethwe kwamaseli, uhlu nezinhlu kusukela kwesicelo sokuqala kuya kwesibini, futhi ulondoloze uhlu namadokhumenti ezincwadini ezihlukene. Kunezinketho eziningi zokulondoloza futhi ukuze umsebenzisi athole okulungile ngesimo sakhe esithile, asikho isidingo nhlobo sokusebenzisa isofthiwe yangaphandle noma ukusebenzisa izinhlanganisela eziyinkimbinkimbi zezenzo.
