Question

我需要帮助使用XSSF阅读Xls文档。

“XSSF”的实施正在对“xlsx”进行罚款。不为“xls”档案工作。

该守则是:

    XSSFWorkbook workBook = new XSSFWorkbook("fileName");
    XSSFSheet sheet = workBook.getSheetAt(0);
    XSSFRow row = sheet.getRow(0);

赞赏任何工作。

Answer 1

Rather than using XSSF classes directly, you should use the interfaces that are common between both HSSF (.xls) and XSSF (.xlsx). The snippet of code from your question would then become:

 Workbook wb = WorkbookFactory.create(file); // Or InputStream
 Sheet sheet = workBook.getSheetAt(0);
 Row row = sheet.getRow(0);
 Cell cell = row.getCell(0);
 System.out.println("Cell A1 is of type " + cell.getCellType());

见http://poi.apache.org/spreadsheet/how-to.html#user_api。更多信息和实例

Answer 2

......

FileInputStream is = new FileInputStream(filePath))
XSSFWorkbook workbook = new XSSFWorkbook(is);
is.close();

下面的这种联系似乎解决这一问题。

友情链接