hutool 精确到具体某一列设置数据单元格式
参考:https://blog.csdn.net/qq_41419769/article/details/120549716
核心代码如下:
StyleSet style = writer.getStyleSet();
CellStyle numberCellStyle = style.getCellStyleForNumber();
numberCellStyle.setDataFormat(dataFormat.getFormat("0.00000"));
writer.setStyle(numberCellStyle, 5 , 5 ); // 设置[5,5]单元格的样式
或者:
StyleSet style = writer.getStyleSet();// 获取整个Excel的格式
CellStyle numberCellStyle = style.getCellStyleForNumber();
DataFormat dataFormat = writer.getWorkbook().createDataFormat();
numberCellStyle.setDataFormat(dataFormat.getFormat("0.00000")); // 设置5位小数格式
writer.getSheet().setDefaultColumnStyle(2, numberCellStyle);
设置单元格样式:
http://www.qianduanheidong.com/blog/article/318706/d247aac4a3f53e8405e5/
![](https://img2022.cnblogs.com/blog/1704810/202208/1704810-20220809142012230-1566490181.png)