Ungalivula kanjani i-CSV: 7 Izinketho zomsebenzi

I-CSV (amanani ahlukaniswe ngokhefana) yifayela lefomethi yombhalo elenzelwe ukubonisa idatha ye-tabular. Ngasikhathi sinye, amakholomu ahlukaniswe yikhefana ne-semicolon. Sifunda, ngezicelo ongavula ngazo le ndlela.

Izinhlelo ze-CSV

Njengomthetho, amapulani ethebula asetshenziselwa ukubheka kahle okuqukethwe yi-CSV, futhi abahleli bombhalo bangafakwa ekuhleleni. Ake sibheke imininingwane eminingi i-algorithm yezenzo lapho evula izinhlelo ezahlukahlukene zalolu hlobo lwamafayela.

Indlela 1: I-Microsoft Excel

Cabanga ukuthi ungagijima kanjani i-CSV kwiprosesa yombhalo ethandwayo, efakiwe kwiphakethe le-Microsoft Office.

1. Gijima i-Excel. Iya kuthebhu ethi "File".



2. Ukuya kule thebhu, chofoza u- "Vula".

   

   Esikhundleni salezi zenzo, kungenzeka ukuthi usebenzise i-CTRL + O ephepheni.

3. Iwindows "yokuvula idokhumenti" ivela. Ngalo, uzothuthela lapho i-CSV itholakala khona. Qiniseka ukuthi ukhetha "amafayela wombhalo" noma "wonke amafayela" kusuka kuhlu lwefomethi. Ngaphandle kwalokho, ifomethi oyifunayo ayiboniswanga. Bese ukhetha le nto bese uchofoza u- "Vula", ozobiza "inkosi yemibhalo".

Kunenye indlela yokuya ku- "Master of Experts".

1. Hambisa esigabeni "sedatha". Cindezela i- "Kusuka Embhalweni", etholakala "ekutholeni idatha yangaphandle" block.



2. Ithuluzi elithi "Ifayela Lombhalo Wezokungenisa" liyavela. Njengasewindini elithi "Ukuvula Idokhumenti", kuyadingeka ukuya endaweni yendawo yento bese umaka. Awudingi ukuthi ukhethe amafomethi, kusukela lapho usebenzisa leli thuluzi, izinto eziqukethe umbhalo zizokhonjiswa. Chofoza u- "Ngenisa".



3. Kwethulwa "I-Master of Texts". Ewindini layo lokuqala, "chaza ifomethi yedatha" Faka inkinobho yomsakazo ku- "Ngezikhundla" Zabahlukanisi. Endaweni ethi "Ifomethi yefayela", ipharamitha ye-Unicode (UTF-8) kufanele ibe. Cindezela "Okulandelayo".



4. Manje udinga ukwenza igxathu elibaluleke kakhulu, elizoncika ekuqondeni kokuboniswa kwedatha. Kuyadingeka ukukhombisa ukuthi kubhekwa njengehlukanisi: iphuzu elinekhefana (;) noma ikhefana (,). Iqiniso ngukuthi amazinga ahlukahlukene asebenza emazweni ahlukene. Ngakho-ke, ngemibhalo yolimi lwesiNgisi, ukhefana usetshenziswa kaningi, futhi ngokukhuluma isiRussia - iphuzu elinekhefana. Kepha kukhona okuhlukile lapho abahlukanisi besebenza ngokuhlukile. Ngaphezu kwalokho, ezimweni ezingavamile kakhulu, ezinye izimpawu zisetshenziswa njengabahlukanisi, njenge-wavy line (~).

   Ngakho-ke, umsebenzisi kufanele azifake, noma ngabe uphawu oluthile lokwehlukanisa noma uphawu olujwayelekile lwezimpawu zokuloba. Kungenziwa ngokubheka umbhalo oboniswa endaweni ethi "Isampula Yokukhethwa Kwedatha" futhi esekelwe ku-Logic.

   

   Ngemuva kokuthola umsebenzisi ukuthi luhlobo luni lwesibonakaliso olwehlukanisayo, eqenjini elithi "uphawu-isihlukanisi" kufanele uhlole ibhokisi lokuhlola eliseduze nephuzu "iphuzu ngekhefana" noma "ikhefana". Kuwo wonke amanye amabhokisi okuhlola kufanele asuswe. Bese uchofoza "Okulandelayo".



