Guqula i-CSV ibe yi-Excel
Donsela ifayela le-CSV bese ulanda incwadi yokusebenza ye-Excel efanele – isihlukanisi ne-encoding kutholwa ngokuzenzakalelayo, izinombolo zihlala ziyizinombolo.
Indlela okusebenza ngayo
Donsela ifayela le-CSV lapha
Ukuguqula kuqala ngokwakho.
Silifunda ngendlela efanele
Isihlukanisi ne-encoding kuyatholwa; izinombolo ziba izinombolo, ama-ID anoziro abasekuqaleni ahlala engumbhalo.
Landa i-.xlsx
Umugqa wesihloko wenziwa ube mnyama futhi uhlala ubonakala ngesikhathi uskrola.
Yeqa ukuguqula: yabelana ngamafayela e-Office ngqo
I-HelpRange ivula amafayela e-Word, e-PowerPoint nawe-Excel kusiphequluli nokuhlaziywa kwamakhasi nezimpawu zamanzi – layisha okwangempela bese uthumela isixhumanisi esisodwa esivikelekile.
Okuthunyelwa ngaphandle kusuka emabhange, ezitolo, ku-CRM nasemathuluzini ocwaningo ngokuvamile kuza njenge-CSV. Ukukuvula ngqo ku-Excel kuvame ukonakalisa izinhlamvu ezinezimpawu, kungahlukanisi lutho libe amakholomu noma kuphendule ama-ID abe izinombolo. I-.xlsx eguquliwe ivuleka kahle kuyo yonke ikhompyutha futhi ilungele ukuhlelwa, ukuhlungwa nokwabelwana.
Uma izinhlamvu ezinezimpawu ziphenduka izimpawu ezixakile
Ifayela le-CSV alinaso isilungiselelo esisho ukuthi lisebenzisa iyiphi i-encoding – izinhlelo kufanele ziqagele. Amafayela avela ezinhlelweni ezindala ze-Windows avame ukusebenzisa i-Windows-1250 noma i-Windows-1252, amasha asebenzisa i-UTF-8. Isiguquli sihlola amabhayithi efayela bese sikhetha i-encoding efanelekayo, bese sibhala ifayela le-Excel, eligcina i-encoding ngokwalo – ngakho u-ą, é, ß no-ø babukeka kahle kuyo yonke ikhompyutha.
Izinombolo, izinsuku nama-ID
Izinombolo ezilula ezifana no-1500, -3 noma 2.5 ziba izinombolo zangempela ongazihlanganisa, uzihlele futhi wenze ngazo amashadi. Emafayeleni ahlukaniswe ngama-semicolon noma ngama-tab, ukhefana wedesimali (2,5) nawo ufundwa njengenombolo, ngoba yileyo ndlela okuthunyelwa ngaphandle kwaseYurophu okukubhala ngayo. Noma yini engalahlekelwa ulwazi njengenombolo ihlala ingumbhalo: amanani anoziro abasekuqaleni (amakhodi eposi, izinombolo ze-akhawunti nezocingo, ama-ID), izinombolo ezinde kakhulu ezifana nezinombolo zamakhadi noma ze-IBAN, nezinsuku – zigcinwa ngqo njengoba zibhaliwe, ngakho i-Excel ayisoze yaphendula inombolo ye-oda ibe usuku. Uma umugqa wokuqala uyisihloko, wenziwa ube mnyama futhi uqiniswe phezulu.
Guqula i-CSV ibe yi-Excel – imibuzo
Kungani amafayela ami e-CSV evuleka njengekholomu eyodwa ku-Excel?
I-Excel iqagela isihlukanisi ngokwezilungiselelo zesistimu yakho – ifayela elinama-semicolon livuleka njengekholomu eyodwa lapho kulindelwe ukhefana, nangokuphambene. Leli thuluzi lithola isihlukanisi efayeleni ngokwalo.
Ingabe oziro abasekuqaleni nezinombolo ezinde kuyagcinwa?
Yebo. Amakhodi eposi, izinombolo zocingo nama-ID afana no-00123 ahlala engumbhalo, ngakho oziro bawo abalahleki; izinombolo ezijwayelekile ezifana no-1500 noma 2.5 (noma 2,5 efayeleni le-semicolon) ziba izinombolo ongazihlanganisa.
Ingabe niyaligcina ifayela lami?
Isikhashana nje kuphela: okulayishiwe kususwa ngokushesha ngemva kokucutshungulwa, umphumela ngemva kwemizuzu engu-30 – noma ngokushesha nge-“Susa manje”.