Discussion Locked

Use XSLT to get Excel files in dotnet

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I need to transform xml data into an excel report. Currently i'm transforming into html format and then using the Excel object model in dotnet to provide Excel specific manipulations such as hiding and grouping of rows and columns,number formats,etc..
I know there's an Xml file format available from Office XP onwards but even that doesnt support features that i've mentioned above. Is there any other solution? It has to be a dotnet one.

1 reply

by grantwparks

Remember that XSLT doesn't have to transfrom its input into XML/HTML. Would it satisfy your needs to transform your XML into a CSV and load that into Excel?

This discussion is closed to new replies.