[prev in list] [next in list] [prev in thread] [next in thread] 

List:       poi-user
Subject:    Re: logo along with a Chart in Excel (HSSF)
From:       Princess <hepzibahr () googlemail ! com>
Date:       2008-12-19 10:27:29
Message-ID: 7eb08cd80812190227q357ba697gc8ee9dccd6a295be () mail ! gmail ! com
[Download RAW message or body]


Thanks wud try with that ..

On Fri, Dec 19, 2008 at 1:20 AM, Avinash Kewalramani <
AKewalramani@accelrys.com> wrote:

> Hi
>
> Is creation of data charts supported in POI v3.5 beta 4?
>
> Avi
>
>
> -----Original Message-----
> From: Princess [mailto:hepzibahr@googlemail.com]
> 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: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>


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


[prev in list] [next in list] [prev in thread] [next in thread]