https://blog.csdn.net/sss1849/article/details/84875834
1. HSSFWorkbook类变更为IWork类,IWork类包含HSSFWorkbook和XSSFWorkbook,HSSFWorkbook只能操作excel2003以下版本,SSFWorkbook只能操作excel2007以上版本.
2. HSSFSheet、HSSFRow、HSSFCell、HSSFFont变更为ISheet、IRow、ICell、IFont
3. HSSFCellStyle.ALIGN_CENTER变更为HorizontalAlignment.Center (水平居中)、HSSFCellStyle.VERTICAL_CENTER变更为VerticalAlignment.Center(垂直居中)
4. sheet.AddMergedRegion(new NPOI.HSSF.Util.Region(0, 0, 0, titleCells)) 变更为sheet.AddMergedRegion(new CellRangeAddress(0, 0, 0, titleCells));
5. HSSFCellStyle.BORDER_THIN变更为BorderStyle.Thin
6. HSSFPatriarch patr = sheet.CreateDrawingPatriarch()变更为HSSFPatriarch patr = (HSSFPatriarch)sheet.CreateDrawingPatriarch();
7. 删除ICell.Encoding属性
8. HSSFPatriarch patr = sheet.CreateDrawingPatriarch();变更为HSSFPatriarch patr = (HSSFPatriarch)sheet.CreateDrawingPatriarch();