Apache Poi:从 HSSF 转换为 SS? [英] Apache Poi: Converting from HSSF to SS?
问题描述
我已将 HSSF 中的所有旧代码转换为 SS,除了我制作工作簿的部分.
I've converted all of my old code in HSSF to SS except for the portion where I make the work book.
旧代码:HSSFWorkbook wb = new HSSFWorkbook(new FileInputStream(file));
Old Code: HSSFWorkbook wb = new HSSFWorkbook(new FileInputStream(file));
新的非工作代码:Workbook[] wb2 = new Workbook[] {new FileInputStream};
New Non-working Code: Workbook[] wb2 = new Workbook[] {new FileInputStream};
这是网站提供的转换示例:
This is an example of conversion that the site gave:
新:Workbook[] wbs = new Workbook[] { new HSSFWorkbook(), new XSSFWorkbook() };旧:HSSFWorkbook wb = new HSSFWorkbook();
NEW: Workbook[] wbs = new Workbook[] { new HSSFWorkbook(), new XSSFWorkbook() }; OLD: HSSFWorkbook wb = new HSSFWorkbook();
推荐答案
Workbook 是一个接口,你不能实例化它.相反,您想要的是 WorkbookFactory.传递一个 File 或一个 InputStream,它会给你合适的 Workbook 实例
Workbook is an interface, you can't instantiate it. Instead, what you want is WorkbookFactory. Pass that either a File or an InputStream, and it'll give you the appropriate Workbook instance
您的旧代码:
HSSFWorkbook wb = new HSSFWorkbook(new FileInputStream(file));
变成:
Workbook wb = WorkbookFactory.create(file);
这篇关于Apache Poi:从 HSSF 转换为 SS?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!