Hi Anthony, Thanks for the quick reply.
I tried this approach before and it works, but the issue is, I need to serve this xls over the web to the client browser. This will increase the download time and network traffic if I create a huge XLS file with blank rows and send it across the web. User might end up using 10 rows, whereas I have to send a file with 65000(this is the maximun number that is alowed in xls I guess) rows. Are you aware of any licensed tools which will allow to set formatting at Column level (No JNI wrappers over COM components since my environment is linux) ? Thanks Madhav ----- Original Message ----- From: "Anthony Andrews" <[EMAIL PROTECTED]> To: "POI Users List" <[email protected]> Sent: Tuesday, January 17, 2006 12:02 PM Subject: Re: Problem with Cell formatting at columns level > As far as I am aware, there is no way to apply a format to a column - that is too all of the cells in a column - using a single command. What you will have to do is add blank cells to the column in question; perhaps surprisingly, it is possible to set the format for Blank cells. That should ensure that the format of the cells in the column is set ready for your users to enter data. > > I have to admit however, that I have not tried this myself but I believe it will work. > > Madhav Sadhu <[EMAIL PROTECTED]> wrote: 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/ > > > > > > --------------------------------- > Yahoo! Photos > Got holiday prints? See all the ways to get quality prints in your hands ASAP. --------------------------------------------------------------------- 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/
