Maitiro ekududzira Excel muXML: 2 Workflows

XML isese mamiriro ezvinhu data. Inotsigira mapurogiramu akawanda, kusanganisira kubva pamakwenzi. Naizvozvo, kutendeuka kweruzivo muXml kwakakosha kubva pane maonero ekutarisa uye kugoverana kwedata pakati pezvisungo zvakasiyana siyana. Excel ingori pakati pemapurogiramu anoshanda nematafura, uye anogona kuita manipurera nemadheti. Isu tichaona nzira yekushandura excel mafaera kuXML.

Shanduko Maitiro

Kutendeuka kwedatha kune XML fomati haisi iyo nzira yakapusa, sezvo iri munzira yayo iyo yakakosha chirongwa (schema.xml) inofanira kugadzirwa. Nekudaro, kushandura ruzivo kune iyo faira iri nyore yeiyi fomati, zvakaringana kuve nekugara uchichengetedzwa mukuwedzera mukuremekedza, uye pano kugadzira chinhu chakanyatsogadzirwa chinofanira kuve chakanyatsoiswa nemhombwe yedunhu uye yayo kubatana kwegwaro.

Nzira 1: yakaponesa yakaponesa

Mukurinda, iwe unogona kuchengetedza data mu xml fomati, uchingoshandisa iyo "chengetedza se ..." Menyu. Chokwadi, hapana chivimbo chekuti zvese zvirongwa zvese zvinoshanda nenzira kwayo nefaira rakagadzirwa nenzira iyi. Ehe, uye kwete mune zvese zviitiko nzira iyi inoshanda.

1. Mhanya iyo Excel chirongwa. Kuti uvhure chinhu kuti chishandurwe kuti uende kune iyo faira tab. Inotevera, tinya pane "yakavhurika" chinhu.



2. Iyo faira yakavhurika hwindo rakatangwa. Enda kune dhairekitori uko iyo faira ratinoda ririmo. Inofanira kunge iri mune imwe yeiyo mafomu eExcel - XLS kana XLLSX. Sarudza iyo uye tinya pane "yakavhurika" bhatani iri pazasi pewindo.



3. Sezvauri kuona, iyo faira yakavhurwa, uye data rayo rakaonekwa pane razvino pepa. Zvekare, enda ku "Faira" tab.



4. Mushure meizvozvo, enda nechinhu icho "chengetedza sa ...".



5. Iyo windows inovhura. Enda kune dhairekitori umo watinoda kuchengeta faira rakashandurwa. Nekudaro, iwe unogona kusiya dhairekitori default, kureva kuti, chirongwa ichi chakazvifunga. Nwindo rimwe chete, kana chishuwo chasvika, iwe unogona kushandura zita refaira. Asi iyo inotarisisa inofanira kudzoserwa pa "faira rerudzi" munda. Dzosera rondedzero yekudzvanya pane ino ndima.

   

   Pakati pezvisarudzo zvekuchengetedza ndezvekutsvaga zita rekuti "Tafura XML 2003" kana "XML data". Isu tinosarudza chimwe chezvinhu izvi.



6. Mushure meizvozvo, tinya pane "Sevha" bhatani.

Nekudaro, shanduko yefaira kubva ku Excel fomati muXML ichaitwa.

Nzira 2: Midziyo yekuvandudza

Iwe unogona kushandura Excel Fomati muXML uchishandisa iyo yekuvandudza maturusi pane chirongwa chebhu. Panguva imwecheteyo, kana mushandisi akaita zvese nenzira kwayo, ipapo pakubuda muchagamuchira, kusiyana nenzira yekare, iyo yakazara XML faira iyo ichazikanwa nenzira yechitatu-bato application. Asi pakarepo anoda kutaura kuti kwete yega yega nyowani ingangove neruzivo rwakakwana uye hunyanzvi zvinobva zvadzidza zvakanyanya kushandura data nenzira iyi.

1. Ne default, iyo yekuvandudza tabu tab yakaremara. Naizvozvo, chekutanga pane zvese, iwe unofanirwa kuisiya. Enda ku "Faira" tab uye tinya pane "parameter" clause.



