Apache Poi:从 HSSF 转换为 SS? [英] Apache Poi: Converting from HSSF to SS?

查看:54
本文介绍了Apache Poi:从 HSSF 转换为 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屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