Nigute wahindura koden muri Excel: inzira 3 zoroshye

Hamwe no guhindura inyandiko Vict, abakoresha bakora mushakisha, abanditsi banditse nibitunganya akenshi biragereranywa. Ariko, mugihe ukorera mumeza meza, ibyo dukeneye birashobora no kubaho, kuko iyi gahunda itunganya imibare gusa, ahubwo ninyandiko. Reka tumenye uburyo bwo guhindura pronding muri Excele.

Isomo: Kodegisi mu Ijambo rya Microsoft

Kora hamwe na pome

Inyandiko ya Veling - Uru rutonde rwimvugo ya elegitoroniki yahinduwe izoshimishwa nabakoresha. Hariho ubwoko bwinshi bwa kodegisi, buri kimwe kifite amategeko nururimi. Ubuhanga bwa porogaramu kugirango umenye ururimi runaka kandi rukabihindure kubimenyetso byumuntu bisanzwe (inyuguti, imibare, izindi nyuguti) zigena niba porogaramu izashobora gukorana ninyandiko runaka cyangwa ntabwo. Mu nyandiko izwi cyane Encodings igomba gutegurwa ku buryo bukurikira:

• Windows-1251;
• Koi-8;
• ASCII;
• ANSI;
• Uks-2;
• UTF-8 (Unicode).

IZINA RYA NYUMA RYA MBERE RYA BISANZWE MU MURONDE MU ISI, nkuko bigaragara ko ari ubwoko bwibipimo rusange.

Kenshi na kenshi, porogaramu ubwayo yemera kode kandi ihita ihinduka, ariko mubihe bimwe umukoresha akeneye kwerekana isura yayo. Icyo gihe ni bwo burashobora gukora neza hamwe nibimenyetso byanditse.

Excel ifite umubare munini wa progaramu ya Excel hamwe na gahunda ya Excel mugihe ugerageje gufungura dosiye ya CSV cyangwa kohereza ubutumwa bwa TXT. Akenshi, aho kuba inyuguti zisanzwe iyo ufunguye aya madosiye unyuze muri Excel, dushobora kureba inyuguti zidasobanutse, ibyo bita "Crakozybry". Muri ibi bihe, umukoresha akeneye gukora manipulations kugirango gahunda yo gutangira kwerekana amakuru neza. Hariho inzira nyinshi zo gukemura iki kibazo.

Uburyo 1: Hindura koden ukoresheje Notepad ++

Kubwamahirwe, igikoresho cyuzuye cyakwemerera guhindura vuba kode muburyo ubwo aribwo bwose. Kubwibyo, birakenewe gukoresha ibisubizo byinshi kuri izo ntego cyangwa kwitabaza ubufasha bwandi. Imwe munzira zizewe ni ugukoresha umwanditsi wa TARESAPAD ++.

1. Koresha porogaramu ya TARESAPAD ++. Kanda kuri dosiye "dosiye". Kuva kurutonde rutangira, hitamo ikintu "gifunguye". Nkubundi buryo, urashobora guhamagara Ctrl + o clavier kuri clavier.



2. Idosiye ifunguye idirishya ritangira. Jya mububiko aho inyandiko iherereye, yerekanwe nabi. Turabigaragaza hanyuma ukande kuri buto "fungura" hepfo yidirishya.



3. Idosiye ifungura mu idirishya rya CARDPAD ++. Munsi yidirishya kuruhande rwiburyo bwimiterere yerekana inyandiko ya kodegisi. Kuva exdel yerekana nabi, birasabwa guhindura. Twinjije Ctrl + urufunguzo rwo guhuza clavier kugirango rugaragaze inyandiko yose. Kanda kuri "ContedIng". Kurutonde rufungura, hitamo "guhindura ikintu UTF-8". Ubu ni umwuga wa Unicode hamwe na Excel akora neza bishoboka.



4. Nyuma yibyo, kugirango uzigame impinduka muri dosiye ishimangira buto kumurongo wibikoresho muburyo bwa disiki ya disiki. Funga TEARPAD ++ ukanze kuri buto nkumusaraba wera muri kare yumutuku mugice cyo hejuru cyiburyo bwidirishya.



5. Fungura dosiye ukoresheje inzira isanzwe ukoresheje umuyobozi cyangwa gukoresha ubundi buryo ubwo aribwo bwose muri gahunda ya Excel. Nkuko mubibona, inyuguti zose zerekanwa neza.

Nubwo ubu buryo bushingiye ku gukoresha software ya gatatu, ni imwe mu mahitamo yoroshye yo guhindura ibikubiye muri dosiye?

Uburyo 2: Gusaba Wizard Wizard

Mubyongeyeho, urashobora gukora guhinduka no gukoresha ibikoresho byubatswe mubikoresho byubatswe, aribyo abapfumu banditse. Mubisanzwe bihagije, gukoresha iki gikoresho biragoye kuruta gukoresha porogaramu ya gatatu yasobanuwe muburyo bwabanje.

1. Koresha gahunda ya Excel. Ni ngombwa gukora porogaramu ubwayo, kandi ntukingure inyandiko nayo. Ni ukuvuga, ugomba kugaragara urupapuro rwuzuye. Jya kuri tab "data". Kanda kuri buto kuri "uhereye kuri kaseti", shyirwa muri "kubona amakuru yo hanze".



2. Idirishya rya dosiye zitumizwa mu mahanga rifungura. Ishyigikira gufungura imiterere ikurikira:
   • Txt;
   • CSV;
   • Prn.

   Jya mububiko bwa dosiye yatumijwe mu mahanga, hitamo hanyuma ukande kuri buto "Kuzana".



3. Idirishya rya Wizard rifungura. Nkuko tubibona, murwego rwo kureba, inyuguti zerekanwe nabi. Mumwanya wa "Filime", turagaragaza urutonde rwamanutse kandi tugahindura kode ya "Unicode (UTF-8)" muri yo.

   

   Niba amakuru arerekanwa uko byagenda kose, ntabwo aribyo, hanyuma ugerageze kugerageza ukoresheje izindi encodings kugeza ibyanditswe mumurima wibanze birasorwaho. Nyuma yibisubizo biragushimishije, kanda kuri buto "ikurikira".



4. Idirishya rikurikira rya Wizard rifungura. Hano urashobora guhindura ikimenyetso cyo gutandukanya, ariko birasabwa kuva muri igenamiterere risanzwe (ikimenyetso cya tab). Kanda kuri buto "ikurikira".



5. Idirishya ryanyuma rifite ubushobozi bwo guhindura imiterere yamakuru:
   • Rusange;
   • Inyandiko;
   • Itariki;
   • Simbuka inkingi.

   Hano igenamiterere rigomba gushyirwaho, duhabwa imiterere yibirimo. Nyuma yibyo, tukanda buto "Kurangiza".



6. Mu idirishya rikurikira, sobanura isano yibumoso bwibumoso bwurwego kurupapuro aho amakuru yinjijwe. Ibi birashobora gukorwa mugutwara ijambo intoki mumwanya ukwiye cyangwa garagaza gusa selile wifuza kurupapuro. Nyuma yo guhuza bivange, mumurima widirishya, kanda buto "OK".



7. Nyuma yibyo, inyandiko izagaragara kurupapuro muri kodegisi dukeneye. Biracyahari cyangwa kugarura imiterere yimbonerahamwe, niba ari amakuru ya tangabuto, nkuko yangiritse mugihe rematting.

Uburyo 3: Kuzigama dosiye muri kodegisi runaka

Hariho kandi ibihe bitandukanye mugihe dosiye itagomba gufungurwa hamwe namakuru meza yerekana, hanyuma uzigame muri hended. Muri Excel, urashobora gukora iki gikorwa.

1. Jya kuri tab "dosiye". Kanda kuri "Kubika nka".



2. Idirishya ryo kuzigama inyandiko rifungura. Ukoresheje umurongo wa dimector, dusobanura ububiko buzabikwa. Noneho shiraho ubwoko bwa dosiye niba dushaka kubika igitabo muburyo butandukanye nuburyo busanzwe bwamashusho (Xlsx). Noneho ndakanda kuri "Serivisi" no kurutonde rufungura, hitamo "Ibipimo bya interineti".



3. Mu idirishya rifungura, jya kuri tab "kodegisi". Muri "Uzigame inyandiko nka" umurima, fungura urutonde rwamanutse hanyuma ugashyiraho ubwoko bwa kodegisi kurutonde, tuzi ko ari ngombwa. Nyuma yibyo, kanda kuri buto "OK".
4. Gusubira kuri "Inyandiko Kubika" na hano tukanda kuri buto "Kubika".

Inyandiko izakizwa kuri disiki ikomeye cyangwa itangazamakuru rivanwa muri kodegisi wabonye. Ariko ugomba gutekereza ko ubu burigihe inyandiko zibikwa muri excel zizakizwa muri iyo ngingo. Kugirango uhindure ibi, ugomba kujya kuri "Urubuga rwinyandiko" hanyuma uhindure igenamiterere.

Hariho ubundi buryo bwo guhindura imiterere ya kode yanditswe.

1. Kuba muri tab "dosiye", kanda kuri "ibipimo".



2. Idirishya rya Pardonter Excel rifungura. Hitamo subparagraph "Byongeye kandi" uhereye kurutonde ziherereye kuruhande rwibumoso bwidirishya. Igice cyo hagati yidirishya kirimo kuzunguruka kuri Igenamiterere rya "Rusange". Hano kanda kuri "Urubuga Urupapuro Igenamiterere".



3. Idirishya ryibipimo "Urubuga" rifungura, aho turimo gukora ibikorwa bimwe na kimwe bavuga mbere.

Noneho inyandiko iyo ari yo yose yakijijwe muri Excel izagira neza pronding washyizeho.

Nkuko mubibona, Excel ntabwo ifite igikoresho cyakwemerera guhindagurika byihuse kandi byoroshye guhindura inyandiko uhereye kumurongo wa kodegisi. Umwigisha winyandiko afite imikoranire cyane kandi ifite ibintu byinshi bidakenewe muburyo bumeze. Ukoresheje, ugomba gutsinda intambwe nkeya, ibyo mu buryo butaziguye kuri iyi nzira ntabwo bigira ingaruka, kandi bigatanga izindi ntego. Ndetse no guhinduka binyuze mumyandiko-nyababyeyi yandika TESTOP ++ Muri uru rubanza birasa bimwe. Kuzigama dosiye muri kode zitangwa muri excel nanone biragoye kandi ko igihe cyose wifuza guhindura iyi migani, ugomba guhindura igenamiterere ryisi yose ya gahunda.