如何在POI生成的excel中删除警告?

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.

我正在使用Apache POI将内容写到excel表中。在所有有数字的单元格中生成excel后，它包含一个蓝色标记(每个单元格位于左上角)。它像一个警告。我如何在写内容的时候删除它们呢?PFA屏幕截图。

Thanks!

谢谢!

2 个解决方案

#1

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.

有关更多信息，请参见API文档。

#2

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.

注意:'value'应该在数字上，它不会在字母数字上起作用。在需要的地方替换它(单元格值)。