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" <[EMAIL PROTECTED]> To: "POI Users List" <[email protected]> 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:[EMAIL PROTECTED] > 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: [EMAIL PROTECTED] > Mailing List: http://jakarta.apache.org/site/mail2.html#poi > The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > Mailing List: http://jakarta.apache.org/site/mail2.html#poi > The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
