Export of large amount of data as xlsx

Aspose.Cells Product Family
1

Is it possible to write large amount of data in xlsx file without strong them anywhere.
I’m fetching very large amount of data from database as streaming resultset by following statement:-


Statement stmt = conn.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY,java.sql.ResultSet.CONCUR_READ_ONLY);

I want to write fetched data directly in xlsx file without storing it anywhere.
Let me know how to write this amount of data by using Aspose.CELL ?

2

Hi,


Well, I think you may try to use Cells.importResultSet() method to import ResultSet to your Excel worksheet(s) for your needs, see the document on what importing data options Aspose.Cells provides you for your complete reference:
http://www.aspose.com/docs/display/cellsjava/Importing+Data+to+Worksheets

Thank you.