内存高效的Java库来读取Excel文件？ [英] Memory-efficient Java library to read Excel files?

问题描述

有没有一个内存高效的Java库可以读取大型Microsoft Excel文件（.xls和.xlsx）？我对Apache POI的经验非常有限，似乎是从我记得的巨大的记忆力（尽管也许这仅仅是写作而不是阅读）。有更好的东西吗？还是我错误地滥用和/或滥用POI？

同样重要的是要有一个友好的开源许可证。

解决方案

Apache的POI库有一个具有较小内存占用空间的基于事件的API 。不幸的是，它只适用于HSSF（可怕的电子表格格式），而不适用于XSSF（XML电子表格格式 - 用于OOXML文件）。

Is there a memory-efficient Java library to read large Microsoft Excel files (both .xls and .xlsx)? I have very limited experience with Apache POI, and it seemed to be a huge memory hog from what I recall (though perhaps this was just for writing and not for reading). Is there something better? Or am I misremembering and/or misusing POI?

It would be important for it to have a "friendly" open-source license as well.

解决方案

Apache's POI library has an event-based API that has a smaller memory-footprint. Unfortunately, it only works with HSSF (Horrible Spreadsheet Format) and not XSSF (XML Spreadsheet Format - for OOXML files).

这篇关于内存高效的Java库来读取Excel文件？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！