Re: Generating reports in excel?
Re: Generating reports in excel?
- Subject: Re: Generating reports in excel?
- From: Jake Macmullin <email@hidden>
- Date: Tue, 28 Mar 2006 08:13:03 +1100
Owen,
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.
Yep, the whole XML file.
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 ?
Sorry, I should have been clear on this - you need to do this in
source view. You might find it easiest to set up the bindings in the
WYSIWYG mode using WOBuilder - then switch to source view and replace
the HTML with the Excel XML (making sure you put the WebObject tags
in the right spot).
Cheers,
Jake
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 (email@hidden)
Help/Unsubscribe/Update your Subscription:
email@hidden
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:
40uow.edu.au
This email sent to email@hidden
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 (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden