Uburyo bwo Guhindura XML kuri Excel

XML nimwe mubintu bisanzwe byo kubika amakuru no kubihana hagati ya porogaramu zitandukanye. Microsoft Excel nayo ikorana namakuru, bityo ikibazo cyo guhindura dosiye kuva kuri XML kurwego rwibisanzwe kuri excel itoroshye irakenewe cyane. Shakisha uburyo bwo gukora ubu buryo muburyo butandukanye.

Guhindura inzira

Dosiye ya XML zanditswe mu rurimi rwihariye rwimibare hamwe nikintu gisa na HTML kurubuga rwa HTML. Kubwibyo, izo formats zifite imiterere isa. Mugihe kimwe, Excel ni porogaramu ifite imiterere "kavukire". Uzwi cyane muri bo: Igitabo Cyiza (XLSX) na Excel 97 - 2003 igitabo (XLS). Turashaka uburyo nyamukuru bwo guhindura dosiye ya XML kuri iyi format.

Uburyo 1: Gushiraho Excel imikorere

Gahunda ya Excel ikora cyane hamwe na dosiye ya XML. Irashobora kubafungura, guhinduka, gukora, kuzigama. Kubwibyo, amahitamo yoroshye kubikorwa byo muri Amerika nugukingura iki kintu hanyuma uyikize binyuze mu porogaramu isaba nka XLSX cyangwa XLS.

1. Koresha Excel. Muri tab "dosiye", jya "fungura".



2. Idirishya rifungura rikora. Jya mububiko aho inyandiko ya XML ukeneye kubikwa, turabigaragaza kandi ukande buto "Gufungura".



3. Nyuma yinyandiko ifunguye binyuze mumirongo ya exel, jya kuri tab "dosiye".



4. Kujya kuri iyi tab, kanda kuri "Kubika nka ...".



5. Idirishya rifungura risa nidirishya ritangiza, ariko hamwe nitandukaniro. Ubu dukeneye gukiza dosiye. Ukoresheje ibikoresho byo kugenda, jya mububiko aho inyandiko yahinduwe ibikwabikwa. Nubwo ushobora kubireka mububiko bwubu. Mumwanya wa "dosiye" umurima, niba ubishaka, urashobora guhindura izina, ariko ibi nabyo ntibikenewe. Kubwibikorwa byacu, ibikurikira ni umurima ukurikira - "Ubwoko bwa dosiye". Kanda kuri uyu murima.

   

   Kuva kumahitamo yatanzwe, hitamo igitabo cya Excel cyangwa Igitabo cya Excel 97-2003. Iya mbere ni shyashya, iya kabiri irashaje.



6. Nyuma yo guhitamo byakozwe, kanda buto "Kubika".

Kuri ibi, uburyo bwa dosiye ya XML muburyo bwa excel binyuze mumigaragaro ya porogaramu irarangiye.

Uburyo 2: Amakuru atumizwa

Uburyo bwasobanuwe burakwiriye gusa kuri dosiye ya XML hamwe nuburyo bworoshye. Ameza akomeye mugihe guhinduka muri ubu buryo birashobora guhindurwa nabi. Ariko hariho ubundi buryo bwo kwishyiriraho Excel Excel buzafasha neza gutumiza amakuru. Iherereye muri menu yabatezimbere, zihagarikwa kubisanzwe. Kubwibyo, mbere ya byose, bigomba gukora.

1. Kujya kuri tab "dosiye", kanda kuri "ibipimo".



2. Muri Parameter, jya kuri "ribbon gushiraho". Kuruhande rwiburyo bwidirishya, dushyira amatiku yerekeye ikintu cyabateza imbere. Kanda kuri buto ya "OK". Noneho imikorere yifuzwa irakorwa, kandi tab ihuye yagaragaye kuri kaseti.



3. Jya kuri tab yiterambere. Kuri kaseti muri "XML" ibikoresho byo guhagarika umutima dukanda kuri buto "Kuzana".



4. Idirishya ryatumijwe ritumiyemo rifungura. Jya mububiko aho inyandiko ukeneye iherereye. Hitamo hanyuma ukande kuri buto "Kuzana".



5. Ibikurikira, ikiganiro agasanduku gashobora gufungurwa, kivuga ko dosiye yatoranijwe itavuga kuri gahunda. Bizasabwa gukora gahunda ya gahunda yigenga. Muri iki kibazo, twemeranya no gukanda buto "OK".



6. Ubukurikira bufungura agasanduku kabakurikira. Iratumiwe gufata icyemezo cyo gufungura ameza mu gitabo kiriho cyangwa muri gishya. Kubera ko twatangije gahunda tutafunguye dosiye, dushobora gusiga iyi miterere isanzwe kandi dukomeza gukorana nigitabo cyubu. Byongeye kandi, idirishya rimwe risaba kugirango hamenyekane ihuriro kurupapuro aho ameza atumizwa mu mahanga. Urashobora kwinjiza adresse intoki, ariko biroroshye cyane kandi byoroshye kanda gusa kuri selile kurupapuro ruzaba ikintu cyo hejuru cyimeza. Nyuma ya aderesi yinjiye mu kiganiro agasanduku, kanda kuri buto "OK".



7. Nyuma yibi bikorwa, imbonerahamwe ya XML izinjizwa mumadirishya ya porogaramu. Kugirango uzigame dosiye muburyo bwiza hamwe nigishushanyo cya flick muburyo bwa disiki ya floppy mugice cyo hejuru cyishyamba.



8. Idirishya rikize rifunguramo ukeneye kumenya ububiko aho inyandiko izabikwa. Imiterere ya dosiye iki gihe izashyirwaho mbere ya XLSX, ariko niba ubishaka, urashobora guhishura umurima wa "Ubwoko bwa dosiye" hanyuma ugashyiraho indi formatl - XLS. Nyuma yo kubika igenamiterere ryashyizweho, nubwo muriki kibazo birashobora gusigara muburyo busanzwe, kanda buto "Kubika".

Rero, guhinduka mu cyerekezo gikenewe kuri twe bizakorwa hamwe no guhindura amakuru ntarengwa.

Uburyo 3: Guhindura kumurongo

Abo bakoresha kubwimpamvu runaka batashyizwe kuri mudasobwa gahunda ya Excel, ariko bakeneye korora dosiye yihutirwa kugirango badashobora gukoresha imwe muri serivisi nyinshi kumurongo wo guhinduka. Imwe murubuga rworoshye rwubu bwoko ni giswa.

Kumurongo uhindura kumurongo

1. Jya kuriyi mikoro y'urubuga hamwe na mushakisha iyo ari yo yose. Urashobora guhitamo inzira 5 zo gukuramo dosiye ihinduka:
   • Hamwe na disiki ikomeye ya mudasobwa;
   • Kuva kuri Dropbox Ububiko bwa interineti;
   • Kuva mububiko bwa interineti bwa Google;
   • Ukurikije umurongo uva kuri enterineti.

   Kuva muri twe, inyandiko yoherejwe kuri PC, tukanda kuri buto "kuva mudasobwa".



2. Idirishya rifungura ririmo gukora. Jya mububiko aho bushyizwe. Kanda kuri dosiye hanyuma ukande kuri buto "fungura".

   

   Hariho ubundi buryo bwo kongera dosiye kuri serivisi. Kugira ngo ukore ibi, ukuze gusa izina ryayo hamwe na Windows Explorer.

3. Nkuko mubibona, dosiye yongewe kuri serivisi kandi iri muri leta "yateguwe". Noneho ugomba guhitamo imiterere ukeneye kugirango uhindure. Kanda ku idirishya kuruhande rwinyuguti "B". Urutonde rwamatsinda ya dosiye ifungura. Guhitamo "inyandiko". Ibikurikira bifungura urutonde rwimiterere. Hitamo "XLS" cyangwa "XlsX".



4. Nyuma yizina ryifuzwa ryongerwaho mu idirishya, kanda kuri buto nini itukura "guhindura". Nyuma yibyo, inyandiko izahindurwa kandi iraboneka gukuramo kuri aya matungo.

Ihitamo rishobora kuba nka politiki nziza yumutekano mugihe habaye abadakira uburyo busanzwe bwo kuvugurura muri iki cyerekezo.

Nkuko mubibona, ibikoresho byubatswe mubikoresho ubwabyo kugirango uhindure dosiye ya XML kuri imwe muri "kavukire" yiyi gahunda. Ingero zoroshye zirashobora guhinduka byoroshye muburyo busanzwe "ikize nka ..." imikorere. Ushaka inyandiko zifite imiterere igoye, hari uburyo butandukanye bwo guhindura binyuze mu gutumiza mu mahanga. Abo bakoresha kubwimpamvu iyo ari yo yose badashobora gukoresha ibyo bikoresho bafite ubushobozi bwo gukora bakoresheje serivisi zihariye kumurongo kugirango bahindure dosiye.