poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Yegor Kozlov <ye...@dinom.ru>
Subject Re[2]: [POI- HSSF] Alignment issue in sizing the Cell automatically
Date Fri, 23 Mar 2007 08:31:28 GMT

VK> Can i keep the image irrespective of the column size?

No, you can't. Image anchor defines how many cells the image occupies.
If you resize columns the image gets resized too.
What POI lacks is the ability to edit anchors of existing shapes. Now you can set anchor
only when shape is constructed. In other words you can't resize images
that are already ion worksheet.

Is it possible for you to defer inserting image until all columns are
resized?

Yegor

VK> _______________________________________________________________________________________________________

VK>       HSSFRow headerRow = sheet.createRow((short)0);
VK>       sheet.addMergedRegion(new Region(0,(short)0,1,(short)6));
VK>       //Displaying Logo
VK>       byte[] picData = null;
VK>       File pic = new File("C:\\images\\excelLogo.jpeg");
VK>       long length = pic.length();
VK>       picData = new byte[(int) length];
VK>       FileInputStream picIn;
VK>       picIn = new FileInputStream(pic);
VK>       picIn.read(picData);
VK>       int index = workbook.addPicture(picData,
VK> HSSFWorkbook.PICTURE_TYPE_JPEG);

VK>       HSSFPatriarch patriarch = sheet.createDrawingPatriarch();
VK>       HSSFClientAnchor anchor = new
VK> HSSFClientAnchor(0,0,0,255,(short)0,0,(short)1,1);
VK>       HSSFSimpleShape shape = patriarch.createPicture(anchor,index);
VK>       shape.setShapeType(HSSFSimpleShape.OBJECT_TYPE_PICTURE);

VK> _________________________________________________________________________________________________________


VK>      Please help me in this regard,

VK> Thanks,
VK> Vinay


VK> On 3/21/07, Yegor Kozlov <yegor@dinom.ru> wrote:
>>
>> Hi,
>>
>> The POI 3.0 RC1 can be downloaded from
>>         http://people.apache.org/~nick/POI-3.0-RC1/
>>
>> HSSFSheet.autoSizeColumn was added after 12-Dec-2006.
>> Try the latest jar.
>>
>> Regards,
>> Yegor
>>
>> VK> Hi all,
>>
>> VK> I'm new to this group. I'm trying to generate MS Excel from my java
>> code.
>> VK> I'ts working great, but i have some alignment issue like the width of
>> the
>> VK> cell is not enough to fit the text.
>>
>> VK> i.e the cell width is not good enough to view the text that is
>> displaying.
>> VK> I need to set the width size automatic (i.e something like AutoFit
>> option)
>> VK> i.e the cell width should be set to max length of text value in that
>> column.
>>
>> VK> I walked through api of HSSF (poi) but i dont find any method to set
>> the
>> VK> autoSize of the Column
>> VK> i have latest jar of poi-bin-3.0-alpha3-20061212 (12-Dec-2006)
>>
>> VK> I have seen in couple of places that new method called
>> "autoSizeColumn()"
>> VK> was added, but i don't see even in alpha build, is there any other
>> build
>> VK> lately,
>>
>> VK> Please provide me the link to download the latest jar of POI.
>>
>> VK> Any Suggestions will be appreciated .
>>
>> VK> Looking for any kind of help, i was in little bit urgency.
>>
>> VK> Thanks,
>> VK> Vinay
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
>> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
>>
>>


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/


Mime
View raw message