Nigute ushobora gufungura CSV muri excel

Inyandiko za CSV zikoreshwa na porogaramu nyinshi za mudasobwa yo guhana amakuru hagati yabo. Byasa nkaho byarenze ushobora gutangira dosiye nkiyi hamwe nibisanzwe kanda kuri buto yimbeba, ariko ntabwo buri gihe muriki kibazo, amakuru yerekanwe neza. Nibyo, hariho ubundi buryo bwo kureba amakuru akubiye muri dosiye ya CSV. Reka tumenye uburyo byakorwa.

Gufungura inyandiko za CSV

Izina rya format ya CSV ni uguhisha izina "Koma-Gutandukana indangagaciro", bihindurwa mu kirusiya, nkindangagaciro zagabanijwe na koma ". Mubyukuri, muri aya madosiye, imirimo ni abavuga, nubwo muri verisiyo ivuga Ikirusiya, bitandukanye no kuvuga icyongereza, nyuma ya byose, biramenyerewe ko bikoresha koma.

Iyo utumiza dosiye ya CSV kugirango witaruye, ikibazo cyo gukina kodegisi ni ngombwa. Akenshi, inyandiko aho byanze billic zihari zitangizwa hamwe numwandiko wubwinshi "Krakorababram nyinshi", ni ukuvuga imico idasoruye. Byongeye kandi, ikibazo kenshi nikibazo kidahuye nabatandukanya. Mbere ya byose, ibi bireba ibyo bihe tugerageza gufungura inyandiko yatanzwe muburyo bumwe na bumwe na bumwe bwo kuvuga icyongereza, gushika, byahobwe munsi yumukoresha windiburusiya. N'ubundi kandi, mu Kode y'inkomoko, itandukanya ni koma, kandi ikirusiya kivuga Ikirusiya kibona ko ari koma ari muri iyi mico. Kubwibyo, ibisubizo bitari byo biraboneka. Tuzavuga uburyo twakemura ibyo bibazo mugihe ufungura dosiye.

Uburyo 1: Gufungura dosiye bisanzwe

Ariko tubanze tuzibanda kumahitamo mugihe inyandiko ya CSV yashizweho muri gahunda yo kuvuga Ikirusiya kandi imaze kwitegura gufungura muri Excel nta kindi gitabo kirimo ibirimo.

Niba gahunda ya Excel yamaze gushyirwaho kugirango ifungure inyandiko za CSV kuri mudasobwa yawe muburyo busanzwe, hanyuma muriki gihe birahagije gukanda kuri kanda ibiri ya buto yimbeba yibumoso, kandi izakingura muri Excel. Niba ihuza ritarashyirwaho, noneho muriki kibazo ukeneye gukora umubare munini wibindi bikoresho.

1. Kuba muri Windows Explorer mububiko aho dosiye iherereye, kanda buto yimbeba iburyo. Ibikubiyemo byatangijwe. Hitamo ikintu "gifunguye hamwe nubufasha" muri yo. Niba urutonde rwa "Microsoft Office" ruboneka murutonde rwateye imbere, hanyuma ukande kuri yo. Nyuma yibyo, inyandiko izatangira gusa murugero rwawe rwa Excel. Ariko niba utarangije iki kintu, kanda kuri "Hitamo gahunda".



2. Idirishya ryo guhitamo gahunda rifungura. Hano, na none, niba uzabona izina "Microsoft Office" muri "Gahunda zisabwe", hanyuma uhitemo hanyuma ukande kuri buto "OK". Ariko mbere yibyo, niba ubyifuza ko dosiye za CSV zihita zifungura mugihe ukora imbeba ebyiri kumazina ya porogaramu, hanyuma urebe neza ko "gukoresha gahunda yatoranijwe kumadosiye yose yubwoko" yahagaze kuri cheque.

   

   Niba utabonye izina "Microsoft Office" mumadirishya yo gutoranya gahunda, hanyuma ukande kuri "Incamake ..." buto.



3. Nyuma yibyo, idirishya rishakashatsi rizatangira mububiko bwashyizwe kuri mudasobwa yawe. Nkibisobanuro, ubu bubiko bwitwa "dosiye ya gahunda" kandi iherereye kumuzi wa C. Ugomba kwimura umushakashatsi kuri aderesi ikurikira:

   C: \ Porogaramu Idosiye \ Microsoft Office \ biro№

   Aho, aho kuba "Oya", verisiyo ya pake ya Microsoft yashyizwe kuri mudasobwa yawe igomba kuba kuri mudasobwa yawe. Nk'ubuyobozi, ubwo bubiko ni bumwe, hitamo rero ububiko bwibiro, umubare udahagaze. Mu kwimukira mububiko bwerekanwe, shakisha dosiye yitwa "Excel" cyangwa "Excel.exe". Uburyo bwa kabiri bwizina buzaba mubyabaye ko washoboje kwagura muri Windows Explorer. Shyira ahagaragara iyi dosiye hanyuma ukande kuri buto "Gufungura ...".



4. Nyuma yibyo, gahunda ya Microsoft Excel izongerwa mumadirishya yo guhitamo gahunda, ibyo twavuze mbere. Uzakenera gusa kwerekana izina ryifuzwa, ukurikize imbere yintoki hafi yikintu cyihariye kubwoko bwa dosiye (niba wifuza guhora ufungura inyandiko ya CSV) hanyuma ukande buto ya "OK".

