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 (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/jake.macmullin
%40csiro.au
This email sent to [EMAIL PROTECTED]
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to archive@mail-archive.com
