how to convert data from xml file to excel sheet

Question

1: Is there any way to covert the xml data into Excel workSheet?

2: Also from database (sql server 2005 ) to an Excel worksheet?

David Basarab · Accepted Answer · 2009-10-12 12:27:21Z

1

You can export data from a Sql Server database to excel. See this link and this one.

As for an xml file, you can easily just open the xml file in Excel. Depending on the format it should open up for you fine.

answered Oct 12, 2009 at 12:27

David Basarab

73.4k43 gold badges131 silver badges158 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Faiz · Accepted Answer · 2009-10-12 12:31:17Z

1

This is a straight forward one, well documented in Microsoft site http://office.microsoft.com/en-us/excel/HP010423511033.aspx

If you are talking about doing it programatically, I think the first answer is a good start.

answered Oct 12, 2009 at 12:31

Faiz

5,46311 gold badges48 silver badges60 bronze badges