Apache POI-HSSF与POI-XSSF [英] Apache POI-HSSF vs POI-XSSF

问题描述

HSSF是POI项目对Excel '97(-2007)文件格式的纯Java实现. XSSF是POI项目对Excel 2007 OOXML(.xlsx)文件格式的纯Java实现.

HSSF is the POI Project's pure Java implementation of the Excel '97(-2007) file format. XSSF is the POI Project's pure Java implementation of the Excel 2007 OOXML (.xlsx) file format.

使用HSSF时是否有 导出 限制?

Are there any export limitations when using HSSF?

我曾经读过Excel '97仅支持<65.000 Entries的地方.

I've once read somewhere that Excel '97 just supported <65.000 Entries.

使用HSSF导出具有65.000个以上条目的excel工作表是否安全?还是为什么我要使用XSSF?

Is it safe to use HSSF to export excel sheets with more than 65.000 Entries, or why would I use XSSF?

推荐答案

如您所见此处 Excel 97至2003最多支持65,536行.因此，不，使用HSSF，您将不能存储超过65536个条目.但是，您可以使用XLSX(Excel 2007+)来做到这一点，它可以处理多达1,048,576行，并且可以使用 X SSF保存.但是它将与Excel 97/2003不兼容.

As you can see here Excel 97 to 2003 supports a maximum of 65,536 rows. So no, with HSSF you won't be able to store more than 65536 entries. However you can do it with XLSX (Excel 2007+) which can handle up to 1,048,576 rows and can be saved using XSSF. It won't be compatible with Excel 97/2003 though.

这篇关于Apache POI-HSSF与POI-XSSF的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！