Re: Read and write Excel sheet with formatting

2010-08-12 Thread Larry C. Lyons
Ben Nadel has a great Poi component. http://www.bennadel.com/projects/poi-utility.htm On Thu, Aug 12, 2010 at 12:03 PM, Judah McAuley wrote: > > Take a look at the Apache POI utility. There are some CF wrappers for > it, I believe, and it is also what Adobe is using under the covers for > its cf

Re: Read and write Excel sheet with formatting

2010-08-12 Thread Judah McAuley
Take a look at the Apache POI utility. There are some CF wrappers for it, I believe, and it is also what Adobe is using under the covers for its cfspreadsheet tag. On Thu, Aug 12, 2010 at 2:34 AM, marc -- wrote: > > Hi > On the server (CF 8.0) I have an Excel .xls file. It is a simple file > co

Read and write Excel sheet with formatting

2010-08-12 Thread marc --
Hi On the server (CF 8.0) I have an Excel .xls file. It is a simple file containing text and formatting (no macros etc). What I want to do is to read it, replace a few placeholders (,)in cells with their actual values (the current date and name of logged in user) and stream the modified file t