Kwethulwa idatha kusuka kuhlelo lwe-1C kuya kubhuku le-Excel

Akuyona imfihlo ukuthi phakathi kwabasebenzi basehhovisi, ikakhulukazi labo abaqashwe emkhakheni wokuhlala nezimali, i-Excel ne-1C baziwa kakhulu. Ngakho-ke, kaningi kuyadingeka ukushintshanisa imininingwane phakathi kwalezi zinhlelo zokusebenza. Kepha, ngeshwa, akubona bonke abasebenzisi abakwaziyo ukwenza lokhu ngokushesha. Ake sithole ukuthi ungayifaka kanjani idatha kusuka ku-1C kudokhumenti le-Excel.

Kwethulwa imininingwane kusuka ku-1C kuya ku-Excel

Uma ukulanda idatha kusuka ku-Excel kuya ku-1C kuyinqubo eyinkimbinkimbi, engazenzakalelayo kuphela ngosizo lwezixazululo ezivela eceleni, bese inqubo yokubuyela emuva, okuthi ukulandwa kusuka ku-1C kuye ku-Excel, isethi yezenzo ezilula. Kungenziwa kalula usebenzisa amathuluzi owakhelwe ngaphakathi wezinhlelo ezingenhla, futhi lokhu kungenziwa ngezindlela eziningi, kuya ngokuthi umsebenzisi udinga ukudlulisa ini. Ake sibheke ukuthi ungakwenza kanjani lokhu ngezibonelo ezithile kuhlobo lwe-1C 8.3.

Indlela yoku-1: kopisha okuqukethwe kweseli

Iyunithi elilodwa ledatha litholakala kuseli 1C. Ingadluliselwa ku-Excel isebenzisa indlela evamile yekhophi.

1. Khetha iseli ku-1C, okuqukethwe ofuna ukukopisha kukho. Sichofoza kukho inkinobho yegundane elifanele. Kumenyu yokuqukethwe, khetha Kopisha. Ungasebenzisa futhi indlela yonkana esebenza ezinhlelweni eziningi ezisebenza kuWindows: mane ukhethe okuqukethwe kweseli bese uthayipha inhlanganisela yokhiye kukhibhodi I-Ctrl + C.



2. Vula ishidi elingenalutho le-Excel noma idokhumenti lapho ufuna ukunamathisela okuqukethwe. Sichofoza kwesokudla nakwimenyu yokuqukethwe evela, kokukhethwa kukho kokufaka, khetha "Gcina umbhalo kuphela", ekhonjiswa ngesimo sepikinikhi ngesimo sencwadi eyi-capital "A".

   

   Esikhundleni salokho, ungakhetha iseli ngemuva kokukhethwa kuthebhu "Ikhaya"chofoza isithonjana Namathiselaetholakala etheyiphu emabhulokini Ibhodi yokunamathisela.

   

   Ungasebenzisa futhi indlela yendawo yonke bese uthayipha isinqamuleli sekhibhodi kwikhibhodi I-Ctrl + V ngemuva kokuba iseli likhethiwe.

Okuqukethwe yiseli 1C kuzofakwa ku-Excel.

Indlela 2: faka uhlu kubhuku le-Excel elikhona

Kepha indlela engenhla ilungile kuphela uma udinga ukudlulisa idatha kusuka kuseli elilodwa. Uma udinga ukudlulisa uhlu lonke, kufanele usebenzise indlela ehlukile, ngoba ukukopisha entweni eyodwa kuzothatha isikhathi esiningi.

1. Sivula noma yiluphi uhlu, umagazini noma isiqondisi ku-1C. Chofoza inkinobho "Zonke izenzo", okufanele ibekwe ngaphezulu kohlu ledatha elicutshunguliwe. Imenyu yethulwa. Khetha into ekuyo "Uhlu".



