Record large Excel spreadsheets

Question

Has anyone found a library that works well with large spreadsheets?

I tried apache POI, but it failed while working with large files - both read and write. It uses huge amounts of memory, and you need the supercomputer to understand or create a 20 + mb spreadsheet.

Of course, there is a more efficient way of memory, and someone wrote it ?!

Answer 1

at the time of publication, there is no pure, scalable Java solution for reading and writing large excel files.

Answer 2

@pstanton .. I worked on a similar solution and was able to write large Excel Excel files with hundreds of rows exported from the database. Here is a link to it: http://vikramvkamath.blogspot.com/2010/07/writing-large-excel-files-excel-2007.html

My solution is to extend the class of Yegor Koslov SheetWriter, follow this http link and it works great for me. Let me know if you have any problems.

~ Vikram

Answer 3

I can not recommend you a library. But when you need better performance, you might want to try contacting the people who came with Excel first. I assume that the APIs available from .NET process Excel files much more efficiently. Thus, the idea is to implement a web service or similar component in .NET, which does most of the work related to Excel and is simply called from Java.

Answer 4

This is basically the same idea as Jannik , but you use Java COM Bridge to access Excel APIs directly from Java. We have had good success doing this with the Word. The obvious drawback is that it only works on Windows.

Answer 5

Have you tried JExcelAPI as an alternative to POI? I admit, I can not comment on its memory efficiency.

Answer 6

Maybe the CSV format can help you. You just need to separate each value with a comma and save the file with the extension .csv.