Yadda za a canza XML a XLS

An rarraba takardun asusun ajiya a cikin tsarin Microsoft Office - XLS da XLSX. Koyaya, wasu tsarin takardu a cikin hanyar XML shafukan. Ba koyaushe ba ya dace ba, kuma allunan bible da yawa suna kusa kuma sun saba. Don kawar da damuwa, ana iya jujjuya rahoton ko wasiƙu daga XML zuwa XLS. Yadda za a karanta a ƙasa.

Maida xml a xls

Yana da mahimmanci a lura cewa canjin waɗannan takardu zuwa teburin Ereeline ba shine mafi sauƙin aiki ba: waɗannan nau'ikan sun sha bamban. Shafin XML ne bisa ga rubutun syntax rubutu, da tebur XLS shine tebur mai cikakken bayani. Koyaya, tare da taimakon masu canji na musamman ko fakitoci ofis, irin wannan canji zai yiwu.

Hanyar 1: Adadin XML Mai Sakatawa

Mai sauƙin sarrafa shirin mai canzawa. Ya shafi kuɗi, amma ana samun sigar gwaji. Akwai Rashanci.

Zazzage shirin XML na XML

1. Bude shirin, to, yi amfani da "fayil" - "Buɗe XML".

   

2. A cikin taga "Explorer" taga, samu zuwa gaza directory tare da fayil ɗin da za a canza, sanya shi kuma danna Buɗe.

   

3. Lokacin da aka sauke takaddun, sake amfani da "fayil", zabar wannan lokacin "tebur na fitarwa" tebur ".

   

4. Za a sami neman saiti na canzawa. A cikin "nau'in" Drop-saukar menu, zaɓi "XLS".

   

   Sannan koma zuwa saitunan ta hanyar wannan ke dubawa, ko barin komai kamar yadda yake, kuma danna "Makaɗaɗa".

   

5. A ƙarshen tsarin juyawa, za a gama fayil ɗin da aka gama ta atomatik a cikin shirin da ya dace (alal misali, Microsoft Microsoft Excel).

   

   Kula da kasancewar rubutun game da sigar demo.

Shirin ba mummunan abu bane, duk da haka, ƙuntatawa akan sigar demo da rikitarwa tare da siyan cikakken fasalin na iya sa yawancin binciken wani bayani.

Hanyar 2: Mai Saudi na XML

Wani more dan kadan m sigar shirin don sauya shafukan XML zuwa teburin XSL. Hakanan ana iya amfani da mafita, harshen Rashanci ba ya nan.

Sauke Shirin XML mai Sauya XML

1. Bude aikace-aikacen. A gefen dama na taga, nemo maɓallin "Sabon" kuma latsa shi.

   

2. Mai dubawa "Mai binciken" Mai binciken wanda kake son zabar fayil ɗin tushe. Bi babban fayil tare da takaddun ka, zaɓi shi kuma buɗe ta hanyar latsa maɓallin da ya dace.

   

3. Gudu kayan juyawa. Da farko dai, bincika ko an sanya akwatunan a gaban abin da ke cikin takaddar da kake son canza, sannan ka danna maɓallin Red "mai walƙiya" a kasan hagu.

   

4. Mataki na gaba shine bincika tsarin fayil ɗin fitarwa: ƙasa a cikin kayan fitarwa dole ne a nuna alamar sigogin Excel.

   

   Sannan ka tabbata ka danna maballin "Saiti" wanda ke kusa.

   

   A cikin karamin taga, saita akwati "Excel 2003 (xls)", danna "Ok".

   

5. Komawa ga dubawa na juyawa, danna maɓallin "Mai canza".

   

   Shirin zai sa ka zabi babban fayil da sunan daftarin takardu. Yi wannan kuma danna "Ajiye".

   

6. Shirye - fayil mai canzawa zai bayyana a babban fayil ɗin da aka zaɓa.

   

Wannan shirin ya riga ya fi cumbersome kuma kasa da abokantaka ga sabon shiga. Yana ba da daidai irin wannan aikin kamar yadda mai canzawa da aka ambata a cikin hanyar tare da daidai wannan iyakoki, kodayake mai juyawa xML yana da ƙarin dubawa na zamani.

