Modify Excel Spreadsheet

2012-06-07 Thread Richard White (Re-Base)
Hi, I have a feeling I am missing something simple! I have an excel spreadsheet template that includes images, cell formatting etc... I need to open the spreadsheet, insert the data where required, save and close the document. Do i need to use POI for this? I was trying to read th

Re: Modify Excel Spreadsheet

2012-06-08 Thread Richard White
Hi, does anyone have any feedback on whether its possible to open, modify and close excel spreadsheets with CF tags/functions, or would i need to use the underlying POI? thanks ~| Order the Adobe Coldfusion Anthology now! h

Re: Modify Excel Spreadsheet

2012-06-08 Thread Matt Quackenbush
Have you looked at ? Sent from my Samsung Galaxy SII On Jun 8, 2012 2:43 AM, "Richard White" wrote: > > Hi, > > does anyone have any feedback on whether its possible to open, modify and > close excel spreadsheets with CF tags/functions, or would i need to use the > underlying POI? > > thanks >

Re: Modify Excel Spreadsheet

2012-06-09 Thread Richard White
Yes, although the problem i am experiecing is this... I read the spreadsheet With cfspreadsheet which puts it into a query but at this point it has lost all the formatting (bold, font size, colours, images etc) so if I try to use cfspreadsheet to update or write to a spreadsheet all that forma