Mailing-List: contact user-help@poi.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Users List" <user@poi.apache.org>
Received-SPF: pass (athena.apache.org: domain of flavio.cimolin@cd-adapco.com
 designates 209.85.214.46 as permitted sender)
Message-ID: <4FD74A04.9060106@cd-adapco.com>
Date: Tue, 12 Jun 2012 15:54:12 +0200
From: Flavio Cimolin <flavio.cimolin@cd-adapco.com>
Reply-To: flavio.cimolin@cd-adapco.com
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
 rv:12.0) Gecko/20120428 Thunderbird/12.0.1
MIME-Version: 1.0
To: user@poi.apache.org
Subject: Problem with inserting images after saving an HSSFWorkbook
Content-Type: multipart/alternative;
 boundary="------------000503090105070002080305"

--------------000503090105070002080305
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit

Hello, I can't understand an issue related to inserting images in an 
HSSFWorkbook. In the example below, if I save a copy of the Workbook 
before inserting the second image, the final saved file doesn't display 
the second image. On the other hand, if I don't perform the intermediate 
saving, the final file is correctly saved as expected.

I have highlighted with asterisks the portion of code that gives the 
problem when uncommented:

try {

     HSSFWorkbook wb = new HSSFWorkbook();
     HSSFSheet sheet = wb.createSheet("Sheet 1");

     CreationHelper helper = wb.getCreationHelper();
     Drawing drawing = sheet.createDrawingPatriarch();

     {
         InputStream is = new FileInputStream(resolvePath("imm1.png"));
         byte[] bytes = IOUtils.toByteArray(is);
         int pictureIdx = wb.addPicture(bytes, Workbook.PICTURE_TYPE_PNG);
         is.close();

         ClientAnchor anchor = helper.createClientAnchor();
         anchor.setRow1(1);
         anchor.setCol1(2);
         Picture pict = drawing.createPicture(anchor, pictureIdx);
         pict.resize();
     }

     // 
***************************************************************************************************
     // FileOutputStream fileOut1 = new 
FileOutputStream(sim.getSessionDir() + File.separator + 
"example_image_1.xls");
     // wb.write(fileOut1);
     // fileOut1.close();
     // 
***************************************************************************************************

     {
         InputStream is = new FileInputStream(resolvePath("imm2.png"));
         byte[] bytes = IOUtils.toByteArray(is);
         int pictureIdx = wb.addPicture(bytes, Workbook.PICTURE_TYPE_PNG);
         is.close();

         ClientAnchor anchor = helper.createClientAnchor();
         anchor.setRow1(14);
         anchor.setRow2(1);
         Picture pict = drawing.createPicture(anchor, pictureIdx);
         pict.resize();
     }


     FileOutputStream fileOut2 = new 
FileOutputStream(sim.getSessionDir() + File.separator + 
"example_image_2.xls");
     wb.write(fileOut2);
     fileOut2.close();

} catch (IOException ex) {
      sim.println(ex);
}


Thanks in advance for telling me whether I am making something wrong or 
it is a bug...

Regards,
Flavio


-- 
Flavio Cimolin
Technical Support Engineer
CD-adapco, Turin Office
phone: +39 011 562 2194 (int 413)
email: flavio.cimolin@cd-adapco.com <mailto:flavio.cimolin@cd-adapco.com>
web: http://www.cd-adapco.com

--------------000503090105070002080305--