Avik, How do I pick a particular cell value for all the rows in an excel sheet.
that is in a for loop, I want to add 5th column values of all the rows to a list... can I achieve this by POI API.. appreciate your help. Som -----Original Message----- From: Avik Sengupta [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 9:35 AM To: POI Users List Subject: Re: Autofit with POI? >It's my understanding that > there is no all-in-one way of doing this using the POI HSSF API. Unfortunately, thats the case. From the archives, you would have noticed thats its been asked for many times, but not yet done, which would suggest that it isnt very easy! Regards - Avik On Thu, 2003-09-25 at 11:10, Hernan Silberman wrote: > I apologize for posting before reading the archives. It's my understanding that > there is no all-in-one way of doing this using the POI HSSF API. Please let me > know if this is not true. > > I suppose I will explicitly size each column in my code at runtime once all of > the cells in the sheet are populated with data. > > thanks... > Hernan > > On Wed, 24 Sep 2003, Hernan Silberman wrote: > > > > > First of all, I've been using POI for a few weeks now and I love it! > > > > In Excel, I can select a region and do Format->Row->Autofix to automatically > > resize columns to conform to the widest cell value in the column. > > > > I see how I can possibly do this by keeping track of the cell widths when I > > generate the sheet and then using HSSFSheet->setColumnWidth(col,width), > > but I was wondering if there's an easier and more elegant way of doing it. > > > > Any insight would be much appreciated. > > > > thanks... > > Hernan Silberman > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
