poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Madhav Sadhu" <madhav.sa...@saama.com>
Subject Re: Problem with Cell formatting at columns level
Date Wed, 18 Jan 2006 18:36:16 GMT
Hi Shawn,

Do you have a sample to implement the same in POI ?
You second approach is the first one I suggested to the client, but client
is not ready to take that approach since someone has to manually format the
xls sheet.

Thanks
Madhav


----- Original Message -----
From: "Laubach Shawn Contr 327 CSSG/GFSL" <Shawn.Laubach@tinker.af.mil>
To: "POI Users List" <poi-user@jakarta.apache.org>
Sent: Wednesday, January 18, 2006 6:28 AM
Subject: RE: Problem with Cell formatting at columns level


> Besides the macro, there are two methods that can be used.
>
> 1.  Implement the code in poi.  The record that tracks it is the
> ColumnInfoRecord.  You'd have to expose a method to get and set these
> records.
>
> 2.  *easier*  Create a blank sheet with the columns formatted the way you
> want then when your code runs, instead of creating a new blank sheet, read
> the new blank sheet and run as normal.
>
> Shawn
>
> -----Original Message-----
> From: Madhav Sadhu [mailto:madhav.sadhu@saama.com]
> Sent: Tuesday, January 17, 2006 1:25 PM
> To: POI Users List
> Subject: Problem with Cell formatting at columns level
>
> Hello,
>
> I need to format the entire column of an excel. Currently, the only way I
> can do it is by assigning a format to all the cells. However, for my
> requirement, I  need to create a blank excel sheet with the columns
> formatted, so that when users use that excel to fill in data, they donot
do
> need to worry about putting the data in a proper format.
>
> I had posted this in the bug list and sent an email also on the same but
> could not get any help. Any help in this matter is greatley appreciated.
>
> Thanks
> Madhav
>
>
> ---------------------------------------------------------------------
> 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/
>


---------------------------------------------------------------------
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