As far as POI cfc's go, I've used cfHSSF (http://cfhssf.riaforge.org/) with a lot of success to read from Excel spreadsheets and I believe it can also create them.http://cfhssf.riaforge.org/ I've deployed my code on CF7 but have developed it on OBD.
cfExcelProxy (http://cfexcelproxy.riaforge.org/) is another similar project, but I wasn't able to get it working on CF7 which meant it was no good to me. Might work in OBD though - not sure. Definitely cfHSSF does all I need, although from memory it doesn't have a lot of doco. Let me know if you need a hand with it though, I'm happy to share my experiences with it. Andrew. 2008/12/25 Scott Sledgister <[email protected]> > > Thanks to all for the suggestions. I am going to play with the POI cfc > and see if I can get my reports into it. The thing I'm excited about is > the ability to create multi pages sheets. Thanks again for your help. > > > Scott Sledgister > QSR Technology, Inc > [email protected] > 970-690-3501 > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf > Of Alan Williamson > Sent: Wednesday, December 24, 2008 4:12 AM > To: [email protected] > Subject: [OpenBD] Re: OpenBD and excel > > > Chris thats a fantastic little tip. > > works a treat -- i have just had to do some reporting output, and i had > all my stuff in a query. even if you just <CFDUMP> your query object, > Excel will pick it all out beautifully. > > I'll add this to the WIKI > > Scott Sledgister wrote: > > Thanks I'll give it a try > > I just serve up an html table with headers to tell the browser its an > > excel file > > > > <cfheader name="Content-Disposition" value='inline; > filename="report.xls"'> > > <cfcontent type="application/vnd.ms-excel" reset="true"> > > > > > > > --~--~---------~--~----~------------~-------~--~----~ Open BlueDragon Public Mailing List http://groups.google.com/group/openbd?hl=en official blog @ http://blog.openbluedragon.org/ !! save a network - trim replies before posting !! -~----------~----~----~----~------~----~------~--~---
