Maitiro ekuvhura CSV muExcel

CSV zvinyorwa zvinyorwa zvinoshandiswa nezvakawanda zvirongwa zvemakomputa zvekuchinjana data pakati peumwe neumwe. Zvingaite senge zvakakunda iwe unogona kutanga iyo faira neyakajairwa kaviri tinya neiyo iyo kuruboshwe bhatani bhatani, asi kwete nguva dzose mune ino kesi, iyo data inoratidzwa nenzira kwayo. Chokwadi, pane imwe nzira yekuona ruzivo rwuri muCSV faira. Ngatitsvagei kuti zvinogona kuitwa sei.

Kuvhura magwaro eCSV

Iro zita reCSV fomati ndeye chidimbu chezita "Comma-akapatsanurwa tsika", iyo inoshandurwa muchiRussia, se "kukosha" kwakakamurwa nemakomichi ". Chokwadi, mumafaira aya, vatevedzeri vevatauri, kunyangwe mune shanduro dzinotaura chiRussia, kusiyana nezwi rekutaura, mushure mezvose, itsika yekushandisa pfungwa.

Kana kuendesa kuCSV mafaera kuExcel, dambudziko rekutamba iyo Encoding inoenderana. Kazhinji, zvinyorwa mune iyo cyrillic iripo inotangwa nerugwaro rakawanda "Krakoyabram", kureva, mavara asina kuverengeka. Uye zvakare, dambudziko rinowanzoitika ndiyo nyaya yekusanzwisisika kwevaparadzaniswa. Chekutanga pane zvese izvi, izvi zvine chekuita nemamiriro ezvinhu aya kwatiri kuti tivhurire gwaro rakaitwa mune imwe mhando yechirongwa chekutaura Chirungu, Exel, Localised pasi pemushandisi wemutauro weRussia. Mushure mezvose, mukodhi yekodhi, iyo inoparadzanisa ndeye comma, uye Excer inotaura chiRussia inoona iyo pfungwa ne comma mumhando iyi. Naizvozvo, mhedzisiro isiriyo inowanikwa. Isu tichaudza maitiro ekugadzirisa matambudziko aya kana ari kuvhura mafaera.

Nzira 1: Zvakajairika faira kuvhura

Asi pakutanga tichafunga nezve sarudzo iyo CSV gwaro richigadzirwa muchirongwa cheRussia chinotaura uye chatove chakagadzirira kuvhura muExpress pasina kuwedzera manipulations pamusoro pezvinyorwa.

Kana iyo excel chirongwa ichi yatovhura zvinyorwa zveCSV pane yako komputa neyako confect, saka mune ino nyaya yakakwana kudzvanya pane mbiri yekudzvanya bhatani re mbeva, uye ichavhura muExcel. Kana kubatana kwacho kuchisati zvamiswa, ipapo mune ino nyaya iwe unofanirwa kuita nhamba yekuwedzera yekuwedzera manipulations.

1. Kuve muWindows Explorer mune dhairekitori uko iyo faira iri, tinya bhatani re mbeva yemberi pairi. Mamenyu emamenyu anotangwa. Sarudza chinhu "chakavhurika nerubatsiro" mariri. Kana rondedzero ye "Microsoft Office" inowanikwa mune yakakwira rondedzero, wobva wadzvanya pachiri. Mushure meizvozvo, gwaro richangotanga muhurukuro yako yekare. Asi kana iwe usingaone chinhu ichi, tinya pane "Sarudza chirongwa" chinzvimbo.



2. Iyo yeProgram yekusarudza Window inovhura. Pano, zvakare, kana iwe ukaona zita rekuti "Microsoft Office" mu "Zvirongwa Zvakakurudzirwa" Block, wozozvisarudzira uye tinya pane "OK" bhatani. Asi zvisati zvaitika, kana iwe ukashuvira kuti mafaera eCSV anogara achizaruka mukubika kana achiita kuti "svina chirongwa chakasarudzwa kune ese mafaera" akamira chiratidzo cheki.

   

   Kana iwe usina kuwana zita rekuti "Microsoft Office" muProgram yekusarudza hwindo, wobva wadzvanya pane "Overview ..." bhatani.



3. Mushure meizvozvo, iyo inoongorora hwindo rinotanga mune yekuvharira dhairekitori yakaiswa pakombuta yako. Semutemo, iyi folda inonzi "mafaira ezvirongwa" uye iri pamudzi waC. Iwe unofanirwa kuita shanduko kune muongorori pane kero inotevera:

   C: \ purogiramu mafaira \ Microsoft Office \ Office№

   Iko, panzvimbo ye "Kwete". "Symbol, iyo vhezheni yeMicrosoft Office Package yakaiswa pakombuta yako inofanira kunge iri pakombuta yako. Semutemo, folda yakadai ndeimwe, saka sarudza dhairekodhi yehofisi, chero nhamba yacho imomo haina kumira. Nekufamba mune yakatarwa dhairekitori, tarisa faira inonzi "Excel" kana "Exel.exe". Iyo yechipiri fomu yezita ichave iri muchiitiko chaunogonesa kuwedzera muWindows Explorer. Simbisa iyi faira uye tinya pane iyo "yakavhurika ..." bhatani.



4. Mushure meizvozvo, iyo Microsoft Excel chirongwa ichi ichawedzerwa kune iyo Sarudzo yekusarudza yepawindo, yatataura kare. Iwe uchangoda kuratidza zita raunoda, tevera kuvapo kweiyo tick padhuze nechinhu chinosungirwa kumhando dzefaira (kana iwe uchida kugara wakavhurika maCSV magwaro muExcel) uye tinya pane "OK" bhatani.

Mushure meizvozvo, zvirimo zvegwaro reCSV zvichavhurika mukubuditsa. Asi nzira iyi yakakodzera chete kana pasina matambudziko nekuwirwa kana nemepu yeCyrillic. Mukuwedzera, sezvatinoona, iwe unofanirwa kuita zvimwe zvekugadzirisa zvegwaro: Sezvo ruzivo rwusiri mune zvese zviitiko musero razvino musero, vanofanirwa kuwedzerwa.

Nzira 2: Uchishandisa zvinyorwa zvemavara

Iwe unogona kupinza data kubva kuCSV fomati gwaro uchishandisa yakamiswa yakanakira chishandiso, icho chinonzi rugwaro wizard.

1. Mhanya iyo Excel chirongwa uye enda kune iyo data tab. Pamutepi mu "kuwana kwekunze data" Toolbar, tinya pane bhatani, iyo inonzi "kubva pane zvinyorwa".



2. Chinyorwa cheGwaro Chinopinza hwindo rakatangwa. Famba mune dhairekitori yenzvimbo yeCVS tarisiro faira. Simbisa zita raro uye tinya pane "Import" bhatani, iri pazasi pewindo.



3. Iyo yerugwaro wizard hwindo rinoitwa. Mu "data fomati" zvigadziriso block, switch inofanira kumira mu "nevaparadzikisi" chinzvimbo. Kuve nechokwadi chekuratidzira zvirizvo zvirimo zvegwaro rakasarudzwa, kunyanya kana riine cyrillic, cherechedza kuti "Unicode (UTF-8)" kukosha kwakaiswa ku "faira fomati". Pane imwe nyaya, iwe unofanirwa kuiisa maan. Mushure mekunge zvese zviri pamusoro zvigadziriso zvakaiswa, tinya pane "inotevera" bhatani.



4. Ipapo yechipiri zvinyorwa zveWizard windows inovhura. Hezvino zvakakosha kuti uone kuti ndechipi chiratidzo chiri chikamu mugwaro rako. Kwedu isu, mune ino chiitiko pane iyo komma, sezvo gwaro iri kutaura kweRussia uye inozivikanwa kune shanduro dzesoftware. Naizvozvo, mumarongedzo block "chiratidzo-chinoparadzaniswa" tinoisa tick kusvika ku "point nekomiti" chinzvimbo. Asi kana iwe ukaisa iyo CVS faira iyo yakagadzirirwa zviyero zvinotaura Chirungu, uye mutauri weComma mukati mayo komma, ipapo iwe unofanirwa kuisa tick kune iyo "comma" chinzvimbo "chinzvimbo" chinzvimbo "chinzvimbo" chinzvimbo. Mushure mekunge marongero ari pamusoro akagadzirwa, tinya pane "inotevera" bhatani.



5. Hwindo rechitatu rerugwaro rweWizard vanovhura. Semutemo, hapana zvimwe zviito hazvidi kuburitsa. Iyo chete inosarudzika, kana imwe yedata seti yakaendeswa mugwaro ine zuva rezuva. Mune ino kesi, zvakakosha kuti utarise iyi chikamu pazasi pewindo, uye switch mu "Column Data Fomati" block yakaiswa kune "zuva" chinzvimbo. Asi mune yakawanda yakawanda yakawanda yematare, iyo nzvimbo yekusarudzika iyo iyo "General" fomati yakaiswa. Saka iwe unogona kungozvidzvinyirira iyo "kupedzisa" bhatani pazasi pewindo.



6. Mushure meizvozvo, diki dhata yekupinda newindo rinovhura. Inofanira kuratidza kuronga kweiyo nzvimbo yekuruboshwe yenzvimbo mune iyo data yakaunzwa ichave iri. Izvi zvinogona kuitwa nekungoisa iyo yekukanda mumunda wepahwindo, wobva wadzvanya bhatani rekuruboshwe mbeva pamwe chete nesero rinoenderana. Mushure meizvozvo, marongi ayo anozoiswa mumunda. Iwe unogona kugadzira iyo "OK" bhatani.



7. Mushure meizvi, zviri mukati meiyo CSV faira ichaiswa pane iyo Excel pepa. Uyezve, sezvatinogona kuona, zvinoratidzwa zvakanyanya nenzira kwayo kupfuura kana uchishandisa nzira 1. Kunyanya, kuwedzera kwehukuru hwehukuru hwemasero haadikanwe.

Chidzidzo: Maitiro ekuchinja iyo ENTODEDE MUKUSVIRA

Nzira 3: Kuvhura kuburikidza neiyo faira tab

Kune zvakare nzira yekuvhura gwaro reCSV kuburikidza neyefa yefaira yeiyo Excel chirongwa.

1. Mhanya Excel uye uende kune iyo faira tab. Dzvanya pane "yakavhurika" chinhu chiri kuruboshwe rwehwindo.



2. Iyo yeConlation Window inotangwa. Inofanira kufamba mune iyi dhairekitori pane hard disk yePC kana pane inobvisa media iyo iyo CSV yemhando yeCSV inofarira. Mushure meizvozvo, iwe unofanirwa kurongedza marudzi efaira switch mune iyo "ese mafaera" hwindo. Chete mune ino kesi, gwaro reCSV richaratidzwa muhwindo, sezvo risiri rakajairika faira. Mushure mekunge iro zita riratidziro riratidzwe, sarudza uye tinya pane "Vhura" bhatani pazasi pewindo.



3. Mushure meizvozvo, iyo zvinyorwa zveWizard window inotanga. Zvese zvinoitika zviito zvinoitwa neiyo algorithm yakafanana nenzira yechipiri.

Sezvauri kuona, kunyangwe paine matambudziko nekuvhurwa kwemagwaro eCSV fomu muExle, zvichiri kuitika kuti vagadzirise. Kuti uite izvi, iwe unofanirwa kushandisa iyo yakamiswa yakanakisa chishandiso, iyo inonzi tenzi mavara. Kunyangwe, kwezviitiko zvakawanda, zvakaringana kushandisa nzira yakajairika yekuvhura faira nekudzvanya bhatani rekuruboshwe bhatani nezita rayo.