Can excel read xml?
Answer / Jagrit Kashyap
Yes, Excel can read XML files by importing them. To do this, you can go to 'File' -> 'Open' -> select the XML file -> choose 'Microsoft Excel Macro-Enabled Workbook (XML)' from the file type dropdown list -> and click on 'Open'. Once imported, you will have an Excel worksheet with the data from your XML file.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is url what is the use of it?
What is xslt used for?
Whether root element is required for XML? If so, how many root elements are required?
Define element and attribute in an xml document.
If I replace my Sqlserver with XML files and how about handling the same ?
How do I use graphics in xml?
Is xml relational?
What is the usage of xslt <xsl: if> element?
How do I import an xml file into excel?
In both cases Schema is same xml files are different when u opt xmlTextReader and when you opt Xml Document?
What is an rss feed link?
Write a program to use the stylesheet element?