5. Emva kwalokho, iwindi livuleka lapho ngokukhetha ikholomu ethile kwindawo "yesampula yesampula yesampula", unganikeza ifomethi kuyo ngokunemba kokubonisa imininingwane eshintshanisa imisebe phakathi kwale nhlangano elandelayo :
   • yeqa amakholomu;
   • Imibhalo;
   • usuku;
   • Jikelele.

   Ngemuva kokwenza ukukhohlisa, chofoza u- "Qeda".



6. Kuvela iwindi, lapho ibuzwa khona lapho idatha engenisiwe eshidini iseshidini. Ngokushintsha inkinobho yomsakazo, ungakwenza eshidini elisha noma elivele elikhona. Endabeni yokugcina, futhi ungacacisa izixhumanisi zendawo ngqo enkundleni ehambisanayo. Ukuze ungazifaki ngesandla, kwanele ukubeka ikhesa kulo mkhakha, bese uqokomisa iseli elizoba yinto ephezulu yesobunxele ye-array lapho idatha izongezwa khona. Ngemuva kokufaka izixhumanisi, cindezela KULUNGILE.



7. Okuqukethwe kwento kuzoboniswa ephepheni le-Exel.

Isifundo: Ungayisebenzisa kanjani i-CSV ku-Excel

Indlela 2: I-libreoffice calc

I-CURV CSV ikwazi kanye nezinye iziproseji zethebula - I-Calc, efakiwe emhlanganweni we-libreOffice.

1. Run libreoffice. Chofoza u- "Vula ifayela" noma usebenzise i-CTRL + O.

   

   Ungashintsha futhi ngemenyu ngokuchofoza "ifayela" futhi "Vula ...".

   

   Ngaphezu kwalokho, iwindi lokuvula ungathola ngqo ngokusebenzisa isikhombimsebenzisi se-CALS. Ukuze wenze lokhu, ngenkathi ku-libreoffice calc, chofoza isithonjana njengefomu lefolda noma uhlobo lwe-CTRL + o.

   

   Enye inketho inikezela ngenguquko elandelanayo ku- "Ifayela" kanye "Vula ..." Izinto.



2. Ukusetshenziswa kwanoma yikuphi okukhethwa kukho okuningi okusohlwini okuzoholela ekubonakaleni kwewindows "evulekile". Hambisa kukho endaweni ye-CSV, Maka bese ucindezela u- "Vula".

   

   Kepha ungakwenza ngisho ngaphandle kokwethula iwindi "elivulekile". Ukuze wenze lokhu, donsela csv kusuka ku- "Explorer" ku-libreofis.



3. Ithuluzi elithi "Ukungeniswa kombhalo" liyavela, okuyisifaniso se- "Umbhalo Wizard" ku-Excel. Inzuzo ukuthi kulokhu bekungeke kube nokuhamba phakathi kwamafasitela ahlukene, ukwenza izilungiselelo zokungenisa, ngoba wonke amapharamitha adingekayo atholakala ewindini elilodwa.

   Masinyane iya eqenjini lezilungiselelo "Ukungenisa". Endaweni "yokufaka encuding", khetha i- "Unicode (UTF-8)" Inani uma elikhonjiswa lapho. Endaweni "yolimi", khetha ulimi lombhalo. Endaweni ethi "Ukusuka emugqeni", udinga ukucacisa ukuthi iyiphi intambo okufanele iqale ukungenisa okuqukethwe. Ezimweni eziningi, awudingi ukwenza ushintsho kule parameter.

   Okulandelayo, yiya eqenjini "Lokwehlukanisa". Okokuqala, kuyadingeka ukufaka inkinobho yomsakazo endaweni "yokwehlukanisa". Ngaphezu kwalokho kusisekelo esifanayo esasibhekwa lapho sisebenzisa i-Excel, kuyadingeka ukucacisa ngokubeka ibhokisi elibhekene nephuzu elithile, elizodlalwa yindawo yokwahlukanisa: i-semicolon noma ikhefana.

   "Amanye amapharamitha" ashiya engashintshiwe.

   Ukubona kuqala ukuthi yiluphi ulwazi olungenisiwe lubukeka lapho ushintsha izilungiselelo ezithile, ungangeza phansi kwewindi. Ngemuva kokungena kuwo wonke amapharamitha adingekayo, chofoza Kulungile.



4. Okuqukethwe kuzovezwa nge-libreofis calc interface.

Indlela 3: OpenOffice Calc

Ungabuka CSV usebenzisa enye processor tabular - OpenOffice Calc.

