Unogona kushandura faira reExcel kuita XML data faira kana zvinopesana. Izvi zvinobvumira ruzivo kuti ruchinjaniswe pakati pezvikumbiro zvakasiyana. Kuti utange, vhura iyo tab Developer (Mugadziri).
Heino data ratinoda kushandura kuita XML faira:
Kutanga, ngatigadzire schema yakavakirwa pane yekutanga XML data. Iyo schema inotsanangura chimiro cheiyo XML faira.
- Excel haina kukodzera chinangwa ichi, saka vhura, semuenzaniso, Notepad uye unamate mitsara inotevera:
Smith 16753 UK Qtr 3 Johnson 14808 USA Qtr 4
Cherechedza: Iwo ma tag anopihwa zita remazita emakoramu, asi unogona kuvapa chero zita raunoda. Somuenzaniso, pane - .
- Sevha iyo faira se schema.xml.
- Vhura bhuku rekushanda reExcel.
- Click on mabviro (mabviro) tab Developer (Mugadziri). Iyo XML taskbar ichavhura.
- Kuti uwedzere mepu yeXML, tinya bhatani Mamepu eXML (XML mepu).A dialog box ichaonekwa Mamepu eXML (Mamepu eXML).
- dzvanya wedzera (Wedzerai).
- sarudza schema.xml uye tinya kaviri OK.
- Iye zvino ingo dhonza uye udonhe zvinhu zvina kubva pamuti mubhara rebasa XML pane pepa (mutsara 4).
- dzvanya ekisipoti (Export) muchikamu XML Tab Developer (Mugadziri).
- Sevha faira uye tinya pinda.
Mhinduro:
Izvi zvinoponesa nguva yakawanda!
Cherechedza: Kuti utore kunze faira reXML, vhura bhuku rekushanda risina chinhu. Pa tab Developer (Developer) tinya Tumira (Import) uye sarudza iyo XML faira.