poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Princess <hepzib...@googlemail.com>
Subject display image in a cell thru a Excel UDF
Date Thu, 11 Dec 2008 15:49:22 GMT
I have  a function which shows the .png  in a cell.
Now the parameter to the function is a dynamic path
for eg =ShowPicD("C:\test\a.png") when i try this out
in excel it works fine .But when i try the same  thru POI and
set this as a formula it throws error and does not show
the image in the cell ..

Can anyone tell me where do i go wrong

HSSFCell cellImagePath = rowImagePath.getCell((short) 5);
            if(cellImagePath == null){
                cellImagePath = rowImagePath.createCell((short) 5);

            String formula ="ShowPicD(\""+imagePath+"\")";
            cellImagePath.setCellFormula(formula);

-- 
Hepzibah
**Hope can be ignited by a spark of encouragement *****

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message