2. Kuvulwa ibhokisi elincane lohlu. Lapha ungenza ezinye izilungiselelo.

   Insimu "Okuphumayo ku" inezincazelo ezimbili:

   • Idokhumenti le-Spreadsheet;
   • Umbhalo.

   Inketho yokuqala isethwe ngokuzenzakalelayo. Ilungele ukudlulisa idatha ku-Excel, ngakho-ke lapha asiguquki lutho.

   Ebhlokini Khombisa Amakholamu Ungacacisa ukuthi yimaphi amakholomu kusuka kuhlu ofuna ukuluguqula ku-Excel. Uma uzodlulisa yonke imininingwane, khona-ke asithinti lokhu kulungiselelwa. Uma ufuna ukuguqula ngaphandle kwekholomu ethile noma amakholomu ambalwa, bese ungahloli izinto ezihambisanayo.

   Ngemuva kokuthi izilungiselelo seziqediwe, chofoza inkinobho "Kulungile".



3. Ngemuva kwalokho uhlu lukhonjiswa ngendlela ye-tabular. Uma ufuna ukuyidlulisela kufayela le-Excel eliqediwe, vele ukhethe yonke idatha ekulo nesikhombisi ngenkathi uphethe inkinobho yegundane kwesobunxele, bese uqhafaza ekukhethweni ngenkinobho yegundane bese ukhetha into esemenyu evulayo. Kopisha. Ungasebenzisa ukuhlanganiswa kwe-hotkey ngendlela efanayo nasendleleni eyedlule I-Ctrl + C.



4. Vula ishidi le-Microsoft Excel bese ukhetha iseli elingenhla sobunxele lobubanzi lapho imininingwane izofakwa khona. Bese uchofoza inkinobho Namathisela kubambo kuthebhu "Ikhaya" noma thayipha isinqamuleli I-Ctrl + V.

Uhlu lufakwa kudokhumenti.

Indlela 3: dala incwadi entsha yokusebenza ye-Excel enohlu

Futhi, uhlu olusuka kuhlelo lwe-1C lungakhonjiswa ngokushesha kufayela elisha le-Excel.

1. Senza zonke lezo zinyathelo ezazikhonjiswe indlela yangaphambi kokudala uhlu ku-1C ku-tabular version inclusive. Ngemuva kwalokho chofoza inkinobho yemenyu, ebekwe ngaphezulu kwewindows ngendlela unxantathu obhalwe emjikelezweni we-orange. Kumenyu evulayo, dlula ezintweni Ifayela futhi "Gcina Njengo ...".

   

   Kulula ngisho nokwenza inguquko ngokuchofoza inkinobho Gcina, enendlela yediski futhi ibekwe kubhokisi lamathuluzi 1C phezulu ewindini. Kepha ithuba elinjalo litholakala kuphela kubasebenzisi abasebenzisa inguqulo yohlelo 8.3. Ezinguqulweni zangaphambilini, inguqulo yangaphambilini kuphela engasetjenziswa.

   

   Futhi, kunoma yiziphi izinhlobo zohlelo, ungacindezela inhlanganisela yokhiye ukuvula iwindow yokugcina I-Ctrl + S.

2. Iwindi lefayela lokugcina liyaqala. Siya kumkhombandlela lapho sihlela ukugcina khona incwadi uma indawo ezenzakalelayo ingahambelani. Ensimini Uhlobo lwefayela inani elizenzakalelayo "Idokhumenti leTabular (* .mxl)". Lokhu akusifaneli, ngakho-ke, kusuka ohlwini olwehliswayo, khetha into "Ishidi lokusebenzela (* .xls)" noma "Ishidi lokusebenzela i-Excel 2007 - ... (* .xlsx)". Futhi, uma ufisa, ungakhetha amafomethi amadala kakhulu - Ishidi le-Excel 95 noma "Ishidi le-Excel 97". Ngemuva kokuthi izilungiselelo zokugcina zenziwe, chofoza inkinobho Gcina.

Lonke uhlu luzosindiswa njengencwadi ehlukile.

Indlela 4: kopisha ububanzi kusuka kuhlu lwe-1C e-Excel

Kunezikhathi lapho udinga ukudlulisa hhayi uhlu lonke, kepha kuphela imigqa eyedwa noma uhla lwedatha. Le ndlela inokwenzeka futhi ngosizo lwamathuluzi owakhelwe ngaphakathi.

