ASP.NET Discussion - Export XML to Excel

Print Page | Close Window

Export XML to Excel

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: ASP.NET Discussion
Forum Description: Discussion and chat on ASP.NET related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=18562
Printed Date: 28 March 2026 at 11:14pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Export XML to Excel

Posted By: Tegwin
Subject: Export XML to Excel
Date Posted: 02 March 2006 at 12:46pm

There is not really a forum for this, but thought I would ask the question anyway. I am writing some software that writes information into XML files. I would like to know how to programatically export these to Excel.

I am doing the project in VB.NET 2005. Any help would be much appreciated.

Thanks

Chris

-------------
If you dont want my peaches, dont shake my tree

Replies:

Posted By: michael
Date Posted: 02 March 2006 at 4:54pm

There are a few way to do this, you can choose xml as the datasource for a reportviewercontrol and set the default output type to excel, or even easier iterate through the xml and create a csv...
Lastly, what I have done one time is use this http://aspalliance.com/471 example which actually works quite nicely.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: Tegwin
Date Posted: 04 March 2006 at 11:19pm

Hey thanks buddy. I will give it a try..

-------------
If you dont want my peaches, dont shake my tree