问题描述
我需要创建一个可以读取XLS和XLSX文件的方法。根据我的研究，HSSF用于读取XLS和XSSF阅读XLSX。有没有在Apache POI的一部分，我可以用它来阅读这两个文件？我也遇到了ss.usermodel却发现没有足够的codeS，将娱乐都XLS和XLSX ....
I need to create a method that can read both xls and xlsx files. According to my research, HSSF is used to read xls and XSSF to read xlsx. Is there a part of the Apache POI I can use to read both files? I also came across the ss.usermodel but found no sufficient codes that will entertain both xls and xlsx....
推荐答案
我没有太多EXP与Apache POI，但据我所知，如果你按类工作簿是指一个工作簿，然后您可以读取和写这两个XLS和放大器; XLSX。
I haven't had much exp with Apache POI, but as far as i know if you refer to a workbook by class "Workbook" then you can read and write both xls & xlsx.
所有你需要做的创建对象的写时
All you have to do is when creating object write
有关的.xls -
for .xls-
Workbook wb = new HSSFWorkbook();
有关的.xlsx -
for .xlsx-
Workbook wb = new XSSFWorkbook();
您可以通过文件类型的参数，并相应地创建工作簿对象使用if语句。
you can pass a parameter for file type and create the WorkBook object accordingly using If statement.
这篇关于有什么办法来读取使用Apache POI都.xls和.XLSX文件？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！