1. Gijimani i-OoPoopis. Ngo kuwindo, chofoza "Vula ..." noma usebenzise Ctrl O.

   

   Ungasebenzisa futhi imenyu. Ukuze wenze lokhu, iya ku- "File" futhi "Vula ...".

   

   Njengokusetshenziswa kwendlela nohlelo lwangaphambilini, ungafika ewindini elivulekile lokuvula ngqo ngokusebenzisa isikhombimsebenzisi se-calc. Kulokhu, udinga uchofoze isithonjana esithombeni sefolda noma usebenzise yonke i-CTRL efanayo ye-O.

   

   Ungasebenzisa futhi imenyu ngokuya kuyo yi- "FILE" kanye "Vula ..." Izikhundla.



2. Ku-window ukuvulwa ukuthi kuvela, iya CSV indawo endaweni, ukhethe lokhu into bese ucindezela u- "Vula".

   

   Ungenza ngaphandle kokwethula leli windi, umane nje une-csv ecwebezelayo kusuka ku- "Explorer" e-Openofefis.



3. Noma iyiphi isethi yezenzo ezichaziwe izoholela ekusebenzeni kwewindows "Ukungeniswa kombhalo", okufana kakhulu nokubukeka, kanye nokusebenza kwegama elinegama elifanayo ku-libreOffice. Ngokuvumelana nalokho, izenzo ziyefana. Ezinkambu ze- "Encoding" kanye "nolimi", umbukiso "i-Unicode (UTF-8)" kanye nolimi lwamanje lwedokhumenti, ngokulandelana.

   Ku-block "yepharamitha yehlukanisi", beka inkinobho yomsakazo eduze kwesigaba esithi "Uhlukanisi", ngemuva kwalokho uhlole into ("iphuzu nge-semicolon" noma "ikhomi"), ehambelana nohlobo lokwehlukanisa kudokhumenti.

   Ngemuva kokwenza izenzo ezibekiwe, uma idatha esefomini ekhonjiswe ewindini elingezansi ikhonjiswa kahle, chofoza KULUNGILE.



4. Idatha izoboniswa ngempumelelo ngokusebenzisa i-OpenFIS calc interface.

Indlela 4: Incwajana 4

Ungafaka incwadi evamile yokubhalela ukuhlela.

1. Qalisa incwajana. Kumenyu, chofoza "Ifayela" nelithi "Vula ...". Noma ungafaka isicelo se-CTRL + O.



2. Iwindi lokuvula livela. Iya kuyo endaweni ye-CSV. Ensimini yokubonisa ifomethi, setha "wonke amafayela". Maka into oyifunayo. Bese ucindezela u- "Vula".



3. Into izovulwa, kepha, hhayi, hhayi ngefomu le-tabular, esilibonile kumaprosesa etafula, nasembhalweni. Kodwa-ke, encwadini yokubhalela kulula kakhulu ukuhlela izinto zale fomethi. Kuyadingeka kuphela ukuthi ubheke ukuthi umugqa ngamunye wetafula uhambelana nentambo yombhalo kubhukwana, futhi amakholomu ahlukaniswe ngabahlukanisi ngesimo sama-comma noma amachashazi anamakhethini. Njengoba kunikezwe lolu lwazi, kungenzeka ukufaka isandla kalula noma yiluphi ushintsho, amanani wombhalo, ukwengeza izintambo, ukususa noma ukwengeza abahlukanisi lapho kunesidingo khona.

Indlela 5: I-Notepad ++

Ungavula futhi usebenzise umhleli wombhalo osethuthukile - incwajana +.

1. Vula incwajana ++. Chofoza kumenyu yefayela. Okulandelayo, khetha u- "Vula ...". Ungafaka futhi i-CTRL + O.

   

   Enye inketho ifaka ukucindezela iphaneli kusithonjana sefolda.



2. Iwindi lokuvula livela. Kudinga ukuhambisa kuleyo ndawo yohlelo lwefayela lapho i-CSV efiselekayo itholakala khona. Ngemuva kokukhethwa kwayo, cindezela "Vula".



3. Okuqukethwe kuzovezwa ku-Notepad ++. Imigomo yokuhlela iyafana nalapho isebenzisa incwadi yokubhalela, kepha uhlobo olungeyona inhlobo ++ lunikeza inani elikhudlwana lamathuluzi wokukhohlisa idatha ehlukahlukene.

Indlela 6: USafari

