Thanks. I used cell.setColumnValue(double). Just asked the calling module to pass me the data types info for columns as well. My problem was solved. Abhishek
-----Original Message----- From: Mehner [mailto:Mehner] Sent: Thursday, September 11, 2003 7:49 PM To: 'POI Users List' Subject: AW: Setting data type in HSSF excel cells > 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) AFAIK this is not done by Excel but by a csv import module. Maybe you can do it with cell.setCellType(int type)? But I do not know if this works on cells that strings have already been written to. Docu says nothing about it, so it is just a guess. bye, Bodo --- 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]
