Thanks wud try with that ..

On Fri, Dec 19, 2008 at 1:20 AM, Avinash Kewalramani <
[email protected]> wrote:

> 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]
>
>


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

Reply via email to