Bheka okuqukethwe kunguqulo yombhalo ngaphandle kwekhono lokuyihlela, ungasesiphequluli seSafari. Iningi leziphequluli ezithandwayo azinikezi ithuba elinjalo.

1. Run safari. Chofoza u- "FILE". Ngokulandelayo chofoza ku- "Vula Ifayela ...".



2. Iwindi lokuvula livela. Kudinga ukuthuthela endaweni lapho i-CSV itholakala khona, umsebenzisi afuna ukubukwa. Ngokuphoqelelwa, ukushintshwa kwefomethi ewindini kufanele kusethwe ku- "Wonke amafayela". Ngemuva kwalokho yenza ukukhetha kwento ngesandiso se-CSV bese uqhafaza Vula.



3. Okuqukethwe kwento kuzovulwa ewindini elisha le-SFARI ngefomu lombhalo, njengoba kwenzeka kubhukwana. Kuliqiniso, ngokungafani ne-Notepad, hlela idatha eSafari, ngeshwa, ngeke kusebenze, njengoba ungabuka kuphela.

Indlela 7: I-Microsoft Outlook

Ezinye izinto ze-CSV zingama-imeyili e-imeyili athunyelwa kwikhasimende le-imeyili. Zingabukwa kusetshenziswa uhlelo lwe-Microsoft Outlook ngokukhiqiza inqubo yokungenisa.

1. Run outluk. Ngemuva kokuvula uhlelo, iya kuthebhu ethi "Ifayela". Bese uchofoza Vula kumenyu eseceleni. Okulandelayo chofoza "ukungenisa".



2. "I-Master of Ngenisa kanye Nokuthekelisa" yethulwa. Ohlwini olwethuliwe, khetha u- "Ngenisa kusuka kolunye uhlelo noma ifayela". Cindezela "Okulandelayo".



3. Ewindi elilandelayo, khetha uhlobo lwento yokungeniswa. Uma sizongenisa i-CSV, khona-ke udinga ukukhetha "inani elihlukaniswe yi-Commas". Chofoza u- "Okulandelayo".



4. Ewindi elilandelayo, cindezela inkinobho ethi "Ukubuyekezwa ...".



5. Iwindi le- "Overview" liyavela. Kufanele iye endaweni lapho incwadi ngefomethi ye-CSV itholakala khona. Khombisa le nto bese uqhafaza u- "KULUNGILE".



6. Ibuyisa "i-Master of ukungenisa kanye nokungenisa ngaphandle". Njengoba ubona, ku- "Ifayela le-Actionlic" ndawo, ikheli lengezwe endaweni yento ye-CSV. Evikini le- "Parameters", izilungiselelo zingashiywa ngokuzenzakalelayo. Chofoza u- "Okulandelayo".



7. Ngemuva kwalokho udinga ukumaka leyo folda ebhokisini leposi lapho ufuna ukufaka khona izincwadi ezingeniswa ezweni.



8. Iwindi elilandelayo libonisa igama lesinyathelo esizokwenziwa ngohlelo. Nakhu kwanele ukuchofoza u- "Ready."



9. Ngemuva kwalokho, ukubuka idatha engenisiwe, dlulela ku- "Thumela futhi uthole" ithebhu. Endaweni eyalandela yesibonisi sohlelo, khetha ifolda lapho kwangeniswa khona incwadi. Ngemuva kwalokho, enkabeni yohlelo, kuzovela uhlu lwezincwadi ezikule folda. Mane uqhafaze encwadini oyifunayo kabili ngenkinobho yegundane yesobunxele.



10. Le ncwadi engeniswe entweni ye-CSV izovulwa kuhlelo lwe-Outluk.

Kuliqiniso, kufanelekile ukuqaphela ukuthi le ndlela ingenziwa zonke izinto zefomethi ye-CSV, kepha izinhlamvu zazo kuphela ezazihambelana nezinga elithile, okungukuthi, ziqukethe izinkambu: I-Theme, Ikheli Le-Sender, Ikheli Lamukelayo, njll.

Njengoba ubona, kunezinhlelo ezimbalwa zokuvula izinto ze-CSV. Njengomthetho, kungcono ukubuka okuqukethwe kwamafayela anjalo kuma-processor we-tabular. Ukuhlela kungenziwa njengombhalo kubahleli bombhalo. Ngaphezu kwalokho, kunama-CSV ahlukile anesakhiwo esithile sezinhlelo ezikhethekile ezisebenza, njengamakhasimende eposi.