Momwe mungatsegulire CSV ku Excel

Zolemba za CSV zimagwiritsidwa ntchito ndi mapulogalamu ambiri apakompyuta kuti asinthane ndi deta pakati pa wina ndi mnzake. Zingawonekere kuti mukulukulitsa mutha kuyambitsa fayilo yotereyi ndi dinani batani lakumanzere, koma osati nthawi zonse, zomwe zawonetsedwa motere, zomwe zimawonetsedwa bwino. Zowona, pali njira ina yowonetsera zomwe zili mu fayilo ya CSV. Tiyeni tiwone momwe zitha kuchitikira.

Kutsegula zikalata za CSV

Dzinalo la mtundu wa CSV ndicho chidule cha dzinalo "Comma, Olekanitsidwa", lomwe limamasuliridwa ku Russia, monga "Makhalidwe ogawanika ndi masewera". Zowonadi, mu mafayilo awa, makanema amakambalala, ngakhale olankhula ku Russia, mosiyana ndi zonena za Chingerezi, ndi zonse, ndichikhalidwe kugwiritsa ntchito comma.

Mukamaitanitsa mafayilo a CSV kuti akwaniritse, vuto lokhala likusewera ndizofunikira. Nthawi zambiri, zikalata zopezeka pa intaneti zimakhazikitsidwa ndi mawu a "Krakoyabram", ndiye kuti, zilembo zosawerengeka. Kuphatikiza apo, vuto lomwe limachitika pafupipafupi ndi nkhani yokhudza kusokonekera kwa olekanitsa. Choyamba, izi zimadetsa zochitika zomwe tikuyesa kutsegula chikalata chopangidwa mu mtundu wina wolankhula Chingerezi, pabwino, womwe ulipo ndi wogwiritsa ntchito chilankhulo cha Russia. Kupatula apo, code code, olekanitsa ndi a comma, ndipo olankhula-aku Russia amazindikira kuti malowo. Chifukwa chake, zotsatira zolakwika zimapezeka. Tidzauza momwe angathetse mavutowa akamatsegula mafayilo.

Njira 1: Kutsegulira kwa fayilo wamba

Koma poyamba tidzayang'ana pa njira yomwe Chikalata cha CSV chimapangidwa mu pulogalamu yolankhula Chirasha ndipo yakonzeka kale kutsegula bwino popanda zowonjezera pa zomwe zili.

Ngati pulogalamu ya Excel yaikidwa kale kuti itsegule zikalata za CSV pakompyuta yanu mosavomerezeka, ndiye kuti munthawi imeneyi ndikwanira dinani batani lakumanzere, ndipo lidzatsegulidwa. Ngati kulumikizidwa sikunakhazikitsidwe, ndiye kuti mufunika kuchita zingapo zowonjezera.

1. Kukhala mu Windows Exploler mu chikwatu komwe fayilo ilipo, dinani batani la mbewa kumanja. Zosankha zamitunduyo zayambitsidwa. Sankhani chinthucho "tsegulani ndi thandizo" mkati mwake. Ngati mndandanda wa "Microsoft Office" imapezeka pamndandanda wapamwamba, kenako dinani. Pambuyo pake, chikalatacho chimangoyambira pa nthawi yanu yopambana. Koma ngati simuzindikira izi, dinani pa "Sankhani pulogalamuyo" udindo.



2. Zenera losankha pulogalamu yotseguka. Apa, kachiwiri, ngati muwona dzinalo "Microsoft Office" mu mapulogalamu a "chidindo" cholongosoka, kenako sankhani batani la "Ok". Koma izi zisanachitike, ngati mukufuna kuti mafayilo a CSV nthawi zonse amatsegulidwa pochita sease ya pulogalamuyi, kenako onetsetsani kuti pulogalamu ya mafayilo onse ya mtundu uwu "inaima chizindikiro.

   

   Ngati simunapeze dzina "Microsoft Office" muzenera posankha pulogalamu, kenako dinani pa "chidule ..." batani.



3. Pambuyo pake, zenera lofufuza lidzayamba pakompyuta yokhazikitsidwa pakompyuta yanu. Monga lamulo, chikwatu ichi chimatchedwa "Mafayilo a Pulogalamu" ndipo ali muzu wa C. Muyenera kusintha kwa wofufuza ku adilesi yotsatirayi:

   C: \ mafayilo a pulogalamu \ Microsoft Office \ Office№

   Pomwe, m'malo mwa "Ayi." Mtundu wa Phukusi la Microsoft Office lomwe limakhazikitsidwa pakompyuta yanu liyenera kukhala pakompyuta yanu. Monga lamulo, chikwatu choterocho ndi chimodzi, kotero sankhani malowa, chilichonse chomwe chiri sichili. Mukamasunthira ku chikwatu chotchulidwa, yang'anani fayilo yotchedwa "Excel" kapena "Excel.exe". Mtundu wachiwiri wa dzinalo udzakhala mu mwambo womwe mwatha kuyankhula mu Windows Explorer. Unikani fayilo iyi ndikudina batani "lotseguka ...".



4. Pambuyo pake, pulogalamu ya Microsoft Excel idzawonjezedwa ku zenera lomwe lasankha, lomwe talankhula kale. Mungofunika kuwunika dzina lomwe mukufuna, tsatirani kupezeka kwa chojambulira pafupi ndi mawonekedwe a fayilo (ngati mukufuna kuti mutsegule batani la CSV pabwino) ndikudina batani la "Ok".

