NPOI编码下*.xlsx与*.xls的差异

NPOI编码下*.xlsx与*.xls的差异

1.打开book的差异，实现的类不一样

//打开*.xlsx文件

 using (FileStream file = new FileStream(inputExcelPath, FileMode.Open, FileAccess.Read)){

XSSFWorkbook xssfWorkbook = new XSSFWorkbook(file);

}
 

//打开*.xls文件

 using (FileStream file = new FileStream(inputExcelPath, FileMode.Open, FileAccess.Read)){

HSSFWorkbook hssfWorkbook = new HSSFWorkbook(file);

}

 

2.新建工作簿的差异

//在*.xlsx文件新建工作簿

if (xssfWorkbook.NumberOfSheets == 0)
                            {
                                XSSFWorkbook workbook = new XSSFWorkbook();
                                ISheet SHEET = workbook.CreateSheet("sheet1");
                                using (FileStream fileSave = new FileStream(outExcelPath, FileMode.Open, FileAccess.Write)