Converting into number format while writing from text file to excel in java

Question

We have one existing application where we read one text file and write into excel using java. Text file will have first row as header and subsequent rows as records which is fetched from database. Currently while writing into excel, all the columns are getting converted into text format. We want to convert one column(consider column Z) as number.

String [] column = line.split("\\|~");
   for (int i = 0; i < column.length; i++) {
                    Cell tmpCell =  row.createCell(i);

                    tmpCell.setCellValue(new HSSFRichTextString(column[i].trim()));

                }

I am new to java, need your help in resolving this issue.

Thanks Santhosh

sol4me · Accepted Answer · 2014-12-02 20:41:58Z

2

You can write to cell like this

cell.setCellValue(12345.00000)

But this alone will not be enough in case where you don't want to truncate. Using style and dataformats, you can avoid truncation. E.g.

CellStyle cellStyle = wb.createCellStyle();
DataFormat df = wb.createDataFormat();
cellStyle.setDataFormat(df.getFormat("0.0")); //you can adjust it as per your requirments
cell.setCellStyle(cellStyle);

answered Dec 2, 2014 at 20:41

sol4me

15.8k6 gold badges37 silver badges35 bronze badges

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

2 Comments

Santhosha Over a year ago

I just added cell.setCellType(Cell.CELL_TYPE_NUMERIC); and it worked good for me.

Suresh Over a year ago

@Santhosha setCellType is deprecated. Do you have any other solution?

Collectives™ on Stack Overflow

Converting into number format while writing from text file to excel in java

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related