Hi Jake,
This looks like a great way of doing it. Couple of questions if you
have a spare moment.
1) Do you copy and paste the whole XML file or just the table part ?
i.e. do you include things like the DocumentProperties and Styles ? I
assume so.
2) What version of WO are you using ? Because when I open the file up
in WOBuilder my rows and columns are all hidden in single HTML style
table cell so I can't ( unless I do it in the text ) change my place
holder values with dynamic ones as you suggest in step 3 below. Is if
the case that you need to add your WO tages by hand ?
Thanks
Owen
On 16/03/2006, at 9:06 AM, Jake Macmullin wrote:
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/owen%
40uow.edu.au
This email sent to [EMAIL PROTECTED]
Owen McKerrow
WebMaster, emlab
http://emlab.uow.edu.au
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - -
'The test of a first-rate intelligence is the ability to hold two
opposed ideas in the mind at the same time and still be able to
function.'
-F.Scott Fitzgerald,
_______________________________________________
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
