Hi Is creation of data charts supported in POI v3.5 beta 4?
Avi -----Original Message----- From: Princess [mailto:[email protected]] Sent: Thursday, December 18, 2008 10:33 AM To: POI user Subject: logo along with a Chart in Excel (HSSF) int pictureIndex = wb.addPicture(data, HSSFPicture.PICTURE_TYPE_PNG); HSSFSheet sheet = wb.getSheetAt(1); HSSFPatriarch patriarch = sheet.createDrawingPatriarch(); //all pictures use the same picture index, thus sharing the same picture data HSSFPicture pic1 = patriarch.createPicture(new HSSFClientAnchor(0, 0, 10, 10, (short)10, 0, (short)13, 3), pictureIndex); The above code works when i have a worksheet with no graph/chart .. But my requirement is a Excel file which will have data in sheet1 and a Chart for the Data in Sheet2 along with a logo. Now When using the aboce code snippet i get a error message saying that the Data would be lost and on opening the file Sheet2 is totally erratic..Sheet1 is intact I am using a Template for this --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