1. Khetha imigqa noma ibanga ledatha kuhlu. Ukuze wenze lokhu, bamba inkinobho I-Shift bese uchofoza kwesobunxele emigqeni ofuna ukuwudlulisa. Chofoza inkinobho "Zonke izenzo". Kumenyu evelayo, khetha "Uhlu ...".



2. Ukuqalisa kokuphuma kohlu kuqala. Izilungiselelo kulo zenziwa ngendlela efanayo nezindlela ezimbili ezedlule. I-caatat kuphela ukuthi udinga ukubheka ibhokisi eliseduze kwepharamitha Kukhethwe Kuphela. Ngemuva kwalokho chofoza inkinobho "Kulungile".



3. Njengoba ukwazi ukubona, uhlu oluhlanganisa kuphela imigqa ekhethiwe luyavezwa. Okulandelayo, sizodinga ukwenza ngqo lezo zenzo ezifana ngazo Indlela yesi-2 noma ku Indlela 3, kuya ngokuthi sizokwengeza yini uhlu kubhuku le-Excel elikhona noma sakha idokhumenti entsha.

Indlela yesi-5: Gcina imibhalo ngefomethi ye-Excel

Ku-Excel, kwesinye isikhathi kuyadingeka ukugcina hhayi uhlu kuphela, kepha futhi nemibhalo eyenziwe ku-1C (ama-akhawunti, ama-invoice, ama-oda wokukhokha, njll.). Lokhu kungenxa yokuthi kubasebenzisi abaningi ukuhlela idokhumenti kulula ku-Excel. Ngaphezu kwalokho, ku-Excel, ungasusa imininingwane egcwalisiwe bese kuthi, lapho usuprinte idokhumenti, ulisebenzise uma kudingeka njengefomu lokugcwaliswa kwezandla.

1. Ku-1C, ngendlela yokwakha noma iyiphi idokhumenti, kunenkinobho yokuphrinta. Kunesithonjana esisesimweni somfanekiso wephrinta kuso. Ngemuva kokuthi idatha edingekayo ifakwe kudokhumenti futhi igcinwe, chofoza lesi sithonjana.



2. Ifomu lokuphrinta liyavula. Kepha thina, njengoba sikhumbula, asidingi ukuphrinta idokhumenti, kepha siyiguqulela ku-Excel. Elula kakhulu enguqulweni 1C 8.3 yenza lokhu ngokuchofoza inkinobho Gcina ngesimo sediski.

   

   Ezinguqulweni zangaphambilini sisebenzisa inhlanganisela ye-hotkey I-Ctrl + S noma ngokuchofoza inkinobho yemenyu ngendlela yoxantathu olungene ngaphakathi kwewindi, sidlula ezintweni Ifayela futhi Gcina.



3. Iwindows yedokhumenti iyavula. Njengokwezindlela ezedlule, udinga ukucacisa indawo yefayela eligciniwe kuyo. Ensimini Uhlobo lwefayela Kufanele uchaze enye yamafomethi we-Excel. Ungakhohlwa ukuqamba idokhumenti enkundleni "Igama lefayela". Ngemuva kokuqeda zonke izilungiselelo, chofoza inkinobho Gcina.

Idokhumenti izogcinwa ngefomethi ye-Excel. Leli fayela manje selingavulwa kulolu hlelo, futhi liqhubeke nokuqhubeka nokusebenza kulo.

Njengoba ukwazi ukubona, ukulayisha imininingwane kusuka ku-1C kufomethi ye-Excel akunzima. Udinga nje kuphela ukwazi i-algorithm yezenzo, ngoba, ngeshwa, hhayi kubo bonke abasebenzisi kuyinto enembile. Usebenzisa amathuluzi we-1C ne-Excel owakhelwe ngaphakathi, ungakopisha okuqukethwe amaseli, uhlu, nobubanzi kusuka kuhlelo lokusebenza lokuqala kuya kolwesibili, futhi ugcine uhlu nezincwadi zokuhlukanisa izincwadi. Kunezindlela eziningi zokonga, futhi ukuze umsebenzisi athole esilungile ngesimo sakhe, asikho isidingo sokuguqukela ekusebenziseni isoftware yomuntu wesithathu noma ukufaka inhlanganisela yezenzo eziyinkimbinkimbi.