how to remove warnings in excel generated by POI ?

Question

I am using Apache POI for writing content into excel sheet. after generating an excel in all the cells which ever cell has numbers, it contains one blue mark(each cells left top corner). its like a warning. how can i remove them while writing the content to excel? PFA screen shot.

Thanks!

Answer 1

Below works for me.

**

HSSFCell cell = row1.createCell(i);
cell.setCellType(new Double(value));

**

Note: 'value' should be on numerals , it won't work on alphanumeric values. replace it wherever(cell values) it is required.

Answer 2

You can try to set the cell type:

HSSFCell cell = row1.createCell(i);
cell.setCellType(Cell.CELL_TYPE_STRING); // =0, or Cell.CELL_TYPE_NUMERIC = 1
cell.setCellValue(value);

See the API docs for more information.