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 =新的HSSFWorkbook(新的FileInputStream(文件));

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()}; OLD:HSSFWorkbook wb =新的HSSFWorkbook();

NEW: Workbook[] wbs = new Workbook[] { new HSSFWorkbook(), new XSSFWorkbook() }; OLD: HSSFWorkbook wb = new HSSFWorkbook();

推荐答案

工作簿是一个接口，您无法实例化它.相反，您想要的是 WorkbookFactory .传递文件或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屋！