[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 600
  • Last Modified:

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.
0
Padre_Corleone
Asked:
Padre_Corleone
  • 5
  • 3
1 Solution
 
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
Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 
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

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now