You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by abhishek <as...@xora.com> on 2003/09/11 10:23:41 UTC
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)
TIA
Abhishek Vinod Singh
-----Original Message-----
From: Magne Skjeret [mailto:magne.skjeret@broadpark.no]
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: poi-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
---
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: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org