General discussion

Locked

Use XSLT to get Excel files

By purvis_sam ·
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.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

this might be a good starting point on MSDN

by spaz99 In reply to Use XSLT to get Excel fil ...

http://msdn.microsoft.com/library/en-us/dnexcl2k2/html/odc_xmlss.asp
hope this helps

Collapse -

Apache helps

by norgan.han In reply to Use XSLT to get Excel fil ...

Hi there,
check out POI from Apache, that might help,

greetings,
Me

Collapse -

KB have readymade answer for this

by harivalath In reply to Apache helps

Visit this page. It got a reaymade answer, you have adapt it(XSLT) little bit to fit into your scenario.

http://support.microsoft.com/default.aspx?scid=kb;en-us;319180

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums