NPOI 1.2.1版本替换为2.4.0版本实体类变更

https://blog.csdn.net/sss1849/article/details/84875834

 1. HSSFWorkbook类变更为IWork类,IWork类包含HSSFWorkbookXSSFWorkbook,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();
posted @ 2019-11-25 11:27  奇微  阅读(428)  评论(0编辑  收藏  举报