Itheksthi yombhalo oqoshiwe CSV asetshenziswa izinhlelo eziningi zekhompyutha ukushintshanisa idatha phakathi komunye nomunye. Kubonakala sengathi ku-Excel kungenzeka ukuthi uqalise ifayela elinjalo ngokuchofoza okuphindwe kabili kukho inkinobho yegundane lesokunxele, kodwa hhayi njalo kulokhu idatha idluliswa kahle. Iqiniso, kukhona enye indlela yokubuka ulwazi oluqukethwe efayeleni. CSV. Ake sithole ukuthi lokhu kungenziwa kanjani.
Ukuvula Amadokhumenti e-CSV
Igama lokufometha CSV yisifinyezo segama "Amanani Ahlukaniswe Ngama-Comma"okuhunyushwa ngesiRussia ngokuthi "amanani ahlukaniswe ngama-comma". Ngempela, ama-commas asetshenziswa njengabahlukanisi kulawa mafayela, nakuba yizinguqulo zesiRussia, ngokungafani nezinguqulo zesiNgisi, kusengokwesiko ukusebenzisa i-semicolon.
Uma ungenisa amafayela CSV I-Excel yinkinga yokudlala okuqoshiwe. Ngokuvamile, amadokhumenti lapho kunama-alfabhethi e-Cyrillic asebenza ngombhalo ogcwele "krakozyabrami", okungukuthi, izinhlamvu ezingafundiwe. Ngaphezu kwalokho, inkinga ejwayelekile kakhulu yinkinga yokungalingani phakathi kwabahlukanisi. Okokuqala, kubhekane nalezi zimo lapho sizama ukuvula idokhumenti eyenziwe ohlelweni lwezinhlelo zesiNgisi, i-Excel, indawo engaphansi komsebenzisi okhuluma isiRussia. Phela, kuhlukaniswe ikhodi yomthombo kuyi-comma, futhi i-Excel ekhuluma isiRussia iyibona njenge-semicolon. Ngakho-ke, umphumela uphinde awulungile. Sizokutshela indlela yokuxazulula lezi zinkinga lapho uvula amafayela.
Indlela 1: Ukuvula Ifayela Ejwayelekile
Kodwa okokuqala sizogxila kokuhluka uma idokhumenti CSV idalwe ohlelweni lolimi lwesiRussia futhi ilungele ukuvula ku-Excel ngaphandle kokuxhaphazwa okungeziwe kokuqukethwe.
Uma i-Excel isivele ifakiwe ukuvula amadokhumenti CSV kukhompyutha yakho ngokuzenzakalelayo, kulokhu, vele uchofoze ifayela ngokuchofoza kabili inkinobho yegundane lesokunxele, futhi lizovuleka ku-Excel. Uma ukuxhumeka kungakabonakali, khona-ke kulesi simo inani lezinyathelo ezengeziwe kufanele zenziwe.
- Ukungena I-Windows Explorer ku-directory lapho ifayela litholakala khona, chofoza ngakwesokudla kuso. Iqala imenyu yokuqukethwe. Khetha into kuwo "Vula nge". Uma uhlu olwengeziwe lunalo igama "I-Microsoft Office"ke uchofoze kuso. Emva kwalokho, lo mbhalo uzovele uqale ikhophi yakho ye-Excel. Kodwa, uma ungayitholi le nto, chofoza kusikhundla "Khetha uhlelo".
- Iwindi yokukhetha uhlelo ivula. Lapha, futhi, uma ku-block "Izinhlelo eziphakanyisiwe" uzobona igama "I-Microsoft Office", bese ukhetha bese uchofoza inkinobho "Kulungile". Kodwa ngaphambi kwalokho, uma ufisa amafayela CSV ivula ngokuzenzakalelayo ku-Excel uma uchofoza kabili igama lohlelo, bese uqinisekisa ukuthi "Sebenzisa uhlelo olukhethiwe kuwo wonke amafayela alolu hlobo" kwakukhona uphawu.
Uma amagama "I-Microsoft Office" kwiwindi yokukhetha uhlelo ongayitholanga, bese uchofoza inkinobho "Buyekeza ...".
- Ngemuva kwalokho, iwindi le-Explorer lizoqaliswa ku-directory lapho izinhlelo ezifakwe kwikhompyutha yakho zitholakala khona. Ngokuvamile, le folda ibizwa "Amafayela Ohlelo" futhi kumpande yediski C. Kumelwe uhambe ku-Explorer kuleli kheli elilandelayo:
C: Uhlelo Lamafayela Microsoft Office Office№Lapho esikhundleni sophawu "№" kufanele ibe nenombolo yenguqulo ye-Microsoft office suite efakwe kukhompyutha yakho. Ngokujwayelekile, le folda ingenye, ngakho khetha inhlawulo Ihhovisinoma yiliphi inombolo ekhona. Ngemuva kokuthuthela esiqondisweni esichaziwe, bheka ifayela elibizwa ngokuthi "EXCEL" noma "EXCEL.EXE". Ifomu lesibili lebizo lizoba uma unemephu ye-map extension ehlanganisiwe I-Windows Explorer. Khetha leli fayela bese uchofoza inkinobho. "Vula ...".
- Ngemuva kwalolu hlelo "I-Microsoft Excel" Kuzofakwa efasiteleni lokukhetha uhlelo, esixoxe ngakho ngaphambili. Uzodinga kuphela ukhethe igama elifunayo, ukuhlola ukuthi kukhona khona uphawu lokuhlola eduze kwesixhumanisi nezinhlobo zefayela (uma ufuna ukuvula imibhalo evulekile njalo CSV ku-Excel) bese ucindezela inkinobho "Kulungile".
Emva kwalokho, okuqukethwe kwedokhumenti CSV izovulwa ku-Excel. Kodwa le ndlela ifanele kuphela uma kungekho zinkinga zendawo yangakini noma ngokubonisa isiCyrillic. Ngaphezu kwalokho, njengoba sibona, kubalulekile ukwenza ukuhlelwa kwedokhumenti: ngoba ulwazi alukho kuwo wonke amacala alungele usayizi wamaseli wamanje, adinga ukwandiswa.
Indlela 2: Sebenzisa i-Wizard Text
Ungangenisa idatha kusuka kudokhumenti yefomethi ye-CSV usebenzisa ithuluzi elakhelwe ngaphakathi le-Excel elibizwa ngokuthi I-Wizard yombhalo.
- Qalisa uhlelo lwe-Excel bese uya kuthebhu "Idatha". On the tape ebhodini amathuluzi "Ukuthola Idatha Yangaphandle" sichofoza inkinobho, ebizwa ngokuthi "Kusukela embhalweni".
- Iwindi lesidokhumenti sombhalo wokungenisa uqala. Ukuhambisa isiqondisi sendawo yefayela eqondisiwe I-CVS. Khetha igama layo bese uchofoza inkinobho. "Ngenisa"efakwe ngaphansi kwefasitela.
- Iwindi elisebenzayo Amasevisi wombhalo. Ebhokisini lesethingi "Ifomethi yeDatha" inkinobho kufanele ibe sesikhundleni "Unlimited". Ukuqinisekisa ukuthi okuqukethwe kwedokhumenti ekhethiwe kuboniswa ngendlela efanele, ikakhulukazi uma iqukethe i-Cyrillic, sicela uqaphele ukuthi ku "Ifomethi yefayela" isethelwe "Unicode (UTF-8)". Uma kungenjalo, udinga ukuyifaka ngesandla. Emva kwazo zonke izilungiselelo ezingenhla zifakiwe, chofoza inkinobho "Okulandelayo".
- Kwabe sekuvula iwindi yesibili. Amasevisi wombhalo. Lapha kubaluleke kakhulu ukucacisa ukuthi yisiphi isilondolozi esiyi-delimiter kumadokhumenti wakho. Esikhathini sethu, i-semicolon ivela kule ndima, ngoba idokhumenti isiRashiya futhi inendawo yangempela yezinguqulo zesofthiwe yasekhaya. Ngakho-ke, kuzilungiselelo ukuvimba "Umlingiswa we-delimiter" sabeka uphawu endaweni "Semicolon". Kodwa uma ungenisa ifayela I-CVS, elungiselelwe amazinga olimi lwesiNgisi, futhi i-comma isebenza njenge-delimiter, ngakho kufanele uhlole ibhokisi "Comma". Ngemuva kokuthi izilungiselelo ezingenhla zenziwe, chofoza inkinobho "Okulandelayo".
- Iwindi lesithathu livula. Amasevisi wombhalo. Njengomthetho, akukho zenzo ezengeziwe ezidingekayo. Okuhlukile kuphela uma omunye wamasethi wedatha awethulwe kudokhumenti anomhlobo wosuku. Kulesi simo, kuyadingeka ukuphawula leli kholomu engxenyeni engezansi yewindi, kanye nokushintshwa ku-block "Ifomethi Yedatha Yekholomu" usethe esimweni "Usuku". Kodwa ezimweni eziningi, izilungiselelo ezizenzakalelayo zanele, lapho ifomethi isethiwe khona "Jikelele". Ngakho ungacindezela inkinobho. "Yenzelwe" phansi kwefasitela.
- Emva kwalokhu, iwindi elincane lokungenisa idatha livula. Kufanele ikhombise izixhumanisi zeseli eliphezulu elingenhla lendawo lapho idatha engenisiwe izobe khona khona. Lokhu kungenziwa ngokumane ubeka isikhombisi emkhakheni wewindi, bese uchofoza inkinobho yegundane lesokunxele esitokisini esilandelayo kushidi. Emva kwalokho, izixhumanisi zayo zizofakwa ensimini. Ungacindezela inkinobho "Kulungile".
- Emva kwalokhu okuqukethwe kwefayela CSV izobekwa phezu kwephepha elihle kakhulu. Futhi, njengoba singakubona, kuboniswa kahle kakhulu uma usebenzisa Indlela 1. Ngokuyinhloko, akukho ukwanda okungeziwe kwama-cell size.
Isifundo: Ungashintsha kanjani ukufaka ikhodi ku-Excel
Indlela 3: kuvulwa ngokusebenzisa ithebhu ethi "Ifayela"
Kukhona indlela yokuvula idokhumenti. CSV ngokusebenzisa ithebhu "Ifayela" Izinhlelo ze-Excel.
- Qalisa i-Excel bese uhamba uye kuthebhu "Ifayela". Chofoza entweni "Vula"elisehlangothini lwesobunxele lwewindi.
- Iwindi iqala Umqhubi. Kufanele uhambe kuwo kulokho lwemibhalo kwi-PC disk eyinkimbinkimbi noma emithonjeni ekhishwayo, lapho idokhumenti yefomethi onentshisekelo kuyo ikhona CSV. Ngemuva kwalokho, udinga ukuhlela kabusha ushintsho lohlobo lwefayili efasiteleni endaweni "Wonke Amafayela". Kuphela kule dokhumenti CSV izoboniswa efasiteleni ngoba ayilona ifayela elisezingeni eliphezulu. Ngemuva kokuba igama lwedokhumenti liboniswe, khetha bese uchofoza inkinobho "Vula" phansi kwefasitela.
- Emva kwalokho, iwindi lizoqala. Amasevisi wombhalo. Zonke izenzo ezengeziwe zenziwa nge-algorithm efanayo efanayo Indlela 2.
Njengoba singabona, naphezu kwezinkinga ezithile zokuvula imibhalo CSV e-Excel, bangakwazi ukuxazululwa. Ukuze wenze lokhu, sebenzisa ithuluzi elakhelwe ngaphakathi kwe-Excel, elibizwa ngokuthi I-Wizard yombhalo. Nakuba, ezimweni eziningi, kuwanele ukusebenzisa indlela ejwayelekile yokuvula ifayela ngokuchofoza kabili inkinobho yegundane lesokunxele egameni layo.
