Re: Download of Database Into MS Excel File - How?
Re: Download of Database Into MS Excel File - How?
- Subject: Re: Download of Database Into MS Excel File - How?
- From: "Jonathan Fleming" <email@hidden>
- Date: Wed, 23 Jun 2004 18:49:02 +0100
Thanks James...
And thank you to all of you who reply and offered all very good suggestions,
if I get stuck i'll let you know, but I think it'll be ok now, you've all
left me with a massively wide smile on my face :^)
Warm regards
Jonathan :^)
From: James Cicenia <email@hidden>
To: "Jonathan Fleming" <email@hidden>
Subject: Re: Download of Database Into MS Excel File - How?
Date: Tue, 22 Jun 2004 22:51:12 -0500
Jonathan -
Just so happens that I have written a class to do this. I modified the
code to specifically handle my
need whereby I pass it an array of eo objects, a list of attributes, etc.
This was all put into another component
that did the actual exporting.
http://wodev.spearway.com/cgi-bin/WebObjects/WODev.woa/wa/Main?
wikiPage=CreateAnExcelSpreadsheet
My report generator uses a D2WList component with me passing it an arry of
eo objects, attributes etc., Since
I already new the array and the columns it was fairly easy to modify the
above code. You will also need to
grab the org.apache.poi.hssf.usermodel.*; classes from apache.
Hope this helps
James Cicenia
_________________________________________________________________
Express yourself with cool new emoticons http://www.msn.co.uk/specials/myemo
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.