2. Mune yakavhurwa parameter hwindo, isu tinoenda ku "tepi setup" subsection. Padivi chairo rewindo, tinoisa tick padhuze ne "yekuvandudza" kukosha. Mushure meizvozvo, isu tinodzvanya pane "OK" bhatani, iri pazasi pewindo. Iyo yekuvandudza yekushandisa tab ikozvino yave yakagoneswa.



3. Tevere, vhura tafura yekuwedzera muchirongwa mune chero nzira yakakodzera.



4. Pahwaro, isu tinofanirwa kugadzira chirongwa icho chakaumbwa mune chero mavara ezvinyorwa. Nezvizvinangwa izvi, unogona kushandisa iyo yakajairwa nhandare yekunyora windows, asi zviri nani kushandisa chinongedzo chekushandisa kuronga uye kushanda neNotepad ++ marimi emamitauro. Mhanyisa chirongwa ichi. Gadzira zano mariri. Paruenzaniso wedu ichatarisa, sezvakaratidzwa muzasi mune skrini yeiyo notepad ++ hwindo.

   

   Sezvatinoona, iyo yekuvhura uye kuvhara tag yegwaro racho seyese inoshanda "Data-Set" . Mubasa rimwechete kune imwe neimwe mutsara protrudes tag "Rekodha" . Nechirongwa, zvichave zvakakwana kana tikangotora mitsara miviri chete patafura, uye hatizoshandurire zvese zviri pamanyowa XML. Iro zita rekuvhura uye rekuvhara tag column rinogona kunge riri kupokana, asi mune ino nyaya, kuti kuve nyore, taifarira kungoshandura mazita ekutaura anotaura chiRungu kuita Chirungu. Mushure mekunge data riitwe, ingovaponesa kuburikidza neyekunyora zvinyorwa zvekushanda chero kupi kune iyo hard disk mu xml fomati inonzi "Schema".

5. Zvekare, enda kuChirongwa cheExcel neTafura Yakatovhura. Isu tinoenda kune "yekuvandudza" tab. Pamutepi mu "XML" Tool block nekudzvanya pa "Source" bhatani. Mumunda unovhura kuruboshwe rwehwindo ratinodzvanya pane "XML ..." Kadhi bhatani.



6. Muwindo rinovhura, tinya pane bhatani "wedzera ...".



7. Iyo sosi yekusarudza window inotangwa. Enda kune dhairekitori yenzvimbo yenzvimbo inokweverwa kare, sarudza iyo uye tinya pane iyo "yakashama" bhatani.



8. Mushure mekunge zvinhu zviripo muhwindo, dhonza uchishandisa iyo yekukara kune iyo inoenderana masero eiyo tafura yekoramu.



9. Rudyi-tinya patafura yakakonzerwa. Mune mamiriro emamenyu menyu, isu tinotevedzera kupfuura zvinhu "XML" uye "Export ...". Mushure meizvozvo, chengetedza iyo faira mune chero dhairekitori.

Sezvauri kuona, pane nzira mbiri huru dzekushandura XLS uye XLSX mafaera kuMicrosoft Excel XML Fomu. Yekutanga iri nyore kwazvo uye iri munzira yekutanga yekuchengetedza nekuwedzera kwekuwedzera kuburikidza ne "chengetedza se ..." basa. Iko kusareruka uye kunzwisisika kwesarudzo iyi pasina mubvunzo zvakanakira. Asi ane imwe yakanyanya kudhirowa. Shanduko yacho inoitwa pasina kuitisa zvimwe zviyero, uye saka iyo faira inoshandurwa nenzira iyi, yechitatu-bato application ingangove isinga zivikanwe. Iyo yechipiri sarudzo inosanganisira kuunganidzwa kweiyo XML mepu. Kusiyana nenzira yekutanga, tafura, yakashandurwa zvinoenderana neichi chirongwa, chinosangana neyese xml mhando zviyero. Asi, zvinosuruvarisa, kwete mushandisi wese anokwanisa kukurumidza kubata ne nuances yeizvi maitiro.