Indlela ukuvula ukuba ukuhlela ifayile yeXML ku Excel: ezimbalwa iindlela ezilula

Ngokufuthi, abanye abasebenzisi kufuneka bejongene iifayile XML ukuba bamele data ngokwesiseko njengegalelo inkcazo tag okanye software useto. Vula ngenxa ukuhlela kwi konqakrazo kabini-yesiqhelo ayisebenzi. Oku kungenxa yokuba ukuba unxulumano kunye ulwandiso akanayo isicelo eso uzakusetyenziswa kokungagqibekanga. Kodwa xa ufuna ukuba ufumane ifayile ngabantu-efundeka njenge yitafile ezinokulungiswa, unako ukuvula ifayile yeXML in Excel. Wena Awudingi converters ukuba ukuguqula izakhiwo phakathi kwabo. Kuphela caveat: lo msebenzi ifumaneka kuphela in version Office 2003 kunye neenguqulelo ngaphezulu.

Indlela Vula XML ku Excel: indlela yokuqala

Cinga intsingiselo uguqulelo Excel-based lwe data ngo-2016. Indlela yokuqala kwaye elula ukuba uqale ekuqaleni kwiprogram ye-Excel. Ekuqaleni mbuliso mni kunye nesicelo logo ibonisa i window kwikhompyutha ekhethekileyo apho menu ekhohlo kukho umtya "Vula ezinye iincwadi."

Emva koko, sebenzisa igatya ngokutsha, kodwa i window entsha kwi XML fomati uyonyulwa ngokuba ukuvulwa. Emva koko, le ndlela njengesiqhelo sifumana ifayile olufunwayo uze ucofe evulekileyo iqhosha. Kulo mzekelo, i-XML-ifayile Excel uyakuqonda hayi uxwebhu lokubhaliweyo equlathe inkcazelo kunye tags, kwakunye kwetafile kakhulu zesiqhelo. Kakade ke, iinkcukacha ezinokulungiswa ngokwakho, kodwa ngaloo kamva.

Indlela ukuvula kwifomati XML e Excel: indlela yesibini

Ngokoqobo ayahlukanga ukusuka yokuqala indlela enye ezicetywayo. ifayile XML e Excel, u nga vula kwi Fayile menu okanye sebenzisa indibaniselwano ekhawulezayo Ctrl + O.

Kwakhona, qala ukhethe uhlobo ifomati kuvulwa, ngoko ifayile olifunayo uze ucofe iqhosha elihambelanayo.

Ivula XML: indlela yesithathu

Kukho iindlela ezininzi ukuvula ifayile yeXML in Excel. Ngenxa yoko, inguqulelo ye-nkqubo ngo-2016, ungasebenzisa i menu bar phezulu, apho icandelo "Data" i ikhethiwe, uze ucofe Fumana Data lwangaphandle.

Kwi-drop-down menu, khetha nje kwicandelo "Ukusuka kweminye imithombo" kwi menu entsha, sebenzisa umtya "Ukususela XML Import". Oku kulandelwa inkqubo eqhelekileyo ukucinga ukuba ifayile oyithandayo bese evulekileyo.

Hlela, ukugcina kunye nokuthunyelwa

Xa usebenzisa nayiphi na kwezi ndlela, umsebenzisi ufumana isakhiwo itafile. Ukuhlela kwenziwa ngendlela efanayo njengoko kwenziwa kunye iifayile XLS eqhelekileyo. Ngamanye amaxesha, kuba lula ukuhlela zokonga idata kufuneka isetyenziselwe ababhekisi phambili menu.

Kulo mzekelo, uyakwazi ukungenisa kuphela imixholo iyonke XML-ifayile, kodwa kuphela oko kuyimfuneko ngenene, ufaka ulwazi kwiikholam ezifanelekileyo nezintlu, njengelona XML-object njengomthombo data. Kodwa oku kuyimfuneko kwinkqubo ukuze ungene kwi-akhawunti yakho usebenzisa ubhaliso lwakho kwi Microsoft.

Gcina ifayile ehleliweyo kunokuba ngqo kwi fomathi lokuqala ngokukhetha uhlobo kuluhlu. Kwi Fayile menu, ukuba into ebigcinwe kwi "lomthonyama format» Excel, ungakhetha i inkalo kumazwe, nqakraza kwi uhlobo lwefayile kwaye sebenzisa imali ebekwe njengoko ifomati yokugqibela yi XML.

Ukuba umsebenzisi yi eyonqenayo kakhulu ukuzibandakanya iinguqulelo ezinjalo, okanye usebenzisa uguqulelo zilandelayo version Office 2003, ngenxa yokuvulwa kwale ifomathi ngohlobo itheyibhile kufuneka usebenzise converter okhethekileyo. iinkqubo ezifana ngoku wanikela kakhulu lukhulu. Kwityala kakhulu, ukuba ngaba kufanelekile, akukho ngxaki sikuncede beenkonzo ezizodwa online apho format aya kutshintshwa apha isibini kwamashumi imizuzwana. Ekupheleni izenzo ezinjalo ziya download kuphela isiphumo ogqityiweyo kwifomati XLS kwi hard drive yakho ngoku yivule ngo-Excel. Nangona kunjalo, kwiimeko ezininzi, kufuneka amanyathelo, njengoko kwi-Ofisi efanayo 2003 lokuvula ngqo (yokungenisa) format XML sele kubonelelwe ekuqaleni. Kwaye kubonakala, bambalwa abantu namhlanje basebenzisa iimveliso ezindala Microsoft Office.