public class fileReader { public static void main (String[] args) throws IOException { String excelFilePath = "sample.xlsx"; InputStream inputStream = new FileInputStream(new File(excelFilePath)); XSSFWorkbook workbook = new XSSFWorkbook(); Sheet firstSheet = workbook.getSheetAt(0); Iterator<Row> iterator = firstSheet.iterator(); while (iterator.hasNext()) { Row nextRow = iterator.next(); Iterator<Cell> cellIterator = nextRow.cellIterator(); ...在 XSSFWorkbook 行中顯示了錯誤Exception in thread "main" org.apache.poi.ooxml.POIXMLException: org.apache.xmlbeans.XmlOptions.setEntityExpansionLimit(I)Lorg/apache/xmlbeans/XmlOptions; at org.apache.poi.ooxml.POIXMLFactory.createDocumentPart(POIXMLFactory.java:66) at org.apache.poi.ooxml.POIXMLDocumentPart.read(POIXMLDocumentPart.java:657) at org.apache.poi.ooxml.POIXMLDocument.load(POIXMLDocument.java:180) at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:282) at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:303) at fileReader.main(fileReader.java:20)
1 回答
墨色風(fēng)雨
TA貢獻(xiàn)1853條經(jīng)驗 獲得超6個贊
你沒有閱讀你的文件。您正在創(chuàng)建一個新工作簿。所以我懷疑你有一個例外，因為你要求一個Sheet沒有的地方。
將您的文件提供給實例使用XSSFWorkbook(File)
String excelFilePath = "sample.xlsx";
File f = new File(excelFilePath);
XSSFWorkbook workbook = new XSSFWorkbook(f);
或者XSSFWorkbook(InputStream)
String excelFilePath = "sample.xlsx";
File f = new File(excelFilePath);
InputStream inputStream = new FileInputStream(f);
XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
如果將 File 提供給工作簿實例，則會出現(xiàn)錯誤，顯示 File cannot be resolved to a type
只需要導(dǎo)入java.io.File
添加回答
舉報
0/150
提交
取消