Ifayela le-CSV liyithuluzi elinamandla lokugcina idatha, kodwa ngezinye izikhathi udinga ukuliguqulela ku-Excel ukuze usebenzise ngokugcwele izici ze-office suite. Kulesi sihloko, ngizokukhombisa Isinyathelo ngesinyathelo ungayiguqula kanjani i-CSV ibe yi-Excel ngokushesha futhi kalula. Lungela yingcweti le nqubo futhi uthole okuningi kudatha yakho!
Liyini ifayela le-CSV futhi kungani liguqulelwa?
Ngaphambi kokuthi singene enqubweni yokuguqula, kubalulekile ukuqonda ukuthi liyini ifayela le-CSV. Igama elithi CSV limele "Amanani Ahlukaniswe Ngokhefana" o "Amanani Ahlukaniswe Ngokhefana" ngeSpanishi. Kuyifomethi yefayela elula egcina idatha yethebula embhalweni ongenalutho.
Ubulula bama-CSV buwenza alungele shintshanisa ulwazi phakathi kwezinhlelo ezahlukene, kodwa banokulinganiselwa ekufometheni nasezicini ezithuthukisiwe. Yilapho i-Excel ingena khona, inikezela ngesixhumi esibonakalayo esibonakalayo namathuluzi okuhlaziya anamandla.
Indlela 1: Ngenisa Okuqondile ku-Excel
Indlela eqondile kakhulu yokuguqula i-CSV iye ku-Excel ukusebenzisa uhlelo lweMicrosoft uqobo. Landela lezi zinyathelo:
1. vula i-excel bese udala ibhuku lokusebenza elisha elingenalutho.
2. Yiya kuthebhu "Idatha" kuribhoni.
3. Chofoza "Thola idatha" bese ukhetha "Kusuka kufayela" > "Kusuka ku-CSV".
4. Phequlula bese ukhetha ifayela lakho le-CSV, bese uchofoza "Ukungenisa".
5. Ewindini lokuhlola kuqala, qiniseka ukuthi izilungiselelo zilungile (abanqamuleli, umbhalo wekhodi, njll.).
6. Chofoza "Phatha" ukuqedela ukungenisa.
Le ndlela ngokushesha nangempumelelo ezimweni eziningi, kodwa ingase ithule izinkinga ngamafayela e-CSV ayinkimbinkimbi kakhulu noma lawo anombhalo wekhodi okhethekile.
Indlela yesi-2: Shintsha isandiso sefayela
Enye indlela, kodwa enconywa kancane, indlela yokushintsha isandiso sefayela ngesandla:
1. Thola ifayela lakho le-CSV ku-File Explorer.
2. Iqambe kabusha bese ushintsha isandiso ".csv" por «.xls» o ".Xlsx".
3. Vula ifayela nge-Excel.
Le ndlela ingase isebenze kwezinye izimo, kodwa akuqinisekisi ukuguqulwa okuphelele. I-Excel izozama ukuhumusha okuqukethwe, kodwa ungase ulahlekelwe ukufometha noma uhlangabezane namaphutha phakathi nokungenisa.
Indlela 3: Ukusebenzisa amathuluzi aku-inthanethi
Uma ukhetha ukungafaki isofthiwe eyengeziwe, zikhona amapulatifomu ewebhu ezingakusiza ukuguqula i-CSV ibe yi-Excel:
1. Vakashela isayithi like I-Convertio o I-CloudConvert.
2. Layisha ifayela lakho le-CSV.
3. Khetha ifomethi yokuphumayo (XLSX).
4. Qala ukuguqulwa bese ulanda umphumela.
Lawa mathuluzi izinqubo zokuguqulwa ngezikhathi ezithile, kodwa khumbula ubumfihlo bedatha yakho uma usebenzisa izinsiza ze-inthanethi.
Amathiphu okuguqula ngempumelelo
Ukuqinisekisa ukuthi ukuguqulwa kwakho kwe-CSV kuye ku-Excel kuhamba kahle, gcina lawa macebiso engqondweni:
- Hlola ukubhala ngekhodi kusuka kufayela lakho le-CSV. Uma iqukethe izinhlamvu ezikhethekile, qiniseka ukuthi ukhetha ukubhala ngekhodi okulungile ngesikhathi sokungenisa.
- Naka abahlukanisayo. Nakuba ikhefana ivame kakhulu, amanye ama-CSV asebenzisa amasemikholoni noma amathebhu.
- Hlola ifomethi yedethi. I-Excel ingase ihumushe ngokungeyikho izinsuku kuye ngezilungiselelo zakho zesifunda.
- Uma i-CSV yakho inkulu kakhulu, cabanga ihlukanise ibe amafayela amancane ukwenza lula ukuphatha ku-Excel.
Inqubo ezenzakalelayo
Uma udinga ukuguqula i-CSV iye ku-Excel njalo, ungakwazi ukushintsha inqubo usebenzisa i-VBA macros ku-Excel. Nasi isibonelo esiyisisekelo:
«` vba
I-Sub ImportCSV()
Fiphalisa umzila Njengeyunithi yezinhlamvu
indlela = Application.GetOpenFilename(«Amafayela e-CSV (.CSV), .csv»)
Uma umzila <> "Amanga" Bese
With ActiveSheet.QueryTables.Engeza(Uxhumano:= _
«UMBHALO;» & umzila, Indawo:=Ibanga(«A1»))
.Name = "MyCSV"
.FieldNames = Iqiniso
.RowNumbers = Amanga
.FillAdjacentFormulas = Amanga
.PreserveFormatting = Iqiniso
.RefreshOnFileOpen = Amanga
.RefreshStyle = xlInsertDeleteCells
.SavePassword = Amanga
.SaveData = Iqiniso
.AdjustColumnWidth = Iqiniso
.RefreshPeriod = 0
.TextFilePromptOnRefresh = Amanga
.TextFilePlatform = 437
.TextFileStartRow = 1
.TextFileParseType = xlDelimited
.TextFileTextQualifier = xlTextQualifierDoubleQuote
.TextFileConsecutiveDelimiter = Amanga
.TextFileTabDelimiter = Amanga
.TextFileSemicolonDelimiter = Amanga
.TextFileCommaDelimiter = Iqiniso
.TextFileSpaceDelimiter = Amanga
.TextFileColumnDataTypes = I-Array(1, 1, 1, 1, 1)
.TextFileTrailingMinusNumbers = Iqiniso
.Vuselela IsendlaleloQuery:=Amanga
Qeda
Qeda Uma
Qeda i-Sub
"`
Le khodi ivula ibhokisi lengxoxo ukuze ukhethe ifayela le-CSV futhi ulingenise ngokuzenzakalelayo eshidini elisebenzayo. Ungayilungisa ngokwezidingo zakho ezithile.
Ukuguqulwa kwe-CSV kuye ku-Excel kuyikhono elibalulekile ekuphathweni kwedatha. Ngalawa masu namasu, uzobe ulungele guqula amafayela akho ngempumelelo futhi usebenzise ngokugcwele amakhono okuhlaziya e-Excel. Khumbula njalo qinisekisa ubuqotho bedatha yakho ngemva kokuguqulwa futhi uzizwe ukhululekile ukuzama izindlela ezahlukene ukuze uthole leyo evumelana kangcono nezidingo zakho.