Sida loo furo sixiddiisa file XML ah ee Excel, dhowr siyaabo fudud

Inta badan, dadka isticmaala qaar ka mid ah u leeyihiin in ay la files XML u taagan xogta ku salaysan talooyinka tag description ama software goobaha ay ka qabtaan. iyaga fur sixiddiisa ee double-click caadiga ah uma shaqeeyo. Tan waxa u sabab xaqiiqada ah in ururka la kordhiyo uusan haysan codsiga loo isticmaalo by default. Laakiin haddii aad rabto in aad hesho file a aadanaha akhrin sida miis in la saxar kartaa, aad ka furan kartaa file XML ah ee Excel. Uma baahnid inaad wax converters in loogu badalo karaa qaabab isu. digtoonyey kaliya, habkaani waxaa laga heli karaa oo keliya in versions Office 2003 iyo versions sare.

Sida loo fur XML in Excel: Jidka ugu horeysay

Tixgeli dejinta ee version ku salaysan Excel xogta ee 2016. Habka ugu horeysay oo sahlan waa in marka hore bilaabin barnaamijka Excel ah. Bilawga Salaan iyo codsiga logo bandhigayaa daaqad logon gaar ah oo menu bidixda jiro xarig ah "fur buugaag kale."

Ka dib markii in, isticmaali burburin karo dib u eegis, laakiin daaqad cusub ee format XML waxaa doortay sida la furay. Ka dib markii in, habka caadiga ah aan helno file la doonayo iyo riix badhanka furan. Xaaladdan oo kale, ka XML-file Excel ma aqoonsan sida dokumenti qoraal kooban sharaxaad iyo tags, iyo sidoo kale miiska ugu caadiga ah. Dabcan, xogta la saxar kartaa adiga kuu gaar ah, laakiin badan oo ku saabsan in ka dib.

Sida loo furo format XML ee Excel, si ay u labaad

Xaqiiqo ahaan kama duwana mid Habka ugu horeysay soo jeediyay. file XML ee Excel, aad furi karaa menu File ama isticmaal isku jira degdeg ah Ctrl + O.

Mar kale, marka hore dooro nooca format in la furay, ka dibna file la doonayo oo riix badhanka u dhigma.

Furitaanka XML, si ay saddexaad

Waxaa jira dhowr hab oo loo furo file XML ah ee Excel. Sidaas darteed, in version ah ee barnaamijka ee 2016, waxaad isticmaali kartaa menu bar ugu sareeya, halkaas oo qaybta "Data" la doorto, ka dibna riix Hel Data Dibadda.

In menu hoos-hoos ah, si fudud u dooro qaybta "Laga soo bilaabo ilo kale" in menu cusub, isticmaali xarig ah "From Import XML ah". Tani waxaa la socda nidaamka caadiga ah ee raadinaya file la doonayo, ka dibna u furan.

Edit, badbaadin iyo dhoofinta

Marka la isticmaalayo mid ka mid ah hababkan, user helo qaab-dhismeedka miiska. Tafatirka waxaa loo sameeyaa si la mid ah sida loo sameeyaa la files XLS caadiga ah. Mararka qaarkood, sahlaansashada tafatirka iyo badbaadinta xogta waa in la isticmaalaa for the menu horumarinta.

Xaaladdan oo kale, waxaad u dajiyaan karaa oo keliya ka kooban oo dhan oo ka mid ah XML-file, laakiin kaliya waxa run ahaantii waa lagama maarmaan, galinta macluumaadka ku jira shaxda iyo saf ku habboon, isagoo farta ku fiiqaya in ay XML-shay sida il xogta a. Laakiin taas waxaa lagama maarmaan ah in barnaamijka si ay u gasho in aad xisaabta adiga oo isticmaaleya isticmaale diiwaangelinta ee Microsoft.

Save faylka saxar si toos ah waxay noqon kartaa qaab asalka by xulashada nooca ka mid ah liiska. Laga soo bilaabo menu File ah, haddii wax la badbaadiyey ee "hooyo format» Excel, waxaad dooran kartaa feature dhoofinta ah, click on nooca file iyo isbeddel ahi qotomiyey sidii format finalka waa XML.

Haddii user waa mid aad u caajis in ay galaan dib u habaynta sida, ama waxa uu u adeegsanayaa version soo socda ee version Office 2003, waayo furitaanka format this ee foomka of miis u baahan tahay in ay isticmaalaan Converter gaar ah. barnaamijyada noocan oo kale ah ay hadda ku bixiyeen badan ilaa xad ah. Xaaladdan oo ah xad-dhaaf ah, haddii aysan ku haboon, dhibaato ma kuu gudbin karaan adeegyada online gaar ah oo ku saabsan taas oo format waa layna beddeli doonaa in labo ka mid ah tobanaan seconds. Dhamaadka falalka noocaas ah kala soo bixi doonaa oo kaliya natiijada la dhammeeyayna ay qaab XLS si wadid aad u adag oo ka dibna u furo in Excel. Si kastaba ha ahaatee, kiisaska intooda badan, ficilkan oo kale ayaa loo baahan yahay, sida in xafiiska la mid ah 2003 furitaanka toos ah (soo dejinta) format XML hore u markii hore la siiyaa. Iyo waxa ay u muuqataa, dad tiro yar ayaa maanta u isticmaalaan ka weyn wax soo saarka Microsoft Office.