Amadokhumenti Wombhalo Othile Csv isetshenziswa izinhlelo eziningi zamakhompyutha ukushintshanisa idatha phakathi komunye nomunye. Kubukeka sengathi ku-Excel ungavula ifayela elinjalo ngokuchofoza kabili okujwayelekile kulo ngenkinobho yegundane lesokunxele, kodwa kude kakhulu kulokhu kulokhu idatha iboniswa kahle. Kuliqiniso, kunenye indlela yokubuka imininingwane ekule fayela. Csv. Ake sibheke ukuthi ungakwenza kanjani lokhu.
Kuvulwa Imibhalo ye-CSV
Igama lefomethi Csv isifushaniso segama "Amanani Ahlukaniswe Khefana", okuhunyushelwa kwisiRussia ngokuthi "amanani ahlukaniswe ukhefana." Impela, kulawa mafayela ama-coma asebenza njengehlukanisi, yize kunguhlobo lwesiRussia, ngokungafani nesiNgisi, kusisiko ukusebenzisa i-semicolon.
Lapho ungenisa amafayela Csv Ku-Excel, inkinga yangempela ukufaka ikhodi. Imvamisa, amadokhumenti lapho kukhona amaCyrillic akhona aqhamuka nombhalo ogcwele "ngezinwele ezikhubekile", okungukuthi, izinhlamvu ezingafundeki. Ngaphezu kwalokho, udaba lwe-Septer mismatch luyinkinga evamile. Okokuqala, lokhu kusebenza ezimweni lapho sizama ukuvula umqulu owenziwe ohlelweni oluthile lolimi lwesiNgisi, i-Excel, olwenziwe endaweni njengomsebenzisi okhuluma isiRussia. Ngempela, emthonjeni, i-splitter iyikhefana, futhi i-Excel ekhuluma isiRussia ibona i-semicolon kuleli khwalithi. Ngakho-ke, umphumela ongalungile uyatholakala futhi. Sizokutshela ukuthi ungazixazulula kanjani lezi zinkinga lapho uvula amafayela.
Indlela yoku-1: Vula ifayili ngokujwayelekile
Kepha okokuqala, sizogxila ekukhetheni lapho idokhumenti Csv lidalwe ohlelweni lolimi lwaseRussia futhi ilungele ukuvulwa e-Excel ngaphandle kokukhohlisa okwengeziwe kokuqukethwe.
Uma i-Excel isivele ifakiwe ukuvula amadokhumenti Csv kukhompyutha yakho ngokuzenzakalelayo, kuleli cala, chofoza nje kufayela ngokuchofoza kabili inkinobho yegundane kwesobunxele, futhi izovula ku-Excel. Uma ukuxhumeka kungakakhiwa, khona-ke kuleli cala, kuzodingeka wenze inqwaba yokungeziwe.
- Ukuba phakathi I-Windows Explorer kumkhombandlela lapho ifayela litholakala khona, chofoza ngakwesokudla kulo. Imenyu yokuqukethwe yethulwe. Khetha into ekuyo Vula nge. Uma uhlu olungeziwe oluvuliwe luqukethe igama "Ihhovisi leMicrosoft", bese uchofoza kukho. Ngemuva kwalokho, idokhumenti lizomane lisebenze esibonelweni sakho se-Excel. Kepha, uma ungayitholi le nto, bese uchofoza isikhundla "Khetha uhlelo".
- Iwindows lokukhetha uhlelo liyavula. Lapha, futhi, uma kuvimbekile Izinhlelo ezinconyiwe uzobona igama "Ihhovisi leMicrosoft"bese uyikhetha bese uchofoza inkinobho "Kulungile". Kepha ngaphambi kwalokho, uma ufuna amafayela Csv ivulwa njalo ngokuzenzakalelayo ku-Excel uma uchofoza kabili igama lohlelo, bese uqinisekisa ukuthi eceleni kwepharamitha "Sebenzisa uhlelo olukhethiwe kuwo wonke amafayela alolu hlobo" kwakukhona uphawu lokuhlola.
Uma amagama "Ihhovisi leMicrosoft" ewindini lokukhetha uhlelo awutholanga, bese uchofoza inkinobho "Buyekeza ...".
- Ngemuva kwalokho iwindi le-Explorer lizovula kumkhombandlela lapho kufakwa khona izinhlelo kukhompyutha yakho. Le folda ivame ukubizwa "Amafayela wohlelo" futhi itholakala empandeni yediski C. Kufanele uye ku-Explorer kuleli kheli elilandelayo:
C: Amafayili wohlelo Ihhovisi leMicrosoft Office№Lapho esikhundleni sophawu "№" kufanele kube inombolo yenguqulo ye-Microsoft office suite efakwe kukhompyutha yakho. Njengomthetho, kunefolda eyodwa kuphela, ngakho-ke khetha umkhombandlela Ehhovisiakukhathalekile ukuthi inani likhona. Ukuthuthela kusikhombisi esibekiwe, fayela ifayela elibizwa QAPHELA noma "EXCEL.EXE". Uhlobo lwesibili lokuqamba igama luzoba uma usufake imephu yesandiso ku I-Windows Explorer. Qokomisa leli fayela bese uchofoza inkinobho. "Vula ...".
- Ngemuva kwalolu hlelo "I-Microsoft Excel" izongezwa ngewindi lokukhetha uhlelo, esikhulume ngalo phambilini. Uzodinga kuphela ukukhetha igama olifunayo, ulandele umkhondo wokuba khona kwesibonakaliso esiseduze kwendawo yokubopha ezinhlotsheni zefayela (uma ufuna ukuvula amadokhumenti njalo Csv ku-Excel) bese uchofoza inkinobho "Kulungile".
Ngemuva kwalokho, okuqukethwe yincwadi Csv izovulwa e-Excel. Kepha le ndlela ifaneleka kuphela uma kungekho zinkinga nge-localization noma ngokubonisa kwezinhlamvu zama-Cyrillic. Ngaphezu kwalokho, njengoba sibona, kuzofanele senze ukuhlela okuthile kwedokhumenti: ngoba imininingwane ayihlali ihlangana nosayizi wamanje wamaseli, kudingeka ukuthi inwetshwe.
Indlela yesi-2: Sebenzisa i-Umbhalo Wizard
Ungangenisa imininingwane kusuka kudokhumenti lefomethi ye-CSV usebenzisa ithuluzi le-Excel elakhelwe ngaphakathi Umbhalo wizadi.
- Qalisa uhlelo lwe-Excel bese uya kuthebhu "Idatha". Kubambo olubekwe ebhokisini lamathuluzi "Ukuthola imininingwane yangaphandle" chofoza inkinobho ebizwa ngokuthi "Okusuka embhalweni".
- Iwindi lokungenisa idokhumenti yombhalo liqala. Siqhubekela kusikhombi sendawo sefayela eliqondiwe CVS. Khetha igama laso bese uchofoza inkinobho "Ngenisa"etholakala ezansi kwewindi.
- Iwindows liyasebenza Amakhosi wombhalo. Ebhuthini yezilungiselelo Isimo sedatha switch kufanele ibe sesimweni Ihlukaniswe. Ukuqinisekisa ukuthi okuqukethwe yidokhumenti ekhethiwe kuboniswa kahle, ikakhulukazi uma iqukethe i-Cyrillic, naka inkambu "Ifomethi yefayela" isethwe ku I-Unicode (UTF-8). Ngaphandle kwalokho, udinga ukuyifaka ngesandla. Ngemuva kokuthi wonke amasethingi angenhla asethiwe, chofoza inkinobho "Okulandelayo".
- Bese kuvulwa iwindi lesibili. Amakhosi wombhalo. Lapha kubaluleke kakhulu ukunquma ukuthi yimuphi umlinganisi owahlukanisa idokhumenti lakho. Kithina, le ndima idlalwa yi-semicolon, ngoba idokhumenti ingolimi lwaseRussia futhi lenziwa lasendaweni ngokuqondile ngezihumusho zasekhaya zesoftware. Ngakho-ke, kwibhulokhi yezilungiselelo "Umlingisi owahlukile" sihlola ibhokisi I-Semicolon. Kepha uma ungenisa ifayili CVS, elungiselelwe izindinganiso zesiNgisi, futhi njengesihlukanisi kulo kuyikhefana, lapho-ke kufanele uhlole ibhokisi Ukhefana. Ngemuva kokuthi izilungiselelo ezingenhla zenziwe, chofoza inkinobho "Okulandelayo".
- Kuvulwa iwindi lesithathu Amakhosi wombhalo. Njengomthetho, akukho zenzo ezengeziwe ezidingekayo kuwo. Okuwukuphela kwento uma ngabe eyodwa yamasethi wedatha eyethulwe kudokhumenti isesimweni sosuku. Kulokhu, udinga ukumaka le kholamu ezansi kwewindi, kanye neswitshi esivulekile Indlela Yedatha Yekholomu setha isikhundla Usuku. Kepha ngobuningi bamacala, izilungiselelo ezizenzakalelayo lapho kusetshenziswe khona ifomethi zanele "Okujwayelekile". Ngakho ungavele ucindezele inkinobho Kwenziwe phansi kwewindi.
- Ngemuva kwalokho, kuvuleka iwindi elincane lokungenisa idatha. Kufanele kubonise izixhumanisi zeseli elingaphezulu kwesobunxele yendawo lapho idatha engenisiwe izotholakala khona. Lokhu kungenziwa ngokubeka isikhombisi enkundleni yewindi, bese uchofoza kwesobunxele kwiseli elihambisanayo eshidini. Ngemuva kwalokho, izixhumanisi zalo zizongena emkhakheni. Ungacindezela inkinobho "Kulungile".
- Ngemuva kwalokho, okuqukethwe ifayela Csv izonamathiselwa kwishidi elihle kakhulu. Ngaphezu kwalokho, njengoba sikwazi ukubona, kukhonjiswa kahle kakhulu kunangesikhathi sokusebenzisa Indlela 1. Ikakhulu, akukho sengezo losayizi owengeziwe weseli oludingekayo.
Isifundo: Ungashintsha kanjani ukufaka ikhodi ku-Excel
Indlela 3: vula ngethebhu yefayela
Kukhona nendlela yokuvula idokhumenti. Csv ngokusebenzisa ithebhu Ifayela Izinhlelo ze-Excel.
- Hola i-Excel bese udlulela kuthebhu Ifayela. Chofoza entweni "Vula"etholakala ohlangothini lwesobunxele lwewindi.
- Iwindows liqala I-conductor. Kufanele uhambise kwisikhombi esikwi-hard drive ye-PC noma kwimidiya esikhiphekayo lapho kutholakala khona idokhumenti esithandayo Csv. Ngemuva kwalokho, udinga ukuphinda uguqule uhlobo lokushintsha ifayela ewindini liye kwisikhundla "Wonke amafayela". Kulesi simo kuphela idokhumenti Csv izokhonjiswa efasiteleni njengoba akuyona ifayili elijwayelekile le-Excel. Ngemuva kokuthi kuboniswe igama ledokhumenti, likhethe bese uchofoza inkinobho "Vula" phansi kwewindi.
- Ngemuva kwalokho, iwindows izoqala Amakhosi wombhalo. Zonke ezinye izinto ezenziwa ngokwama-algorithm afanayo nakuwo Indlela yesi-2.
Njengoba ukwazi ukubona, naphezu kwezinkinga ezithile ngamadokhumenti efomethi yokuvula Csv ku-Excel, usengazixazulula. Ukuze wenze lokhu, sebenzisa ithuluzi le-Excel elakhelwe ngaphakathi elibizwa Umbhalo wizadi. Noma, ezimweni eziningi, indlela ejwayelekile yokuvula ifayela ngokuchofoza kabili inkinobho yegundane kwesobunxele egameni layo yanele.
