Exports XML to Excel from .net 2.0 web application

I have an xml and i would like to click a button and export the xml - > XSLT - > data to excel.  Please advice.  Thank you.
LVL 7
Padre_CorleoneAsked:
Who is Participating?
 
bullroutCommented:
HI There,

You could bind the xml file to a gridview control and then export the whole view colours and all to a csv or excel file without too much trouble.

Here are some links:

http://www.netomatix.com/GridExportToCSV.aspx

http://www.velocityreviews.com/forums/t366404-gridview-to-csv.html
0
 
Padre_CorleoneAuthor Commented:
thanks for the info, my questions is most related to export from xml instead of using a gridview or datacolumns, basically a push of button will grab xml and write to excel file.  Any suggestions?  thank you.
0
 
bullroutCommented:
HI There,

Post the code you are using and I will show you.

Sean
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
Padre_CorleoneAuthor Commented:
Basically i want to grab this in a click of a button and export to Excel.

<?xml version="1.0" encoding="utf-16"?><CellSetState xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><CellProperties>ColorFormatting</CellProperties><ID>ctl00|DefaultContent|OLAPGrid</ID><UniqueGuarantee>0</UniqueGuarantee><IsAllOK>true</IsAllOK><ExceptionMessage /><CubeName>APVXAnalysis</CubeName><SessionMeasure /><Axes><cstAxis><Name>Axis0</Name><Hierarchies /><NamedSet /><StartPosition>0</StartPosition><DrilledTuples /></cstAxis><cstAxis><Name>Axis1</Name><Hierarchies /><NamedSet /><StartPosition>0</StartPosition><DrilledTuples /></cstAxis></Axes><FilterAxis><Name>SlicerAxis</Name><Hierarchies /><NamedSet /><StartPosition>0</StartPosition><DrilledTuples /></FilterAxis><Measures><cstMeasure><UniqueName>[Measures].[Avg Days]</UniqueName><DisplayMode>Data</DisplayMode><IsKPIGraphic>false</IsKPIGraphic><OrderDirection>None</OrderDirection></cstMeasure></Measures><SessionObjects /><IncludeEmptyRows>false</IncludeEmptyRows><IncludeEmptyColumns>false</IncludeEmptyColumns></CellSetState>
0
 
bullroutCommented:
What server software are using using? window, linux etx?
0
 
Padre_CorleoneAuthor Commented:
windows
0
 
Padre_CorleoneAuthor Commented:
.net 2.0
0
 
Padre_CorleoneAuthor Commented:
This would be the best answer from all answers received.  I feel this was left pending and un resolved, but having said that, it is has partially helped.  thanks for your effort.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.