This week's giveaway is in the EJB and other Java EE Technologies forum. We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan on-line! See this thread for details.
You say that it doesn't create an excel file...I was under the impression that the spreadsheetML would be able to be opened as an excel spreadsheet?
A csv would be great except for the fact that I need multiple sheets...I dont need formulas or anything else like that,
I just need my data on multiple sheets.. would spreadsheetML output not do this properly?
Yes I ran the xml and xsl through the org.apache.xalan.xslt.Process class and was rewarded with some spreadsheetML...
But if I try open it with Open Office as a spreadsheet it opens Open Office Writer with the text content instead although
I did save the output of the transformation as .xls ...
Maybe I should spend a couple weeks figuring out this xsl stuff before I waste more time on this.
Joined: Mar 22, 2005
I don't think there ever was an application besides MS Office that could make sense of the Office 2003 XML formats. This has nothing to do with XSLT.