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 行，并且可以使用 XSSF 进行保存.但它与 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屋！