记录一下这个网址,怕忘记了,推荐
https://www.javajike.com/book/hutool/chapter1/a01987bb7f5cfeac4677e49460daf856.html
huTool中DateUtil
// 当前日期是否在日期指定范围内, 起始日期和结束日期可以互换
boolean isIn(Date date, Date beginDate, Date endDate);
huTool中ExcelWriter
//通过工具类创建writer
ExcelWriter writer = ExcelUtil.getBigWriter();
Sheet sheet = writer.getSheet();
// 导出时 hutool中Excelwriter 设置excel 某一列为文体格式
// 列表设置为文本格式
CellStyle style = writer.createCellStyle();
Workbook wb = writer.getWorkbook();
DataFormat format = wb.createDataFormat();
style.setDataFormat(format.getFormat("@"));
// 设置表格第二列为文本格式
sheet.setColumnWidth(0, 20 * 256);
sheet.setColumnWidth(1, 40 * 256);
sheet.setDefaultColumnStyle(1,style);
// -------------------------------------------------------------
// 导入读取转为字符串格式
/**
* 根据行,n列,判断如果是数值转成字符串
*/
private String getStringValueByRowAndCell(Row row, int cell) {
String value;
if (Objects.isNull(row.getCell(cell))) {
return "";
}
if(Objects.equals(CellType.NUMERIC,row.getCell(cell).getCellType())){
value = row.getCell(cell).getNumericCellValue() + StrUtil.EMPTY;
} else {
value = row.getCell(cell).getStringCellValue();
}
return value;
}