I forgot to add that if anyone has another way to do this, I am open
to that too. I have banged my head up against the Jakarta POI api wall
for a solution to this too. There I am able to open an excel file and
resave it, but the image part doesn't seem to work for me. I get File
error: data may
Matt Williams wrote:
create a new, blank workbook, so I believe the jar file is installed
correctly (placed in c:\CFusionMX7\lib).
stop/restart the cf server service?
workbook = createObject(java,jxl.Workbook);
file = createObject(java,java.io.File).init(C:\invoice.xls);
workbook =
Matt,
However, when I call getWorkbook, I get an error saying that method
cannot be found. Here is what I have that will throw that error.
workbook = createObject(java,jxl.Workbook);
file = createObject(java,java.io.File).init(C:\invoice.xls);
workbook = workbook.getWorkbook(file);
Try using
Thanks for replying guys. After playing with both of your code
samples, it turns out my problem was using the word file as my
variable name. That is a keyword in java so doing getWorkbook(file)
was breaking.
On to the next step. Has anyone taken an existing image and put it
into a spreadsheet via
Okay. I got it working. Definitely some java strictness going on. And
being pretty much java stupid, I did much trial and error to get this
to work. I'll post code here and maybe blog it later so hopefully
anyone in the future can find it. Using jExcel, I was able to open an
existing spreadsheet,
Have you seen Ben Nadel's POI Utility? It's pretty awesome, makes CF/excel
almost effortless.
http://www.bennadel.com/index.cfm?dax=blog:474.view
Will
~|
ColdFusion MX7 by AdobeĀ®
Dyncamically transform webcontent into Adobe
6 matches
Mail list logo