Pambuyo pake, zomwe zili mu chikalata cha CSV zidzatsegulidwa. Koma njirayi ndi yoyenera pokhapokha ngati palibe zovuta zakuthana kapena map a cyrillic. Kuphatikiza apo, monga tikuwona, muyenera kuchita kusintha kwa chikalatacho: Popeza kuti zidziwitso sizili konsekonse mu maselo apano, ayenera kukulitsidwa.

Njira 2: Kugwiritsa Ntchito Luso

Mutha kulowetsa deta kuchokera ku chikalata cha CSV pogwiritsa ntchito chida chophatikizidwa, chomwe chimatchedwa wizard.

1. Thamangani pulogalamu ya Excel ndikupita ku tabu ya data. Pa tepiyo mu "zopeza za data zakunja" dinani batani, lomwe limatchedwa "kuchokera palemba".



2. Zenera lolemba zolemba limayambitsidwa. Lowani mu chikwatu cha malo a fayilo ya CVS. Fotokozerani dzina lake ndikudina batani la "Log Log Lognit", lomwe lili pansi pazenera.



3. Wiz Wizzard yaikidwa. Mu "Force Forcectings", kusinthaku kuyenera kuyimilira "ndi malo opatulika". Kuti muwonetsetse bwino zomwe zasankhidwa, makamaka ngati zili ndi cyrillic, zindikirani kuti "Unicode (UTF-8)" mtengo wake umakhazikitsidwa kuti "Fayilo". Mosakayikira, muyenera kuyikhazikitsa pamanja. Pambuyo pazosintha zonse pamwambapa zimakhazikitsidwa, dinani batani la "lotsatira".



4. Kenako zenera lachiwiri laakulu limatseguka. Apa ndikofunikira kudziwa kuti ndi mtundu uti womwe ndi wosiyanitsa mu chikalata chanu. M'malo mwathu, pantchito imeneyi pali mfundo yokhala ndi comma, monga chikalatacho ndi ku Russia ndikulankhula kwa matembenuzidwe apabanja. Chifukwa chake, m'magawo okhazikika "olekanitsa ndi" timakhazikitsa lingaliro la "mfundo ndi malo". Koma ngati mungalowe fayilo ya ma cvs yomwe imakonzedwa kuti ikhale yolankhula chingerezi, ndipo wolankhula wa a Comma ali mmenemo ndi comma, ndiye kuti uyenera kuyatsa lingaliro ku "comma". Pambuyo pa zosintha pamwambapa zimapangidwa, dinani batani la "lotsatira".



5. Zewi lachitatu la lembalo laizi litsegule. Monga lamulo, palibe zowonjezera zomwe siziyenera kubereka. Kupatula kokha, ngati imodzi mwazomwe zaperekedwa mu chikalatacho zili ndi deti. Pankhaniyi, ndikofunikira kutsamira mzatiwu pansi pazenera, ndipo kusinthana kwa "Column Form 'block yakhazikitsidwa ku" deti ". Koma mwankhanza kwambiri, zosintha zomwe "General" zidayikidwa. Chifukwa chake mutha kungokanikizani batani la "Maliza" pansi pazenera.



6. Pambuyo pake, zenera laling'ono la data limatsegulidwa. Iyenera kuwonetsa mgwirizano wa malo otsalira a cell omwe deta yomwe yatumizidwa. Izi zitha kuchitika pongokhazikitsa cholozera m'munda wa zenera, kenako ndikudina batani la mbewa lamanzere m'gawo limodzi lofanana. Pambuyo pake, magwiridwe ake alembedwa m'munda. Mutha kupanga batani la "OK".



7. Pambuyo pa izi, zomwe zili mu fayilo ya CSV iikidwa papepala la Excel. Komanso, monga tikuonera, zikuwonetsedwa bwino kuposa momwe mungagwiritsire ntchito njira 1. Makamaka, zowonjezera zowonjezera za maselo sizofunikira.

Phunziro: Momwe Mungasinthire Kukhazikitsidwa Kupambana

Njira 3: Kutsegula kudzera pa fayilo

Palinso njira yotsegulira chikalata cha CSV kudzera pa fayilo ya fayilo ya Excel.

1. Thawirani Excel ndikusunthira ku tabu ya fayilo. Dinani pa "Lotseguka" yomwe ili kumanzere kwa zenera.



2. Zenera la wopondera limayambitsidwa. Iyenera kusunthira mu chikwatuchi pa hard disk ya PC kapena papepala yochotsa mtundu wa CSV imakonda. Pambuyo pake, muyenera kukonzanso mtundu wa fayilo kusinthira mu "mafayilo onse" zenera. Pokhapokha ngati izi, chikalata cha CSV chidzawonetsedwa pazenera, chifukwa si fayilo ya Excel Excel. Pambuyo pa dzina lolemba likuwonetsedwa, sankhani ndikudina batani "lotseguka" pansi pazenera.



3. Pambuyo pake, zenera la Wizard liyamba. Zochita zina zonse zimachitika ndi algorithm yemweyo monga momwe mwakhalira 2.

Monga mukuwonera, ngakhale mukukhala ndi vuto la kutsegulidwa kwa mawonekedwe a CSV pa bwino, ndizothekabe kuti muthane nawo. Kuti muchite izi, muyenera kugwiritsa ntchito chida chophatikizidwa, chomwe chimatchedwa mutu waluso. Ngakhale, kwa zinthu zambiri, zimakhala zokwanira kugwiritsa ntchito njira yotsegulira fayilo ndi kuwonekera kawiri koloko batani la mbewa.