Amaxwebhu okubhala e-CSV asetyenziswa ziinkqubo ezininzi zekhompyuter zokutshintsha idatha phakathi kwenye nganye. Ingabonakala ngathi i-Excele Ungayiqala ifayile enjalo ngokucofa kabini kuyo ngeqhosha lasekhohlo iqhosha, kodwa hayi kulo meko, idatha iboniswe ngokuchanekileyo. Kuyinyani, ikho enye indlela yokujonga ulwazi oluqulathwe kwifayile ye-CSV. Masifumanise ukuba kungenziwa njani.
Ukuvula amaxwebhu e-CSV
Igama lefomathi ye-CSV sisifinyezo segama "I-comma eyahlulweyo", eguqulelwa kwisiRashiya, njenge "amaxabiso ahlukaniswe ngamaComs". Ewe, kwezi fayile, abakhweli zizithethi, nangona bekwiinguqulelo ezithetha isiRashiya, ngokuchasene nesiNgesi, emva kwayo yonke loo nto, kulisiko ukusebenzisa indawo yekhoma.Xa ingenisa iifayile ze-CSV ukuba iphumelele, ingxaki yokudlala ikhowudi ifanelekile. Rhoqo, amaxwebhu apho basungulwe khona nge-cyrillic khona basungulwa ngumbhalo we "krakoyabram", oko kukuthi, abalinganiswa abangafundekiyo. Ukongeza, ingxaki rhoqo ngumcimbi wokungahambelani kwahlukaniswa. Okokuqala, oku kuchaphazela ezo meko sizama ukuvula uxwebhu lwenziwe ngolunye uhlobo lwenkqubo yokuthetha isiNgesi, eEshel, ephantsi komsebenzisi wolwimi lwaseRussia. Emva kwayo yonke loo nto, kwikhowudi yemithombo, umahluli yikoma, kwaye i-Exple-Ukuthetha isiRashiya ibona inqaku ngekoma elikule meko. Ke ngoko, iziphumo ezingalunganga zifunyenwe. Siza kuxela indlela yokusombulula le ngxaki xa uvula iifayile.
Indlela yoku-1: Ifayile eqhelekileyo yokuvula
Kodwa ekuqaleni siza kugxila ekukhetheni xa uxwebhu lwe-CSV lwenziwe kwinkqubo yokuthetha i-Russia kwaye sele lilungele ukuvulwa kwe-Excel ngaphandle kwe-grimings eyongezelelweyo ngaphezulu kweziqulatho.
Ukuba inkqubo ye-Excel sele ifakiwe ukuvula amaxwebhu e-CSV kwikhompyuter yakho ngokuzenzekelayo, emva koko kule meko kwanele ukunqakraza kwiqhosha leqhosha lasekhohlo, kwaye liya kuvula i-Excel. Ukuba uxhululo akesungulwa, ke kule meko kufuneka wenze inani lemibuzo eyongezelelweyo.
- Ukuba kwi-Windows Explorer kwisalathiso apho ifayile ifumaneka khona, cofa iqhosha lemouse ekunene kuyo. Imenyu yemeko isunguliwe. Khetha into ethi "Vula ngoncedo" kuyo. Ukuba uluhlu lwe- "Ofisi ye-Microsoft" luyafumaneka kuluhlu oluphambili, emva koko ucofe kuyo. Emva koko, lo xwebhu uza kuqala kwimeko yakho ye-Excel. Kodwa ukuba awuyifumani le nto, cofa kwi "Khetha inkqubo" isikhundla.
- Ifestile yokhetho yenkqubo ivulwa. Apha, kwakhona, ukuba uya kulibona igama elithi "I-Ofisi ye-Microsoft" kwi-"Cons "ibhloksi, emva koko uyikhethe kwaye ucofe iqhosha" Kulungile ". Kodwa ngaphambi koko, ukuba unqwenela ukuba iifayile ze-CSV zihlala zivulwa ngokuzenzekelayo xa kusenziwa imouse iqhosha lemouse, emva koko qiniseke ukuba "ukusetyenziswa kwenkqubo ekhethiweyo yazo zonke iifayile zohlobo" zema uphawu lokutshekisha.
Ukuba awukhange ufumane igama "IOfisi yeMicrosoft" kwifestile yokhetho yenkqubo, emva koko nqakraza kwi "Ushwankathelo ..." iqhosha.
- Emva koko, iwindow evuthuzayo iya kuqala kwindawo yokubeka ifakwe kwikhompyuter yakho. Njengommiselo, le folda ibizwa ngokuba "ziifayile zenkqubo" kwaye ibekwe kwingcambu ye-C. Kuya kufuneka wenze utshintsho kumhloli kule dilesi ilandelayo:
C: \ Iifayile zeNkqubo ye-Microsoft \ Office \ Office
Apho, endaweni ye "No." isimboli, inguqulelo yephakheji ye-Microsoft ye-Microsoft efakwe kwikhompyuter yakho kufuneka ibekwe kwikhompyuter yakho. Njengommiselo, ifolda enjalo yenye, ke khetha ulawulo lwe-Ofisi, nayo nayiphi na inombolo engenama. Ngokuya kwisalathiso esichaziweyo, jonga ifayile ebizwa ngokuba "kwi-Expl" okanye "i-Excel.exe". Uhlobo lwesibini lwegama liya kuba kwimeko owenze ukuba wenze kwandiswa kwi-Windows. Chaza le fayile kwaye ucofe kwi "Vula ..." iqhosha.
- Emva koko, inkqubo yeMicrosoft Excel iya kongezwa kwifestile yokhetho, esithe ngaphambili. Uyakufuna kuphela ukubalule igama elifunwayo, landela ubukho be-tick kufutshane nento ebophelelayo kwiindidi zefayile (ukuba unqwenela ukuvula amaxwebhu e-CSV) kwaye nqakraza kwiqhosha "Kulungile".
Emva koko, imixholo yoxwebhu lwe-CSV liza kuvulelwa. Kodwa le ndlela ifanelekile kuphela ukuba akukho ngxaki kunye nendawo yokuhlala okanye ngemephu ye-cyrillic. Ukongeza, njengoko sibona, kuya kufuneka wenze ulungelelwaniso loxwebhu: kuba ulwazi alusekho kuzo zonke iimeko kwisayizi yangoku, kufuneka zandiswe.
Indlela 2: Sebenzisa iWizard yetekisi
Ungangenisa idatha kuxwebhu lwefomathi ye-CSV usebenzisa isixhobo esifakelweyo se-Excel, esibizwa ngokuba yiWizard.
- Sebenzisa inkqubo ye-Excel kwaye uye kwithebhu yedatha. Kwiteyiphu kwi "Fumana i-Tooling yedatha yangaphandle", cofa kwiqhosha, elibizwa ngokuba "kwitekisi".
- Ifestile yokungenisa i-windows yokungenisa iwindows. Yiya kulawulo lwendawo yefayile ye-CVS. Ibalaselisa iqhosha layo kwaye ucofe kwiqhosha "lokungenisa", elibekwe ezantsi kwefestile.
- Iwindows yombhalo isebenze. Kwindlela "yefomathi yedatha" useto, i-switch kufuneka ime kwi "Prerators" isikhundla. Ukuqinisekisa ukubonisa ngokuchanekileyo umxholo woxwebhu olukhethiweyo, ngakumbi ukuba iqulethe i-cyrillic, qaphela ukuba "i-Unicode (i-UTF-8)" Ifomathi yefayile "isetiwe" kwifomathi yefayile ". Kwimeko echaseneyo, kufuneka uyifake ngesandla. Emva kwazo zonke ezi zicwangciso zingasentla zisetiwe, cofa iqhosha "elilandelayo".
- Emva koko iwindows yesibini yewindows ivula. Nantsi into ebaluleke kakhulu ekuqinisekiseni ukuba loluphi uphawu olwenziweyo kuxwebhu lwakho. Kwimeko yethu, kule ndima apho kukho inqaku kunye ne-comma, njengoko uxwebhu luhlobo lwesiRashiya kunye nendawo yokuhlala kwiinguqulelo zasekhaya zesoftware. Ke ngoko, kwi-Sport Veb "Ukwahlula-ufaka" Sifaka uphawu kwi "POORN ngesikhundla sekoma". Kodwa ukuba ungenisa ifayile ye-CVS elungiselelwe imigangatho ye-CVS, kunye nesithethi sekomathi kuyo yikoma, emva koko kuya kufuneka ubeke uphawu lwe "comma". Emva kokuba kusenziwa lesenzo ingentla, cofa iqhosha "elilandelayo".
- Ifestile yesithathu yeWizard ye-Wizard ivula. Njengomthetho, akukho manyathelo ongezelelweyo akufuneki avelise. Ukuphela kwedwa, ukuba enye yeeseti zedatha ezingenisiweyo kuxwebhu inomhla womhla. Kule meko, kuyimfuneko ukumakisha le kholam ezantsi kwefestile, kwaye i-switch kwifomathi yedatha "yeForkom" ibhloko yendawo "yendawo". Kodwa kwisininzi samatyala amatyala, useto olungagqibekanga apho kufakwe khona "geqe". Ke unokucinezela "ukugqiba" ezantsi kwefestile.
- Emva koko, iwindows encinci yokungenisa idatha ivula. Ifanele ibonise ukulungelelaniswa kwendawo yasekhohlo yeselfowuni apho idatha ye-Entenweyo iya kuba khona. Oku kungenziwa ngokufaka isikhombisi kwintsimi yewindows, kwaye ke ucofe iqhosha lemouse lasekhohlo kwiseli ehambelanayo ephepheni. Emva koko, izinxibelelanisi zayo ziya kudweliswa ebaleni. Unokwenza iqhosha "Kulungile".
- Emva koku, imixholo yeFayile ye-CSV iya kufakwa kwiphepha le-Excel. Ngaphezu koko, njengoko sibona, ibonakaliswa ngokuchanekileyo kunexesha lokusebenzisa le ndlela 1. Ngokukodwa, ukwandiswa kobukhulu beeseli ezingafunekiyo.
Isifundo: Ungayitshintsha njani ikhowudi kwi-Excel
Indlela 3: Ukuvula ithebhu yefayile
Kukho indlela yokuvula uxwebhu lwe-CSV ngethebhu yenkqubo ye-Excel.
- Sebenzisa i-Excel kwaye uye kwithebhu yefayile. Cofa kwindawo ethi "Vula" ibekwe kwicala lasekhohlo lefestile.
- Ifestile yenkqubo iqalile. Kuya kufuneka ihambise kolu mbaleleko kwi-hard disk ye-PC okanye kwimithombo yeendaba esusayo apho uxwebhu lwefomati le-CSV lunomdla khona. Emva koko, kufuneka uphinde uhlengahlengise iifayile zefayile kwi "Zonke iifayile" zefestile. Kuphela kule meko, uxwebhu lwe-CSV luya kuboniswa efestileni, njengoko luyifayile eqhelekileyo ye-Excel. Emva kokuba igama loxwebhu libonisiwe, likhethe kwaye ucofe iqhosha elithi "Vula" ezantsi kwefestile.
- Emva koko, iwizard yeWizard iya kuqala. Zonke ezinye iintshukumo zenziwa nge-algorithm enye njengakwindlela 2.
Njengoko ubona, ngaphandle kweengxaki zokuvulwa kwamaxwebhu efomathi ye-CSV kwi-Prese, kusenokwenzeka ukuba uzisombulule. Ukwenza oku, kuya kufuneka usebenzise isixhobo se-EXPL esifakelweyo, esibizwa ngokuba sisicatshulwa senkosi. Nangona kunjalo, kwiimeko ezininzi, kwanele ukusebenzisa indlela esemgangathweni yokuvula ifayile ngokucofa kabini iqhosha lasekhohlo ngegama lakhe.