Re: Generating reports in excel?
Re: Generating reports in excel?
- Subject: Re: Generating reports in excel?
- From: Jake Macmullin <email@hidden>
- Date: Thu, 16 Mar 2006 09:06:07 +1100
Now that Excel has an XML file format - I've found this to be
straight-forward.
1). Create an excel spreadsheet that looks the way you want, with
place-holders for the values you want to dynamically generate and
save it as XML.
2). Create a new WOComponent and replace the contents of the .html
file with the XML from your excel template
3). Insert the appropriate WebObject tags where you want to generate
content
I can't remember if you need to specify a different mime-type via a
response.setHeader call in the Java file - but this approach has
worked well for me.
Details about the xml file formats for excel and the other office
products can be found at:
http://www.microsoft.com/office/xml/default.mspx
Regards,
Jake MacMullin
On 15/03/2006, at 5:10 AM, Zac Konopa wrote:
I'm working on a project where we need to generate a report in an
Excel format. Has anyone done this before and do you have any tips
and tricks?
Thx
Zac
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
@csiro.au
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden