Check out the docs, but i suppose what you want is row.getCell(short) ? On Thu, 2003-09-25 at 20:51, som kolli wrote: > 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] > >
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
