GENERATE EXCEL PIVOT TABLE FROM XML & XSLT files?

GENERATE EXCEL PIVOT TABLE FROM XML & XSLT files?

My current .NET project is an Internet Reporting system.
It works by using XML and XSLT files to generate HTML pages with Excel spreadsheets on then.
This works fine when the format of the Excel spreadsheet is a simple straight forward layout.
What I would like to do is generate an Excel pivot table, or something similar, using XSLT.
Is this possible or am I asking for the impossible?

Regards

Paul G
pgilfeatherAsked:
Who is Participating?
 
puranik_pConnect With a Mentor Commented:
Manually create an excel sheet with pivoted table in Excel xp(2002) or above.
Do a 'save as .. xml'
You will get the xml code for the same.
Now doctor it to two files..one xml and another...xsl.
0
 
b1xml2Commented:
0
 
gregoryyoungConnect With a Mentor Commented:
I do not believe you can ... BUT .. you can use excelwriter on the webserver to generate an actual spreadsheet containing this information have this page set its return content type to excel and all should be good.

Greg
0
 
puranik_pCommented:
Finally, what did you do?
and, thanks for the 'A'.
:o)

Pura
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.