CSV (Malamulo Osiyana-siyana) ndi fayilo yolemba yomwe yapangidwa kuti isonyeze deta yamtundu. Pankhaniyi, zipilalazo zimasiyanitsidwa ndi makina ndi semicolon. Timaphunzira, mothandizidwa ndi ntchito zomwe mungatsegule mtunduwu.
Mapulogalamu ogwira ntchito ndi CSV
Monga lamulo, zojambulazo zimagwiritsidwa ntchito kuyang'ana zinthu za CSV molondola, ndipo olemba olemba angagwiritsidwe ntchito kuwamasulira. Tiyeni tiyang'ane mwachidwi momwe zinthuzo zingakhalire poyambitsa mapulogalamu osiyanasiyana a fayiloyi.
Njira 1: Microsoft Excel
Lingalirani momwe mungagwiritsire ntchito CSV muwotchuka wa Excel Word processor, womwe uli nawo mu Microsoft Office suite.
- Thamani Excel. Dinani tabu "Foni".
- Pitani ku tabu iyi, dinani "Tsegulani".
Mmalo mwa zochitika izi, mukhoza kugwiritsa ntchito mwachindunji pa pepala. Ctrl + O.
- Awindo likuwoneka "Chizindikiro Chotsegula". Gwiritsani ntchito kusamukira kumene CSV ili. Onetsetsani kuti muzisankha kuchokera pa mndandanda wa mawonekedwe a mawonekedwe "Mafayilo Malembo" kapena "Mafayi Onse". Apo ayi, mtundu wofunikila sumangosonyezedwa. Kenaka lembani chinthu ichi ndikusindikiza "Tsegulani"zomwe zidzapangitse "Master Text".
Pali njira ina yopitira "Master Text".
- Pitani ku gawo "Deta". Dinani pa chinthucho "Kuchokera m'malemba"adaikidwa mu chipika "Kutenga Deta Zakunja".
- Chida chikuwonekera "Mangani Ndemanga Yakale". Monga ngati pawindo "Chizindikiro Chotsegula", apa mukufunika kupita ku dera la chinthucho ndi kuzilemba. Palibe chifukwa chosankhira mawonekedwe, popeza pogwiritsa ntchito chida ichi, zinthu zomwe zili ndi malemba zidzawonetsedwa. Dinani "Lowani".
- Iyamba "Master Text". Muwindo lake loyamba "Tchulani mawonekedwe a deta" ikani batani pa wailesi "Zopanda malire". Kumaloko "Fomu ya Fayilo" payenera kukhala palipakati "Unicode (UTF-8)". Dikirani pansi "Kenako".
- Tsopano muyenera kuchita sitepe yofunika kwambiri, yomwe idzaonetsetsa kuti deta ikuwonetseratu molondola. Zimayenera kufotokoza zomwe zimadziwika kuti ndizolekanitsa: semicolon (;) kapena comma (,). Chowonadi ndi chakuti m'mayiko osiyanasiyana mu ndondomekoyi, miyezo yosiyana ikugwiritsidwa ntchito. Motero, comma imagwiritsidwa ntchito nthawi zambiri pa malemba a Chingerezi, ndipo semicoloni imagwiritsidwa ntchito pamakalata olankhula Chirasha. Koma pali zosiyana pamene omangika akugwiritsidwa ntchito mozungulira. Kuonjezera apo, mu zochitika zosawerengeka kwambiri, zizindikiro zina zimagwiritsidwa ntchito ngati olekanitsa, mwachitsanzo, mzere wa wavy (~).
Choncho, wogwiritsa ntchitoyo mwiniyo ayenera kukhazikitsa ngati pachikhalidwe ichi chikhalidwe chake chimakhala ngati chimbudzi kapena chizoloŵezi chodziwika bwino. Iye akhoza kuchita izi mwa kuyang'ana palemba lomwe likuwonetsedwa mu "Kusambidwa kwa deta yachitsanzo" ndi malingaliro.
Pambuyo pa wogwiritsa ntchitoyo, adziwe kuti ndiwe wolekanitsa "Chidwi cha" delimiter "ndi" fufuzani bokosi pafupi "Semicolon" kapena "Comma". Zinthu zina zonse siziyenera kutsekedwa. Ndiye pezani "Kenako".
- Pambuyo pake zenera zimatsegulidwa kumene, posankha gawo linalake m'derali "Kusambidwa kwa deta yachitsanzo", mukhoza kuyika mtundu wa maumboni owona bwino "Fomu ya Dongosolo la Column" mwa kusintha batani pa wailesi pakati pa malo otsatirawa:
- tambani mzere;
- malemba;
- tsiku;
- wamba
Pambuyo pochita kuponderezedwa, pezani "Wachita".
- Mawindo amawoneka akufunsa komwe ndondomeko yobweretsedwa iyenera kuikidwa pa pepala. Mwa kusintha makina a redio, mukhoza kuchita izi pa pepala latsopano kapena lakhalapo. Pachifukwa chotsatirachi, mungathe kufotokozeranso zolondola za malo omwe ali nawo. Kuti musalowe nawo mwapadera, zatha kuyika mtolowu m'munda uno, ndiyeno musankhe pa pepala la selo lomwe lidzakhala gawo lakumwamba lomwe lilipo pamene deta idzawonjezeredwa. Pambuyo pokonza makonzedwe, pezani "Chabwino".
- Zomwe zili pa chinthucho zikuwonetsedwa pa pepala la Excel.
PHUNZIRO: Momwe mungayendetse CSV mu Excel
Njira 2: FreeOffice Calc
CSV ikhozanso kuyendetsa pulosesa ina, Calc, yomwe ili m'gulu la LibreOffice.
- Yambani LibreOffice. Dinani "Chithunzi Chotsegula" kapena ntchito Ctrl + O.
Mukhozanso kuyendayenda mumasewera ndikukakamiza "Foni" ndi "Tsegulani ...".
Kuwonjezera apo, mawindo otsegula angapezeke mwachindunji kudzera mu mawonekedwe a Calc. Kuti muchite izi, mu LibreOffice Calc, dinani pa chithunzi ngati foda kapena mtundu Ctrl + O.
Njira ina ndikutengera mfundozo "Foni" ndi "Tsegulani ...".
- Kugwiritsira ntchito njira iliyonse yosankhidwa kungachititse zenera "Tsegulani". Pitani ku malo a CSV, limbeni ndikulani "Tsegulani".
Koma mukhoza kuchita popanda kutsegula mawindo "Tsegulani". Kuti muchite izi, kukokera CSV kuchokera "Explorer" ku LibreOffice.
- Chida chikuwonekera "Mangani Malemba"kukhala analog Osegula Mauthenga mu Excel. Ubwino ndi chakuti pakadali pano sikoyenera kusuntha pakati pa mawindo osiyanasiyana, kuchita zofunikira zowonjezera, popeza zonse zofunika zofunika zili pawindo limodzi.
Pitani mwachindunji ku gulu lokonzekera "Lowani". Kumaloko "Kulemba" sankhani mtengo "Unicode (UTF-8)"ngati izo zikuwonetsera mosiyana. Kumaloko "Chilankhulo" sankhani chinenero chamanja. Kumaloko "Kuchokera pamzere" muyenera kufotokoza kuti ndiyiti yomwe ingayambe kulowetsa zomwe zili. Nthaŵi zambiri, simukusowa kusintha pa parameter iyi.
Kenako, pitani ku gululo "Zosankha Zopatulira". Choyamba, muyenera kuyika batani pa wailesi "Wopatula". Komanso, malinga ndi mfundo yomwe idagwiritsidwa ntchito pogwiritsa ntchito Excel, muyenera kufotokoza mwa kuyang'ana bwalo loyang'ana kutsogolo kwa chinthu china chomwe chingakhale cholekanitsa: semicolon kapena comma.
"Zosankha zina" siya osasintha.
Mukhoza kuona mosapita m'mbali momwe mauthenga amtunduwo akuyang'ana pamene akusintha zochitika zina pansi pawindo. Mukatha kulowa magawo onse ofunika, pezani "Chabwino".
- Chotsatira chidzawonetsedwa kudzera mu mawonekedwe a LibreOffice Calc.
Njira 3: Calc OpenOffice
Mukhoza kuyang'ana CSV pogwiritsa ntchito pulogalamu ina - OpenOffice Calc.
- Thamani OpenOffice. Muwindo lalikulu, dinani "Tsegulani ..." kapena ntchito Ctrl + O.
Mukhozanso kugwiritsa ntchito menyu. Kuti muchite izi, pitizani mfundozo "Foni" ndi "Tsegulani ...".
Monga momwe zilili ndi pulogalamu yapitayi, mungathe kufika pazenera chotsegula chokha mwachindunji cha Kalk. Pankhaniyi, muyenera kujambula pa chithunzichi mu fano la foda kapena ntchito zofanana Ctrl + O.
Mukhozanso kugwiritsa ntchito menyu poyendetsa zinthuzo. "Foni" ndi "Tsegulani ...".
- Muwindo lotseguka limene likuwonekera, pitani ku malo a chigawo cha CSV, sankhani chinthu ichi ndikutsegula "Tsegulani".
Mukhoza kuchita popanda kutsegula zenera podutsa CSV kuchokera "Explorer" mu OpenOffice.
- Zonse mwazinthu zomwe zafotokozedwa zidzatsegula zenera. "Mangani Malemba"zomwe ziri zofanana mofanana pa maonekedwe ndi ogwira ntchito ku chida chomwe chiri ndi dzina lomwelo ku LibreOffice. Choncho, zomwezo ndizo chimodzimodzi. M'minda "Kulemba" ndi "Chilankhulo" kuwulula "Unicode (UTF-8)" ndi chilankhulo cha pakali pano.
Mu chipika "Separator Parameters" ikani batani pa wailesi pafupi ndi chinthucho "Wopatula", kenako fufuzani bokosilo ("Semicolon" kapena "Comma"), zomwe zimagwirizana ndi mtundu wa zokondweretsa.
Pambuyo pochita zochitikazo, ngati deta yomwe ikuwonetsedwera kumapeto kwawindo iwonetsedwa molondola, dinani "Chabwino".
- Detayi idzawonetsedwa bwino kudzera pa mawonekedwe a OpenOffice Calc.
Njira 4: Notepad
Kuti mukonzekere, mungagwiritse ntchito Zopewera zonse.
- Yambani Notepad. Dinani pa menyu "Foni" ndi "Tsegulani ...". Kapena mungagwiritse ntchito Ctrl + O.
- Windo lotseguka likuwonekera. Pita ku malo a CSV. Mu mawonekedwe awonetsera munda, ikani mtengo "Mafayi Onse". Lembani chinthu chofunika. Ndiye pezani "Tsegulani".
- Cholingacho chidzatsegulidwa, koma, ndithudi, osati mawonekedwe a maulamuliro, omwe tawawona muzithunzithunzi, koma mu mawonekedwe a mauthenga. Komabe, mu zolembera ndizosavuta kusintha zinthu za mtundu uwu. Muyenera kungoganizira kuti mzera uliwonse wa tebulo umagwirizana ndi mzere wa malemba mu Notepad, ndipo zigawozo zimasiyanitsidwa ndi makasitomala kapena opatukana osiyanitsa. Malinga ndi izi, mungathe kusintha mosavuta kusintha, kulemba malemba, ndikuwonjezera mizere, kuchotsa kapena kuwonjezera olekanitsa ngati kuli kofunikira.
Njira 5: Notepad ++
Mukhoza kutsegula ndi chithandizo cha mkonzi wamasamba oposa - Notepad ++.
- Sinthani Notepad ++. Dinani pa menyu "Foni". Kenako, sankhani "Tsegulani ...". Mungagwiritsenso ntchito Ctrl + O.
Njira ina ikuphatikizapo kusindikiza chizindikiro cha mawonekedwe mu fayilo.
- Windo lotseguka likuwonekera. Ndikofunika kusamukira kudera la fayilo kumene CSV yofunayo imapezeka. Mukasankha, pezani "Tsegulani".
- Zokhutira zikuwonetsedwa mu Notepad ++. Malamulo a kusintha ndi ofanana ndi Notepad, koma Notepad ++ amapereka chiwerengero chokwanira cha zipangizo zosiyanasiyana za deta.
Njira 6: Safari
Mukhoza kuwona zomwe zili mu malemba osasintha popanda kuthekera kuseri kwa Safari. Mawotchi ena ambiri otchuka sapereka gawo ili.
- Yambani Safari. Dinani "Foni". Kenako, dinani "Tsegulani fayilo ...".
- Windo lotseguka likuwonekera. Zimayenera kusamukira kumalo komwe CSV ili, yomwe wogwiritsa ntchito akufuna kuiwona. Ndilofunikira kuti musinthe mawonekedwe pawindo "Mafayi Onse". Kenaka sankhani chinthucho ndi CSV yowonjezera ndikukakamiza "Tsegulani".
- Zomwe zili mu chinthucho zidzatsegulidwa muwindo latsopano la Safari mu mawonekedwe a zolemba, monga zinaliri mu Notepad. Zoona, mosiyana ndi Notepad, kusintha deta ku Safari, mwatsoka, sikugwira ntchito, chifukwa mungathe kuiwona.
Njira 7: Microsoft Outlook
Zinthu zina za CSV ndi maimelo otumizidwa kuchokera kwa imelo wamakalata. Zikhoza kuwonedwa pogwiritsa ntchito Microsoft Outlook pogwiritsa ntchito njira yobweretsera.
- Yambani Kutuluka. Mutatsegula pulogalamuyi, pitani ku tabu "Foni". Kenaka dinani "Tsegulani" kumbali yam'mbali. Kenako, dinani "Lowani".
- Iyamba "Import and Export Wizard". Mu mndandanda womwe wawonetsedwawo musankhe "Lowani pulogalamu ina kapena fayilo". Dikirani pansi "Kenako".
- Muzenera yotsatira, sankhani mtundu wa chinthu choti mulowetse. Ngati titenga CSV, ndiye kuti tifunika kusankha malo "Makhalidwe Osiyana Osiyana (Mawindo)". Dinani "Kenako".
- Muzenera yotsatira, dinani "Bwerezani ...".
- Awindo likuwoneka "Ndemanga". Iyenera kupita kumalo kumene kalata ili mu fomu ya CSV. Lembani chinthu ichi ndipo pezani "Chabwino".
- Kubwerera kuwindo "Kutumiza ndi Kutumiza Zida". Monga mukuonera m'deralo "Fayizani kuitanitsa" Adilesi yonjezedwa ku malo a CSV chinthu. Mu chipika "Zosankha" Machitidwe angasiyidwe ngati osasintha. Dinani "Kenako".
- Ndiye muyenera kulemba foda mu bokosi la makalata komwe mukufuna kulemba makalata olembedwera.
- Window yotsatira ikuwonetsera dzina la zomwe zidzachitike ndi pulogalamuyi. Zokwanira kuti dinani "Wachita".
- Pambuyo pake, kuti muwone deta yobweretsedwa, yendani ku tab "Kutumiza ndi kulandira". Kumbali ya pulogalamuyi, sankhani foda yomwe kalatayo inatumizidwa. Kenaka pakati pa pulogalamuyi padzakhala mndandanda wa makalata omwe ali mu foda iyi. Ndikokwanira kuwirikiza kawiri pa kalata yofunidwa ndi batani lamanzere.
- Kalata yoitanitsidwa kuchokera ku chinthu cha CSV idzatsegulidwa pulogalamu ya Outluk.
Tiyenera kuzindikira kuti njira iyi sitingayendetse zinthu zonse mu chikhalidwe cha CSV, koma makalata omwe mapangidwe ake amakumana ndi mndandanda wina, zomwe zili ndi minda: phunziro, malemba, adiresi, adilesi yolandira, ndi zina zotero.
Monga momwe mukuonera, pali mapulogalamu angapo opangira zinthu za CSV. Monga lamulo, ndibwino kuti muwone zomwe zili mu mafayilowa muzitsulo. Kusintha kungakhoze kuchitidwa ngati malemba olemba olemba. Kuwonjezera apo, pali CSV yosiyana ndi mawonekedwe ena, omwe amagwira ntchito ndi mapulogalamu apadera, monga makasitomala amelo.
