Prachi, you have to options:
(a) download the latest build and try HSSFPicture.resize(). It will
resize the image to its original dimensions.
(b) Specify the image position when constructing HSSFClientAnchor. In
this case you set the upper-left and bottom-right coordinates.
From your previous post I understood you wanted to fit the image in 1
column and 1 row. If so, the anchor should be
new HSSFClientAnchor(0,0,0,0,(short)2,i,(short)5,i+1).
anchor.setAnchorType() does not affect the image position. To better
understand it, insert an image with anchor.setAnchorType(1) and open the
workbook in Excel. Go to the Format Picture dialog, Properties tab.
Here is your setting. Try to resize columns. Try to change this
property and see how Excel behaves when you resize columns.
Regards,
Yegor
> Hi,
>
> I will try getting the latest build and try this method.
> thanks!
>
> The sample code I am currently using is:
>
> try{
> HSSFWorkbook wb = new HSSFWorkbook();
> HSSFSheet sheet = wb.createSheet("new sheet");
>
> sheet.setColumnWidth((short)2, (short) 5250);
> HSSFPatriarch patriarch = sheet.createDrawingPatriarch();
> HSSFClientAnchor anchor;
>
> for(int i=0;i<2;i++){
>
> HSSFRow row = sheet.createRow((short)i);
> HSSFCell cell = row.createCell((short)0);
>
> row.createCell((short)0).setCellValue(i+1);
> row.createCell((short)1).setCellValue("Compound " + (i+1));
> row.setHeight((short)2500);
> //sheet.addMergedRegion(new
> Region(i,(short)2,i,(short)5));
>
> anchor = new
> HSSFClientAnchor(0,0,0,0,(short)2,i,(short)5,i);
> anchor.setAnchorType( 3 ); --tried using 2 as well!
> patriarch.createPicture(anchor, loadPicture( <image path>, wb
> ));
> }
>
> }catch(IOException ex)
> {
> System.out.println("Error!!");
> }
>
> This resizes the image and extends as per the row height and column width.
>
> Let me know if theres something I am missing or doing incorrectly.
>
> Regards,
> PRachi
> ________________________________
> From: Yegor Kozlov [mailto:[EMAIL PROTECTED]
> Sent: Fri 19/10/2007 13:58
> To: POI Users List
> Subject: Re[4]: Export an image as PNG to a particular cell in Excel using
> POI.
>>
>> I could not find HSSFPicture.resize() .
>> May be I dont have the updated APIs.
> You need to build POI from svn or download a daily build from
> http://encore.torchbox.com/poi-svn-build/.
>> But would this retain the original size of the image?
> Yes, HSSFPicture.resize() adjusts anchor to the actual image
> dimensions.
>>
>> Even if I set the anchor type to 2 or 3, it does resize the image
>> and extends to the number of columns specified.
>> Am I missing something?
>>
> Would you provide sample code?
> Yegor
>> ________________________________
>> From: Yegor Kozlov [mailto:[EMAIL PROTECTED]
>> Sent: Tue 16/10/2007 15:04
>> To: POI Users List
>> Subject: Re[2]: Export an image as PNG to a particular cell in Excel using
>> POI.
>> I've recently added HSSFPicture.resize() which resizes image anchor to
>> the actual width and height. It might be useful to you.
>> If you want to set the anchor manually you need to change the anchor
>> type as follows:
>> anchor.setAnchorType(2); //Move but don't size with cells
>> By default anchor type=0 which means "Move and size with Cells" and it
>> is what is happening with your image: it gets resized when you resize
>> the columns.
>>> Also, if I need to fit the image to just 1 column and 1row and not
>>> span multiple cols/rows, how should the following API be used:
>>> anchor = new HSSFClientAnchor(0,0,0,255,(short)2,2,(short)4,7);
>>> I am quite confused on the x/y coordinates.
>> The first four values define the offset in the top-left and
>> bottom-right cells. If you need to fit an image to exactly 1 column
>> and 1 row leave them 0. The next four values are 0-based coordinates of
>> the top-left and bottom-right cells.
>> So, to put an image in 1x1 cell the anchor would be
>> new HSSFClientAnchor(0,0,0,0,(short)col1, row1,(short)(col1+1), row+1);
>> where col1 and row1 are coordinates of the top-left cell.
>> Regards,
>> Yegor
>>> Any help on its usage would be appreciated.
>>>
>>> Thanks,
>>> Prachi
>>> ________________________________
>>> From: Nick Burch [mailto:[EMAIL PROTECTED]
>>> Sent: Mon 15/10/2007 11:19
>>> To: POI Users List
>>> Subject: RE: Export an image as PNG to a particular cell in Excel using POI.
>>> On Fri, 12 Oct 2007, [EMAIL PROTECTED] wrote:
>>>> Yes, the positioning can be achieved, but then as the documentation
>>>> says, that any existing image would be erased with the new image.
>>> I didn't write the code so I can't be sure, but I have a feeling that the
>>> warning relates to images already in the file when you start, not ones you
>>> add in. So, you ought to be fine to open the file up, and add several
>>> images to it before closing.
>>> Nick
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: [EMAIL PROTECTED]
>>> For additional commands, e-mail: [EMAIL PROTECTED]
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: [EMAIL PROTECTED]
>> For additional commands, e-mail: [EMAIL PROTECTED]
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
