vijay.vizzu
Member
Dear All,
Anyone can explain the use of XML option in excel. How we can utilize this, in excel
Anyone can explain the use of XML option in excel. How we can utilize this, in excel
About XML in excel
- Thread starter vijay.vizzu
- Start date
Vijay,
XML is extensible markup language. It looks very similar to HTML (if you "view source" on a webpage, you can see some html coding). Basically, XML is a user-defined structure for storing data in such a way that it can be searched and retrieved very easily.
In Excel 2007, Microsoft started using this "behind the scenes" method for storing Excel spreadsheets (and other Office documents). That's what the "x" on the end of "xlsx" or "docx" means. "Hey, I'm in XML format." This allows 2010 to open 2007 documents (and vice-versa) without special adapters or code.
So, you really can't do XML work with Excel. I suggest you use DreamWeaver (Adobe) or similar editors (even wordpad would work) if you need to develop some of your own xml data.
This is from my knowledge of XML (yes, I've used it), and Excel's Help files, and my own fast research. I stand to be corrected by one of the gurus here.
Don
XML is extensible markup language. It looks very similar to HTML (if you "view source" on a webpage, you can see some html coding). Basically, XML is a user-defined structure for storing data in such a way that it can be searched and retrieved very easily.
In Excel 2007, Microsoft started using this "behind the scenes" method for storing Excel spreadsheets (and other Office documents). That's what the "x" on the end of "xlsx" or "docx" means. "Hey, I'm in XML format." This allows 2010 to open 2007 documents (and vice-versa) without special adapters or code.
So, you really can't do XML work with Excel. I suggest you use DreamWeaver (Adobe) or similar editors (even wordpad would work) if you need to develop some of your own xml data.
This is from my knowledge of XML (yes, I've used it), and Excel's Help files, and my own fast research. I stand to be corrected by one of the gurus here.
Don
NARAYANK991
Excel Ninja
Hi Vijay ,
To add to what Don has already posted , check out the following links :
1. http://www.mrexcel.com/articles/using-xml-in-excel.php
2. http://blogs.msdn.com/b/brian_jones/archive/2005/06/27/433152.aspx
3. http://office.microsoft.com/en-us/excel-help/how-to-use-xml-in-excel-2003-HA001101964.aspx
Narayan
To add to what Don has already posted , check out the following links :
1. http://www.mrexcel.com/articles/using-xml-in-excel.php
2. http://blogs.msdn.com/b/brian_jones/archive/2005/06/27/433152.aspx
3. http://office.microsoft.com/en-us/excel-help/how-to-use-xml-in-excel-2003-HA001101964.aspx
Narayan
Narayan,
Thanks for those links. After reading the first, and skimming the second and third, I reiterate my suggestion: Use a native XML editor if you plan to do any XML. DreamWeaver makes it much easier than the conglomeration I just saw. This is only marginally easier than wordpad, from what I can see.
Don
Thanks for those links. After reading the first, and skimming the second and third, I reiterate my suggestion: Use a native XML editor if you plan to do any XML. DreamWeaver makes it much easier than the conglomeration I just saw. This is only marginally easier than wordpad, from what I can see.
Don
vijay.vizzu
Member
Thanks to both of you to share your opinions.