You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Vinay Konanki <vi...@gmail.com> on 2007/03/21 22:27:24 UTC
[POI- HSSF] Alignment issue in sizing the Cell automatically
Hi all,
I'm new to this group. I'm trying to generate MS Excel from my java code.
I'ts working great, but i have some alignment issue like the width of the
cell is not enough to fit the text.
i.e the cell width is not good enough to view the text that is displaying.
I need to set the width size automatic (i.e something like AutoFit option)
i.e the cell width should be set to max length of text value in that column.
I walked through api of HSSF (poi) but i dont find any method to set the
autoSize of the Column
i have latest jar of poi-bin-3.0-alpha3-20061212 (12-Dec-2006)
I have seen in couple of places that new method called "autoSizeColumn()"
was added, but i don't see even in alpha build, is there any other build
lately,
Please provide me the link to download the latest jar of POI.
Any Suggestions will be appreciated .
Looking for any kind of help, i was in little bit urgency.
Thanks,
Vinay
Re: Re[2]: [POI- HSSF] Alignment issue in sizing the Cell automatically
Posted by Vinay Konanki <vi...@gmail.com>.
Thanks Yegor,
Ya its possible to insert after doing alignments for all columns, Its looks
better now.
-Vinay
On 3/23/07, Yegor Kozlov <ye...@dinom.ru> wrote:
>
>
> 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 <ye...@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/
>
>
Re[2]: [POI- HSSF] Alignment issue in sizing the Cell automatically
Posted by Yegor Kozlov <ye...@dinom.ru>.
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 <ye...@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/
Re: [POI- HSSF] Alignment issue in sizing the Cell automatically
Posted by Vinay Konanki <vi...@gmail.com>.
Thanks Yegor,
Its working great, but getting another alignment issue with this,
i used logo (image) in the excel sheet. with the auto sizing the image also
expanding and contracting according to that column data.
Can i keep the image irrespective of the column size?
Here is the code that i used to insert the image..
_______________________________________________________________________________________________________
HSSFRow headerRow = sheet.createRow((short)0);
sheet.addMergedRegion(new Region(0,(short)0,1,(short)6));
//Displaying Logo
byte[] picData = null;
File pic = new File("C:\\images\\excelLogo.jpeg");
long length = pic.length();
picData = new byte[(int) length];
FileInputStream picIn;
picIn = new FileInputStream(pic);
picIn.read(picData);
int index = workbook.addPicture(picData,
HSSFWorkbook.PICTURE_TYPE_JPEG);
HSSFPatriarch patriarch = sheet.createDrawingPatriarch();
HSSFClientAnchor anchor = new
HSSFClientAnchor(0,0,0,255,(short)0,0,(short)1,1);
HSSFSimpleShape shape = patriarch.createPicture(anchor,index);
shape.setShapeType(HSSFSimpleShape.OBJECT_TYPE_PICTURE);
_________________________________________________________________________________________________________
Please help me in this regard,
Thanks,
Vinay
On 3/21/07, Yegor Kozlov <ye...@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/
>
>
Re: [POI- HSSF] Alignment issue in sizing the Cell automatically
Posted by Yegor Kozlov <ye...@dinom.ru>.
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/