java - WorkbookFactory.create(inputStream)

Question

这是我在 xlsx 中读取文件的一段代码和 xls格式

File customerTemplateFileObj = new File(customerTemplateFullPath);
InputStream inputStream = new FileInputStream(customerTemplateFileObj);

Workbook myWorkBook = null;
try {

    ***myWorkBook = WorkbookFactory.create(inputStream);***
} 
catch (Exception e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
}

int totalSheets = myWorkBook.getNumberOfSheets();

我的代码在 xls 上运行良好格式，但对于 xlsx它停在

myWorkBook = WorkbookFactory.create(inputStream);

没有任何异常(exception)。

Answer 1

用于在 java 中读取 xlsx 文件扩展，使用 poi jar 中的 XSSFWorkbook 类

package com.ssaurel.samples.excel;

import java.io.File; 

import java.io.FileInputStream;

import java.io.IOException;

import java.util.Iterator;


import org.apache.poi.ss.usermodel.Cell;

import org.apache.poi.ss.usermodel.Row;

import org.apache.poi.xssf.usermodel.XSSFSheet;

import org.apache.poi.xssf.usermodel.XSSFWorkbook;


public class ReadExcel {

  public static void main(String[] args) throws IOException {
    File excelFile = new File("contacts.xlsx");
    FileInputStream fis = new FileInputStream(excelFile);

    // we create an XSSF Workbook object for our XLSX Excel File
    XSSFWorkbook workbook = new XSSFWorkbook(fis);

    // ...

  }

}