Setting Excel cell value in Numeric format using POI

Question

I want to store numeric data in excel sheet.
The numeric data is represented by String type in my java code.
Is it possible to set it as numeric without casting it?

I've tried the following code, but it wasn't converted to numeric type (I get a warning in excel saying that number is stored as text...)

HSSFCell dCell =...
dCell.setCellType(Cell.CELL_TYPE_NUMERIC);
dCell.setCellValue("112.45")

Isn't the setCellValue method overloaded to support other types, i.e. can't you pass a float or something into that method? You are currently passing a string. — mydoghasworms
– mydoghasworms, Commented Jan 23, 2012 at 6:31
Yes, I can pass any type. I asked if its possible to pass value AS String and auto-convert it to the needed type. — omrid
– omrid, Commented Jan 23, 2012 at 6:40
see this: [enter link description here][1] [1]: stackoverflow.com/questions/5335285/… — John Ding
– John Ding, Commented Jun 10, 2014 at 13:57

shadyabhi · Accepted Answer · 2014-01-12 10:54:26Z

29

You have to provide the value as a double. As the doc says:

setCellValue

public void setCellValue(double value)

set a numeric value for the cell

Parameters:

value - the numeric value to set this cell to. For formulas we'll set the precalculated value, for numerics we'll set its value. For other types we will change the cell to a numeric cell and set its value.

So, it should be

dCell.setCellValue(new Double("123"));

OR

dCell.setCellValue(123);  //Remember, the way you did was, you actually passed a string (no quotes)

edited Jan 12, 2014 at 10:54

user447356

answered Jan 23, 2012 at 6:36

shadyabhi

17.4k28 gold badges86 silver badges135 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

omrid Over a year ago

so I must set value in the needed type? it can't be "auto-converted" from String?

shadyabhi Over a year ago

No, simply use what I said or dCell.setCellValue(123). Remember, no quotes or it will make it a string. (which you actually did)

Kushan · Accepted Answer · 2012-01-23 06:34:55Z

8

I used Big Decimal for this,

dCell.setCellValue(new BigDecimal("112.45").doubleValue());

answered Jan 23, 2012 at 6:34

Kushan

10.7k4 gold badges39 silver badges41 bronze badges

1 Comment

ram Over a year ago

Thank you. I was looking for Big decimal conversion too.

Arun · Accepted Answer · 2012-01-23 06:34:51Z

2

Try to use wrapper classes:

dCell.setCellValue(new Double(112.45));

BTW, it will work if you simply give the value instead of the double cotes as follows:

dCell.setCellValue(112.45);

answered Jan 23, 2012 at 6:34

Arun

2,5726 gold badges27 silver badges44 bronze badges

Comments

Peru · Accepted Answer · 2014-06-05 09:09:29Z

1

Old one But Still it This will help Some one from .NET who use NPOI

dCell.setCellValue(Convert.ToDouble(112.45));

We do have

cell.SetCellType(NPOI.SS.UserModel.CellType.NUMERIC);

which doesn't remove the warning but the 1st code did worked after converting to Double for All integers and Double values in .net

answered Jun 5, 2014 at 9:09

Peru

2,9916 gold badges42 silver badges68 bronze badges

Collectives™ on Stack Overflow

Setting Excel cell value in Numeric format using POI

4 Answers 4

2 Comments

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related