Hi I have a collection which contains String data which I need to be shown in excel columns. The actual data may however be of any type (int, double, date etc) even though it is stored as string. We cannot apply any numeric function on excel generated by HSSF if we use cell.setColumnValue(Stringdata). We need to use cell.setColumnValue(double). Is it possible that POI/HSSF doesnt set the data type on its own but lets the excel determine what data is passed (as done when we pass a csv file to excel) TIA Abhishek Vinod Singh
-----Original Message----- From: Magne Skjeret [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 12:57 PM To: POI Users List Subject: Re: automatic resize of columns At 09:19 11.09.2003 +0200, you wrote: >Hi > >Just a quick question. >Is there anyway to set the columns to resize autmatically after the >contect of the cells, so that the users wont have to see those ##### cells? > >I have so far tried to do a calculation based on how many chars there are >in the cells, that is not a optimal solution, and actually fails sometimes >too when the content of the cell is large. Hmm. I should try to look on the web BEFORE I waste your time. It seems like that cant be done. Yet???? Magne >Magne > > >--------------------------------------------------------------------- >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] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.512 / Virus Database: 309 - Release Date: 8/19/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.512 / Virus Database: 309 - Release Date: 8/19/2003 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
