Ngenisa okuqukethwe kwefayela le-CSV ku-Excel. Ungalivula kanjani ifayela le-CSV ku-Excel

I-CSV iwuphawu lwefomethi yedokhumenti yombhalo esetshenziselwa ukubonisa idatha yethebula. Amafayela analesi sandiso asetshenziselwa ukushintshanisa ulwazi oluthile phakathi kwezinhlelo zekhompyutha. Ukuze ubuke noma uhlele ifayela le-CSV, akuzona zonke izinto ezisetshenziswayo ezifanele. Ukuchofoza kabili okujwayelekile kuvame ukuholela ekubonisweni okungalungile kwedatha. Ukuze uthole idatha enembile kanye nekhono lokwenza izinguquko, ungasebenzisa i-Excel.

Izindlela zokuvula amafayela e-CSV ku-Excel

Ngaphambi kokuzama ukuvula amadokhumenti anesandiso esinjalo, udinga ukuqonda ukuthi ayini. Amanani Ahlukaniswe Ngokhefana (CSV) - kusukela kusiNgisi "amanani ahlukaniswe ngokhefana". Idokhumenti ngokwayo isebenzisa izinhlobo ezimbili zezihlukanisi, kuye ngenguqulo yolimi yohlelo:

1. Ngolimi – isemicolon.
2. Okwenguqulo yesiNgisi - ikhoma.

Lapho ulondoloza amafayela e-CSV, ikhodi ethile isetshenziswa, ngenxa yokuthi, ngesikhathi sokuvula, kungase kube nezinkinga ezihlobene nokuboniswa okungalungile kolwazi. Ukuvula idokhumenti nge I-Excel ngokuchofoza kabili okujwayelekile, izokhetha ukubhala ngekhodi okunganasizathu sokukhishwa kwekhodi. Uma ingafani naleyo ebethelwe imininingwane esefayelini, idatha izovezwa ngezinhlamvu ezingafundeki. Enye inkinga engaba khona ukungafani kwe-delimiter, isibonelo, uma ifayela lilondolozwe kunguqulo yesiNgisi yohlelo, kodwa livulwe ngo- , noma ngokuphambene nalokho.

Ukuze ugweme lezi zinkinga, udinga ukwazi ukuthi uwavula kanjani kahle amafayela e-CSV nge-Excel. Kunezindlela ezintathu ezidinga ukucatshangelwa kabanzi.

Ukusebenzisa Iwizadi Yombhalo

I-Excel inamathuluzi amaningi ahlanganisiwe, elinye lawo i-Text Wizard. Ingasetshenziselwa ukuvula amafayela e-CSV. Inqubo:

1. Udinga ukuvula uhlelo. Yenza umsebenzi wokudala ishidi elisha.
2. Yiya kuthebhu "Idatha".
3. Chofoza inkinobho ethi "Thola idatha yangaphandle". Phakathi kwezinketho ezitholakalayo, khetha "Kusuka kumbhalo".
4. Ewindini elivulayo, udinga ukuthola ifayela elidingekayo, chofoza inkinobho ethi "Ngenisa".
5. Iwindi elisha lizovuleka ngokulungiselelwa kwe-Text Wizard. Kuthebhu yokuhlela yefomethi yedatha, maka ibhokisi eliseduze kokuthi “Kunqunyelwe”. Udinga ukukhetha ifomethi ngokwayo kuye ngokuthi yikuphi umbhalo wekhodi osetshenziswe lapho kubhalwa idokhumenti. Amafomethi adume kakhulu yi-Unicode, Cyrillic.
6. Ngaphambi kokuchofoza inkinobho ethi "Okulandelayo", ngaphansi kwekhasi, ungenza ukubuka kuqala ukuze uthole ukuthi ifomethi ikhethwe ngokunembe kangakanani, nokuthi idatha iboniswa kanjani.
7. Ngemva kokuhlola nokuchofoza inkinobho ethi "Okulandelayo", kuzovuleka ikhasi lapho udinga ukusetha uhlobo lwesihlukanisi (amakhoma noma ama-semicolon). Chofoza inkinobho ethi “Okulandelayo” futhi.
8. Ewindini elivelayo, udinga ukukhetha indlela yokungenisa ulwazi, chofoza "KULUNGILE".

Kubalulekile! Le ndlela yokuvula ifayela le-CSV ikuvumela ukuthi ulondoloze ububanzi bamakholomu ngamanye, kuye ngokuthi yiluphi ulwazi agcwaliswa ngalo.

Ngokuchofoza kabili noma ukukhetha uhlelo lokusebenza kukhompuyutha

Izindlela ezilula zokuvula amafayela e-CSV. Zifanele ukusetshenziswa kuphela uma zonke izenzo nedokhumenti (ukudala, ukonga, ukuvulwa) zenziwa yinguqulo efanayo yohlelo. Uma i-Excel yayifakwe ekuqaleni njengohlelo oluzovula wonke amafayela ale fomethi, mane uchofoze kabili kudokhumenti. Uma uhlelo lunganikezwanga ngokuzenzakalelayo, udinga ukwenza izenzo ezimbalwa:

1. Chofoza kwesokudla kudokhumenti bese ukhetha "Vula Nge" kumenyu evelayo.
2. Okukhethiwe okujwayelekile kuzokwethulwa. Uma lungekho usizo olufanelekile, kuzodingeka uthole i-Excel kuthebhu ethi “Khetha olunye uhlelo lokusebenza”.

Ukuboniswa okulungile kwedatha kungenzeka kuphela ngesilinganiso sombhalo wekhodi, izinguqulo zohlelo.

Ayitholakali njalo I-Excel kuthebhu ethi “Khetha olunye uhlelo lokusebenza”. Kulokhu, kufanele uchofoze inkinobho ethi "Bheka olunye uhlelo lokusebenza kule khompyutha". Ngemuva kwalokho, udinga ukuthola uhlelo oludingekayo ngendawo yalo, chofoza inkinobho ethi "OK".

Imenyu yefayela

Enye indlela esebenzayo yokuvula amafayela e-CSV. Inqubo:

1. Vula i-Excel.
2. Chofoza inkinobho ethi "Vula".
3. Yenza kusebenze isihloli ngokusebenzisa umsebenzi othi "Phequlula".
4. Khetha ifomethi ethi “Wonke amafayela”.
5. Chofoza inkinobho ethi "Vula".

Ngokushesha ngemva kwalokho, "Isilekeleli Sokungenisa Umbhalo" sizovuleka. Kufanele ilungiselelwe njengoba kuchazwe ngaphambili.

Isiphetho

Kungakhathaliseki ukuthi ifomethi yamafayela e-CSV iyinkimbinkimbi kangakanani, enombhalo wekhodi olungile kanye nenguqulo yohlelo, angavulwa nge-Excel. Uma, ngemva kokuvula ngokuchofoza kabili, iwindi livela elinezinhlamvu eziningi ezingafundeki, kunconywa ukusebenzisa i-Text Wizard.