Most Valuable Professional


View Jan Karel Pieterse's profile on LinkedIn subscribe to rss feed
Subscribe in a reader

Subscribe to our mailing list

* indicates required

Audit !!!

Check out our RefTreeAnalyser
the ultimate Excel formula auditing tool.

Trainings

Excel VBA Masterclass (English)
Excel VBA for Financials (Dutch)

Third party tools

Speed up your file

FastExcel
The best tool to optimise your Excel model!

Repair your file

Stellar Phoenix Excel Repair
Best tool to repair corrupt Excel sheets and objects
Home > English site > Articles > XML and Excel > Characteristics of XML
Deze pagina in het Nederlands

XML and Excel

Characteristics of XML

XML has a number of important characteristics (reprinted from
Professional Excel Development with permission from Addison Wesley):


 


Comments

All comments about this page:


Comment by: rahmat (2/10/2011 10:23:55 AM)

i dont use xml. i have no idea about it.
what is its function and what purpose it need?
how xml is used?

 


Comment by: Jan Karel Pieterse (2/11/2011 4:00:31 AM)

Hi Rahmat,

You'll know when you need xml, it is when you get an xml file from some source and you're asked to work with the data in that file.
As long as you do not have any xml files to work with, you don't need this option of course.

 


Comment by: yasser latif from pakistan (3/25/2011 4:25:14 AM)

why we can't save the xmlDocument utf-8 whole contents as a singel string in xml field of Table in SQL Server.

 


Comment by: Jan Karel Pieterse (3/25/2011 5:14:59 AM)

Hi Yasser,

I'm sorry, SQL Server is not my core expertise, Excel is.
Try asking your question here:
http://www.sqlteam.com/forums/

 


Comment by: Sandeep (8/12/2012 11:27:26 AM)

XML is introduced for data storing and transferring is it true of false

 


Comment by: Jan Karel Pieterse (8/13/2012 11:34:42 AM)

Hi Sandeep,

Yes and no. XML was introduced to be able to create structured data files, with the capability to mark what the data is about. It eases exchanging data between systems, simply because you can open an XML file and by reading its content understand whet it contains.

Of course this only works if people use descriptive and clear tag names and adhere to the xml rules.

 


Have a question, comment or suggestion? Then please use this form.

If your question is not directly related to this web page, but rather a more general "How do I do this" Excel question, then I advise you to ask your question here: www.eileenslounge.com.

Please enter your name (required):

Your e-mail address (optional but if you want me to respond it helps!; will not be shown, nor be used to send you unsolicited information):

Your request or comment:

To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].