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 jExcel? I'm getting a similar error, but this
time on the ImageIO java class. I've checked variable names to make
sure that isn't the problem.
Here is what I have so far (after getting a workbook and a sheet):
img = createObject("java", "java.io.File").init("c:\smallBox.png");
my_input = createObject("java","javax.imageio.ImageIO").read(img);
my_baos = createObject("java","java.io.ByteArrayOutputStream");
ImageIO = createObject("java","javax.imageio.ImageIO");
ImageIO.write(my_input, "png", my_baos);
wi = createObject("java","jxl.write.WritableSheet").init(javaCast('double',1),
javaCast('double',1), javaCast('double',10), javaCast('double',10),
img);
sheet.addImage(wi);
On 6/8/07, Paul Hastings <[EMAIL PROTECTED]> wrote:
> 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 = workbook.getWorkbook(file);
>
> well i normally would do something like:
>
> <cfscript>
> spreadsheet=createObject("java","java.io.File").init("C:\invoice.xls");
> workBook=createObject("java","jxl.Workbook").getWorkbook(spreadsheet);
> ..
> ..
> ..
> ..
> </cfscript>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion MX7 and Flex 2
Build sales & marketing dashboard RIAâs for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280479
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