Hanyar 3: Libreooffice

Shahararren free ofis ya hada da software na aiki tare da Takardun Tabaru, wanda zai taimaka mana mu magance matsalar yin juyai.

1. Bude Libreoffice Cric. Yi amfani da menu na "fayil", sai "buɗe ...".

   

2. A cikin taga "Explorer", ci gaba zuwa babban fayil tare da fayil ɗin XML. Zaɓi shi da guda ɗaya kuma danna "Buɗe".

   

3. Taga shigo da taga zai bayyana.

   

   Alas, wannan shine babban canji ta amfani da Libreoffice Kiss: Bayani daga XML Takardar yanar gizo ke shigo da shi a cikin rubutu tsari da kuma bukatar ƙarin aiki. A cikin taga da aka ƙayyade a cikin allon sikelin, sanya abubuwan da kuke buƙata, sannan danna Ok.

4. Za a bude fayil ɗin a cikin yankin da ke cikin taga shirin.

   

   Yi amfani da "fayil" ta hanyar zabar abu "Ajiye azaman ...".

   

5. A cikin takaddar Ajiye Interface a cikin jerin tsoffin fayilolin fayil, saita "Microsoft Excel 97-2003 (* .xls)".

   

   To, idan kuna so, sake suna fayil ɗin kuma danna "Ajiye".

   

6. Za a sami gargadin na hadarori na formats. Latsa "Yi amfani da Microsoft Excel 97-2003" Tsarin.

   

7. Babban fayil ɗin kusa da fayil na asali zai bayyana a tsarin XLS, a shirye zuwa ƙarin magifuka.

   

Baya ga canjin rubutu, akwai kuma babu mummunan rashin amfanin wannan hanyar - sai da manyan shafuka tare da zaɓuɓɓukan kirkirar halitta tare da amfani da tsarin Halitta.

Hanyar 4: Microsoft Excel

Shahararren shirye-shiryen don aiki tare da bayanan Taburer, Excel daga Microsoft Corporation (sigogin 2007 da Newer) kuma yana da aiki don magance matsalar juyawa XML a cikin XLL.

1. Bude Excel. Zaɓi "buɗe sauran littattafai".

   

   To, a cikin jerin - "Kwamfuta" da "bita".

   

2. A cikin "mai binciken" zai cimma nasarar takaddun daftarin aiki. Haskaka shi tare da danna kuma danna Buɗe.

   

3. A cikin karamin saitin nuni, tabbatar cewa XML Tebur yana aiki kuma danna Ok.

   

4. Lokacin da shafin yake buɗe a cikin Microsoft Windpace Worpace, yi amfani da shafin fayil.

   

   A ciki, zaɓi "Ajiye azaman ...", to, "Thean kwaikwayon" abu wanda kuka sami babban fayil ɗin da aka dace da su.

   

5. A cikin Ajiye ke dubawa a cikin jerin nau'in fayil, zaɓi littafin Excel 97-2003 (* .xls).

   

   Daga nan sai ka sake sunan fayil ɗin idan kana so, ka latsa "Ajiye".

   

6. Shirye - bude a cikin yankin aiki, takaddar za ta karɓi tsarin XLS, kuma a cikin zaɓin zaɓin da kansa zai bayyana shirye don ci gaba da aiki.

   

Rashin Excel ne guda daya kawai - wanda aka rarraba shi a matsayin wani ɓangare na kunshin ofishin Microsoft Office akan lamari.

Kara karantawa: Canza fayilolin XML zuwa Tsarin Tsara

Takaita, mun lura cewa cikakken juyi na XML shafukan zuwa teburin XLS ba zai yiwu ba saboda bambance-bambancen. Kowane ɗayan mafita zai kasance cikin wasu sasantawa. Ko da sabis na kan layi ba zai taimaka ba - duk da sauƙinsu, irin waɗannan hanyoyin sun fi muni da wani software daban.