Zolemba Zolemba Csv yogwiritsidwa ntchito ndi mapulogalamu ambiri apakompyuta kusinthanitsa deta pakati pa wina ndi mnzake. Zikuwoneka kuti ku Excel mutha kuyambitsa fayiloyo ndikudina kawiri pa iyo ndi batani la mbewa yakumanzere, koma kutali kwambiri ndi izi nthawi zonse deta ikuwonetsedwa molondola. Zowona, pali njira inanso yowonera zambiri zomwe zili mufayilo. Csv. Tiyeni tiwone momwe angachitire izi.
Kutsegula Zikalata za CSV
Dongosolo Csv ndi chidule cha dzinalo "Makhalidwe Osiyanasiyana", yomwe imamasulira ku Russian ngati "mfundo zotsutsana ndi comma." Zowonadi, ma comas amakhala ngati olekanitsa pamafayilo awa, ngakhale ali m'matembenuzidwe aku Russia, mosiyana ndi zilembo za Chingerezi, ndichizolowezi kugwiritsa ntchito semicolon.
Mukamaitanitsa mafayilo Csv Ku Excel, vuto lenileni ndikukhazikitsa. Nthawi zambiri, zikalata zomwe Czechillic ilipo zimayambitsidwa ndi zolemba zomwe zimakhala ndi "tsitsi lopindika", ndiye kuti, zilembo zosawerengeka. Kuphatikiza apo, nkhani yodzilekanitsa ndi vuto lalikulu. Choyamba, izi zimagwira ntchito ngati tikuyesa kutsegula chikalata chomwe chidapangidwa mu pulogalamu ya chilankhulo cha Chingerezi, Excel, chojambulidwa ngati wogwiritsa ntchito Chirasha. Zowonadi, mu gwero, wopatukana ndi comma, ndipo wolankhula ku Russia amadziwa semicolon pamtunduwu. Chifukwa chake, zotsatira zolakwika zimapezekanso. Tikukuuzani momwe mungathetsere mavutowa mukatsegula mafayilo.
Njira 1: Tsegulani fayilo mwachizolowezi
Koma, choyamba, tiyang'ana kwambiri pamasankhidwe pazomwezo Csv adapangidwa mu pulogalamu ya chilankhulo cha Russia ndipo ali okonzeka kutsegulira ku Excel popanda zojambula zowonjezera zamkatimu.
Ngati Excel idakhazikitsidwa kale kuti mutsegule zikalata Csv pa kompyuta yanu mosasintha, pakadali pano, dinani fayiloyo ndikudina kawiri batani la mbewa lamanzere, ndipo lidzatsegulidwa ku Excel. Ngati kulumikizanako sikunakhazikitsidwe, ndiye kuti mukuyenera kuchita zina zowonjezera.
- Kukhala Windows Explorer mu fayilo yomwe kuli fayilo, dinani kumanja kwake. Zosintha zamakambirano zayambitsidwa. Sankhani zomwe zili mmenemo Tsegulani ndi. Ngati mndandanda womwe udatsegulidwa uli ndi dzinalo "Microsoft Office", kenako dinani pamenepo. Pambuyo pake, chikalatacho chidzangoyendetsa gawo lanu la Excel. Koma, ngati simukupeza chinthuchi, dinani pomwepo "Sankhani pulogalamu".
- Zenera losankha pulogalamuyi limatseguka. Apa, kachiwiri, ngati muli Mapulogalamu Olimbikitsidwa mudzaona dzinali "Microsoft Office"kenako sankhani ndikudina batani "Zabwino". Koma zisanachitike, ngati mukufuna mafayilo Csv nthawi zonse imatsegulidwa yokha mu Excel mukadina kawiri pa dzina la pulogalamuyo, kenako onetsetsani kuti pafupi ndi gawo "Gwiritsani ntchito pulogalamu yosankhidwa pamafayilo onse amtunduwu" panali cheke.
Ngati mayina "Microsoft Office" pawindo losankha pulogalamu yomwe simunapeze, ndiye dinani batani "Ndemanga ...".
- Pambuyo pake, zenera la Explorer lidzatsegulamo chikwatu momwe mapulogalamu amakhazikitsidwa pakompyuta yanu. Foda iyi imakonda kutchedwa "Fayilo Ya Pulogalamu" ndipo ili m'mizu ya disk C. Muyenera kupita ku Explorer pa adilesi yotsatirayi:
C: Mafayilo a Pulogalamu Microsoft Office Office№Pomwe m'malo mwa chizindikiro "№" iyenera kukhala nambala yoyimira ya Microsoft office suite yomwe idakhazikitsidwa pa kompyuta. Monga lamulo, pali chikwatu chimodzi chotere, kotero sankhani chikwatu Ofesiziribe kanthu kuchuluka kwake. Kusamukira ku chikwatu chomwe chatchulidwa, yang'anani fayilo yotchedwa CHITSANZO kapena "EXCEL.EXE". Fomu yachiwiri yopereka maina idzakhala ngati mwaphatikiza zowonjezera mu Windows Explorer. Kwezani fayiloyi ndikudina batani. "Tsegulani ...".
- Pambuyo pa pulogalamuyi "Microsoft Excel" idzawonjezeredwa pazenera losankha pulogalamuyi, yomwe tidakambirana kale. Muyenera kusankha dzina lokha lomwe mukufuna, tsata kupezeka kwa chizindikirochi pafupi ndi chomangira mitundu ya fayilo (ngati mukufuna kutsegula zikalata nthawi zonse Csv mu Excel) ndikudina batani "Zabwino".
Pambuyo pake, zomwe zalembedwa Csv idzatsegulidwa ku Excel. Koma njirayi ndi yoyenera pokhapokha ngati palibe zovuta ndi kutanthauzira kapena chiwonetsero cha zilembo za Chisililiki. Kuphatikiza apo, monga momwe tawonera, tifunikanso kusintha zolemba zina: popeza sizikhala zolondola nthawi zonse mu kukula kwa khungu, zikuyenera kukulitsidwa.
Njira yachiwiri: gwiritsani ntchito Wizard walemba
Mutha kuitanitsa zambiri kuchokera ku chikalata cha mtundu wa CSV pogwiritsa ntchito chida chomwe mwatumiza mu Excel chotchedwa Wizard walemba.
- Yambitsani pulogalamu ya Excel ndikupita pa tabu "Zambiri". Pa nthiti yomwe ili m'bokosi la chida "Kupeza deta yakunja" dinani batani lotchedwa "Kuchokera palemba".
- Zenera lotumizira zolemba limayamba. Timasamukira kumalo osungirako fayilo yomwe mukufuna CVS. Sankhani dzina lake ndikudina batani "Idyani"ili pansi pazenera.
- Zenera limayatsidwa Ambuye alemba. Mu makatani Mtundu wa data kusinthaku kuyenera kukhala pamalo Olekanitsidwa. Kuti muwonetsetse kuti zomwe zalembedwazi zikuwonetsedwa moyenera, makamaka ngati zili ndi Korergic, yang'anani pamundawo "Fayilo ya fayilo" kukhala Unicode (UTF-8). Kupanda kutero, muyenera kuyiyika pamanja. Pambuyo pazokonzedwa zonse pamwambapa, dinani batani "Kenako".
- Kenako zenera lachiwiri limatseguka. Ambuye alemba. Apa ndikofunikira kudziwa kuti ndi wodzilekanitsa uti mu chikalata chanu. M'malo mwathu, ntchito iyi imaseweredwa ndi semicolon, popeza chikalatacho ndichachilankhulo cha ku Russia ndipo chimasanjidwa makamaka ndi mapulogalamu am'nyumba. Chifukwa chake, pazokongoletsa zimatseka "Wodzilekanitsa ndi" timayang'ana bokosilo Semicolon. Koma ngati muitanitsa fayilo CVS, yomwe imapangidwa kuti ikhale yolimba ku Chingerezi, ndipo monga gawo logonamo ndi comma, ndiye kuti muyenera kuyang'ana bokosilo Comma. Zitakhazikitsidwa pamwambapa, dinani batani "Kenako".
- Windo lachitatu limatseguka Ambuye alemba. Monga lamulo, palibe zochita zowonjezera zomwe zimafunikira mmenemo. Chokhacho chokha ndikakhala kuti imodzi mwazomweziikidwa mu chikalatacho zili ngati deti. Muna kuma kiaki, osadila nkutakani ye kwikizi muna lunga-lunga, nkutakani mu lunga-lunga Column Data Format khazikikani pansi Tsiku. Koma pazambiri, makonda omwe mawonekedwe ake amakhala okwanira "General". Ndiye mutha kungodinikiza batani Zachitika pansi pazenera.
- Pambuyo pake, zenera laling'ono lolowetsa deta limatsegulidwa. Iyenera kuwonetsa maulalo a selo lamanzere lamanzere m'deralo momwe deta yomwe ingabweretsedwere imakhala. Izi zitha kuchitika mwa kungoyika chikumbutso mundawo ya zenera, kenako ndikudina kumanzere pafoniyo. Pambuyo pake, maungwe ake amalumikizidwa m'munda. Mutha kukanikiza batani "Zabwino".
- Pambuyo pake, zomwe zili mufayilo Csv ithandizika kukhala pepala labwino kwambiri. Kuphatikiza apo, monga tikuonera, zimawonetsedwa bwino kwambiri kuposa momwe tikugwiritsira ntchito Njira 1. Makamaka, palibe kukula kwapadera kwa maselo komwe kumafunikira.
Phunziro: Momwe mungasinke kusintha kwa encode ku Excel
Njira 3: tsegulani kudzera pa tsamba la File
Palinso njira yotsegulira chikalata. Csv kudzera pa tabu Fayilo Mapulogalamu a Excel.
- Tsegulani Excel ndikusunthira ku tabu Fayilo. Dinani pazinthuzo "Tsegulani"ili kumanzere kwa zenera.
- Tsamba limayamba Kondakitala. Muyenera kusamukira ku chikwatu chomwe chili pa hard drive ya PC kapena pa media momwe mungatulutsire zolemba zomwe mukufuna Csv. Pambuyo pake, muyenera kukonzanso mtundu wamtundu wa fayilo pawindo kuti "Mafayilo onse". Pazomwezi chikalata Csv adzawonetsedwa pazenera popeza si fayilo ya Excel wamba. Pambuyo polemba dzina la chikalatacho, sankhani ndikudina batani "Tsegulani" pansi pazenera.
- Pambuyo pake, zenera liyamba Ambuye alemba. Zochita zina zonse zimachitidwa molingana ndi algorithm yomweyo monga Njira 2.
Monga mukuwonera, ngakhale pali zovuta zina ndi zikalata zoyambira Csv ku Excel, mutha kuwathetsabe. Kuti muchite izi, gwiritsani ntchito chida chomwe ndi Excel chotchedwa Wizard walemba. Ngakhale, nthawi zambiri, ndikokwanira kugwiritsa ntchito njira yokhayo yotsegulira fayilo ndikudina kawiri batani la mbewa kudzina lake.
