Ana rarraba takardun shaida ta asusun Microsoft Office - XLS da XLSX. Duk da haka, wasu sassan suna fitar da takardu a cikin hanyar shafukan XML. Wannan ba kyauta ba ne, kuma yawancin Tables na Excel sun fi kusa kuma sun saba. Don kawar da rashin jin daɗi, rahotanni ko kuma takardunku za a iya tuba daga XML zuwa XLS. Ta yaya - karanta a kasa.
Tsara XML zuwa XLS
Ya kamata mu lura cewa musayar irin waɗannan takardu a cikin tebur na Excel ba aikin mai sauƙi ba: waɗannan nau'ukan suna da bambanci. Shafin XML yana da rubutun da aka tsara bisa ga daidaitattun harshe, kuma ma'anar XLS kusan kusan dukkanin bayanan da aka yi. Duk da haka, tare da taimakon masu musanya na musamman ko ofisoshin ofis, wannan tuba zai yiwu.
Hanyar 1: Mahimman XML Mai Girma
Mai sauƙin sarrafa tsarin saiti. An rarraba don kudin, amma akwai gwajin fitarwa. Akwai harshen Rasha.
Sauke Nau'in XML Mai Girma
- Bude shirin, sannan amfani "Fayil"-"Duba XML".
- A cikin taga "Duba" je zuwa shugabanci tare da fayil ɗin da kake so ka maida, zaɓi shi kuma danna "Bude".
- Lokacin da aka ɗora littafi, a sake amfani da menu. "Fayil", zabar wannan lokaci abu "Tebur fitarwa ...".
- Saitunan sabuntawa na bayyana zasu bayyana. A cikin jerin zaɓuɓɓuka "Rubuta" zaɓi abu "xls".
Bayan haka, koma zuwa saitunan da aka samo ta wannan ƙirar, ko barin duk abin da yake da shi kuma danna "Sanya".
- A ƙarshen tsari na yin hira, za'a bude fayil din da aka bude ta atomatik a cikin shirin dace (misali, Microsoft Excel).
Kula da gaban rubutun a kan tsarin demo.
Shirin bai zama mummunan ba, amma ƙuntatawar tsarin demokraɗiyya da wahalar sayan cikakken sauti na iya haifar da mutane da yawa don neman ƙarin bayani.
Hanyar 2: Mai sauƙin XML Converter
Wani ɗan littafin cigaba da yafi cigaba da shirin don sauya shafukan XML zuwa cikin layin XLS. Har ila yau, an biya kuɗi, harshen Rasha ya ɓace.
Sauke software Easy XML
- Bude aikace-aikacen. A hannun dama na taga, sami maɓallin "Sabon" kuma danna shi.
- Za'a buɗe bakuncin. "Duba"inda kake buƙatar zaɓar fayil din. Je zuwa babban fayil tare da takardunku, zaɓi shi kuma buɗe shi ta danna kan maɓallin da ya dace.
- Za'a fara fasalin kayan aiki. Da farko, duba ko ana duba akwati da abinda ke ciki na takardun da kake so ka maidawa, sannan ka danna maɓallin jan murya "Sake sake" kasa hagu.
- Mataki na gaba shine duba tsarin fayil ɗin fitarwa: a ƙasa a sakin layi "Bayanan fitar da bayanai", dole ne a bincika "Excel".
Sa'an nan kuma tabbatar da danna kan maballin. "Saitunan"located kusa da nan.
A cikin akwati na kananan taga "Excel 2003 (* xls)"sannan danna "Ok".
- Komawa zuwa fassarar hira, danna maballin. "Sanya".
Wannan shirin ya sa ka zaɓi babban fayil da sunan takardun tuba. Yi wannan kuma danna. "Ajiye".
- Anyi - fayil ɗin da aka canza zai bayyana a cikin fayil ɗin da aka zaba.
Wannan shirin ya riga ya fi ƙarfin hali kuma bai dace da sada zumunci ba. Yana bayar da daidai wannan aiki kamar yadda mai haɗawa da aka ambata a Hanyar 1 tare da daidai wannan ƙuntatawa, ko da yake Easy XML Converter yana da ƙwarewar zamani.
Hanyar 3: LibreOffice
A rare free ofishin suite LibreOffice ya hada da lissafin rubutu software, LibreOffice Calc, wanda zai taimake mu warware aikin yin hira.
- Open LibreOffice Calc. Yi amfani da menu "Fayil"to, "Bude ...".
- A cikin taga "Duba" je babban fayil tare da fayil dinku na xml. Zaɓi shi tare da danna guda kuma danna. "Bude".
- Wata matsala shigar da rubutu zai bayyana.
Alal misali, wannan shine babban kuskure a cikin fassarar ta amfani da FreeOffice Calc: bayanan da aka samo daga rubutun XML ana shigo da shi kawai a cikin rubutun rubutu kuma yana buƙatar ƙarin aiki. A cikin taga da aka nuna a cikin screenshot, yin canje-canje da ake buƙata, sannan ka danna "Ok". - Za a bude fayil ɗin a cikin aiki na sashin shirin.
Amfani "Fayil", rigaya zaɓi wani abu "Ajiye Kamar yadda ...".
- A cikin rubutun adreshin tsare-tsaren a cikin jerin saukewa "Nau'in fayil" saita "Microsoft Excel 97-2003 (* .xls) ".
Sa'an nan kuma sake suna cikin fayil kamar yadda ake bukata kuma danna "Ajiye".
- Wata gargadi game da tsari mara dacewa zai bayyana. Latsa ƙasa "Yi amfani da Microsoft Excel 97-2003 Tsarin".
- Wata fasali a cikin tsarin XLS zai bayyana a cikin babban fayil kusa da asalin asalin, a shirye don ƙarin manipulation.
Bugu da ƙari da nauyin rubutun na canji, wannan hanyar ba shi da wani kuskure - watakila tare da manyan shafukan da za a iya amfani da su na sabawa ta hanyar daidaitawa na iya zama matsalolin.
Hanyar 4: Microsoft Excel
Mafi sanannun shirye-shiryen don aiki tare da bayanan tabula, Excel daga Microsoft (sigogi 2007 da sababbin), ma yana da aikin don magance matsala na canza XML zuwa XLS.
- Bude Excel. Zaɓi "Buɗe wasu littattafai".
Sa'an nan, sequentially - "Kwamfuta" da "Duba".
- A cikin "Explorer" zuwa wurin wurin daftarin aiki don canzawa. Nuna shi kuma danna "Bude".
- A cikin karamin allon nuni, tabbatar cewa abu yana aiki. Shafin XML kuma danna "Ok".
- Lokacin da aka bude shafin a cikin aikin Microsoft Excel, amfani da shafin "Fayil".
A ciki, zaɓi "Ajiye Kamar yadda ..."to, abu "Review"wanda ke samo babban fayil wanda ya dace don ceton.
- A cikin jeri na lissafi "Nau'in fayil" zaɓi "Excel 97-2003 littafi (* .xls)".
Sa'an nan kuma sake suna cikin fayil idan kuna so, kuma danna "Ajiye". - Anyi - daftarin aiki da aka buɗe a cikin ɗakin yanar gizo zai karbi tsarin XLS, kuma fayil ɗin kanta zai bayyana a cikin jerin da aka zaba, wanda aka shirya domin kara aiki.
Excel yana da dalili daya kawai - an rarraba shi a matsayin ɓangare na akwatin Microsoft Office don kudin.
Kara karantawa: Sauya fayilolin XML zuwa Formats na Excel
Ƙarawa, mun lura cewa canjin canji na shafukan XML a cikin Tables na XLS ba zai yiwu bane saboda ƙananan bambance-bambance tsakanin tsarin. Kowane irin waɗannan maganganu zai kasance a wata hanyar sulhuntawa. Ko da shafukan yanar gizo ba zai taimaka ba - duk da sauƙin sa, irin wannan mafita ne mafi mahimmanci fiye da software na mutum.
