Link to home
Start Free TrialLog in
Avatar of Padre_Corleone
Padre_CorleoneFlag for United States of America

asked on

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.
ASKER CERTIFIED SOLUTION
Avatar of bullrout
bullrout

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Padre_Corleone

ASKER

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.
Avatar of bullrout
bullrout

HI There,

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

Sean
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>
What server software are using using? window, linux etx?
windows
.net 2.0
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.