java - poi导出Excel时设置数据格式为double类型。

Question

导出数据为Excel的时候，如何设置Excel的数据格式为double格式

Answer 1

As for the POI3 version, the types supported by the cell are
@see #CELL_TYPE_NUMERIC

• @see #CELL_TYPE_STRING

• @see #CELL_TYPE_FORMULA

• @see #CELL_TYPE_BLANK

• @see #CELL_TYPE_BOOLEAN

• @see #CELL_TYPE_ERROR
  Of course, it should be noted that when using NUMERIC, you need to consider whether it is a date. You can use DateUtil.isCellDateFormatted(cell) to verify whether it is a date type