Hello Mark,
Thanks for u r reply, in my application am using Image(Logo).
i set the autosize for data, but image also expanding. How to do
irrespective of image with out autosize.
Thanks,
deepu
MSB wrote:
>
> I have not ried this but I do believe that it will work.
>
> Add all of the data to your sheet with the exception of any that should
> not affect the call to the HSSFSheet.autoSizeColumn() method. Call that
> method then add the remaining data to the sheet. I believe that the data
> added after the method call will not affect the automatic resizing of the
> columns width.
>
> It should be easy enough to check by creating cells in column one of rows
> one, three and four and then calling the autoSizeColumn() method on column
> one of the sheet. Next add data to the appropriate cell in row two and
> make sure it is larger/longer than the data in the corresponding cell in
> rows one, three and four. Save the workbook away and then open it up using
> Excel.
>
> Yours
>
> Mark B
>
>
> deep4u wrote:
>>
>> Hello,
>> I am new to this. In my application i generate Excel Sheet using
>> apache poi. Its working fine. but my requirement is i set the autosize to
>> 1st coulmn in that no need of some cells. For this how can we
>> implement,please share your ideas.
>>
>> Regards,
>> Deepu
>>
>
>
--
View this message in context:
http://www.nabble.com/autosize-in-Excel-tp24604780p24621632.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