Nyuma yibyo, ibikubiye mu nyandiko ya CSV bizakingurwa. Ariko ubu buryo burakwiriye gusa niba ntakibazo cyo kwimenyekanisha cyangwa gushushanya ikarita ya silillic. Byongeye kandi, nkuko tubibona, ugomba gukora inyandiko yinyandiko: Kubera ko amakuru atari mubihe byose mubunini bwakagari, bigomba kwagurwa.

Uburyo 2: Gukoresha Wizard Wizard

Urashobora gutumiza amakuru mu nyandiko ya CSV ukoresheje igikoresho cyashyizwemo Exced, cyitwa Wizard.

1. Koresha gahunda ya Excel hanyuma ujye kuri tab. Kuri kaseti muri "Kubona amakuru yo hanze" ibikoresho, kanda kuri buto, witwa "uva mu nyandiko".



2. Inyandiko yinyandiko itumiza idirishya iratangizwa. Himura mububiko bwa dosiye ya CVS. Shyira ahagaragara izina ryayo hanyuma ukande buto "Kuzana", uherereye munsi yidirishya.



3. Idirishya rya Wizard rikora. Muri "amakuru ya Data", impinduka igomba guhagarara muri "hamwe nabatandukanya". Kugirango umenye neza ibiri mu nyandiko zatoranijwe, cyane cyane iyo irimo Cyrillic, menya ko "uhanide (Agaciro (UWF-8)". Mu rubanza rutandukanye, ugomba kwinjizamo intoki. Nyuma yibintu byose byavuzwe haruguru byashyizweho, kanda kuri buto "ikurikira".



4. Noneho idirishya rya kabiri rya Wizard rifungura. Hano ni ngombwa cyane kumenya ikimenyetso kitandukanya mu nyandiko yawe. Ku bitureba, muri uru ruhare rwacu hari ingingo hamwe na koma, kuko inyandiko ivuga Ikirusiya kandi ireba kuri verisiyo yo mu rugo ya software. Kubwibyo, mumiterere ya Igenamiterere "Ikimenyetso-Gutandukanya ni" Dushiraho amatiku kuri "ingingo hamwe na koma". Ariko niba utumije dosiye ya CVS yeguriwe ibipimo bivuga Icyongereza, kandi umuvugizi wa koma muriyo ni koma, ugomba gusangira umwanya wa "Koma". Nyuma yigenamiterere ryavuzwe haruguru ryakozwe, kanda buto "Ibikurikira".



5. Idirishya rya gatatu rya Wizard wizard rifungura. Nkingingo, nta bikorwa byiyongera bidakeneye kubyara. Ibidasanzwe gusa, niba rimwe mubice byatanzwe byatanzwe mu nyandiko bifite itariki. Muri iki gihe, birakenewe gushyira kuri iyi nkingi munsi yidirishya, kandi uhinduka muburyo bwa "guhagarika amakuru" bitondekanya kuri "itariki". Ariko murwego rwinshi rwimanza, igenamiterere risanzwe ryashyizweho imiterere "rusange". Urashobora rero kanda buto ya "Kurangiza" hepfo yidirishya.



6. Nyuma yibyo, idirishya rito ritumizwa mu mahanga rifungura. Igomba kwerekana ihuriro ryibumoso hejuru ya selile yamakuru yatumijwe mu mahanga amakuru azaba azaba. Ibi birashobora gukorwa mugushiraho indanga mumwanya widirishya, hanyuma ukande buto yimbeba yibumoso kumurongo uhuye kurupapuro. Nyuma yibyo, impaka zayo zizashyirwa kurutonde mumurima. Urashobora gukora buto "OK".



7. Nyuma yibi, ibikubiye muri dosiye ya CSV bizinjizwa kurupapuro rwa Excel. Byongeye kandi, nkuko tubibona, birerekanwa neza kuruta mugihe ukoresheje uburyo 1. byumwihariko, kwiyongera kw'inyongera kwagura ubunini ntibusabwa.

Isomo: Nigute wahindura koden muri excel

Uburyo 3: Gufungura ukoresheje dosiye

Hariho uburyo bwo gufungura inyandiko ya CSV binyuze muri dosiye ya porogaramu ya Excel.

1. Koresha excel hanyuma wimuke kuri dosiye. Kanda ahanditse "Gufungura" biri kuruhande rwibumoso bwidirishya.



2. Idirishya rya interineti riratangira. Igomba kwimuka muri ubu bubiko kuri disiki ikomeye ya PC cyangwa ku bitangazamakuru bivanwaho aho inyandiko ya CSV ishishikajwe. Nyuma yibyo, ugomba gutondekanya ubwoko bwa dosiye ihinduka muri idirishya rya "dosiye zose". Gusa muri uru rubanza, inyandiko ya CSV izerekanwa mu idirishya, kuko atari dosiye isanzwe ya Excel. Nyuma yizina ryinyandiko ryerekanwa, hitamo hanyuma ukande kuri buto "fungura" hepfo yidirishya.



3. Nyuma yibyo, idirishya rya Wizard rizatangira. Ibindi bikorwa byose bikorwa na algorithm imwe nko muburyo bwa 2.

Nkuko mubibona, nubwo hari ibibazo bimwe na bimwe mugufungura inyandiko zuburyo bwa CSV muri Excele, birashoboka kubikemura. Kugirango ukore ibi, ugomba gukoresha igikoresho cyashyizwemo Exped, cyitwa inyandiko nkuru. Nubwo, mubihe byinshi, birahagije kugirango ushyire muburyo busanzwe bwo gufungura dosiye ukanze kabiri ukanda buto yimbeba yibumoso mwizina ryayo.