Hey guys and girls. I recently had a post asking about a way to export data from a java program to an excel spreadsheet, which i successfully learned how to do. Now though i am running into a problem with a java out of memory exception when i go to finally write the excel file to the hard drive.
In the API for JXL which can be found here
keep in mind that you would need to download it to view it.
Anyways in this tutorial
the first question in the FAQ section talks about this problem with running out of memory when trying to generate large spreadsheets, which is the problem im having. I am trying to generate a spreadsheet with dimensions:
the 10000 rows are double values.
I guess what i dont know about is how much memory to allocate to this process?
NOTE that i ran the process and it took two full days just to complete the 10000 iterations to get my data, and i got the exception when it tryed to write the excel file.
the FAQ gives an example, but i dont want to give it too much memory infear of it crashing my system midway through the tests or anything.So does anyone have any idea of how i could come up with th right amount of memory to allocate for this process.
I'll paste the faq since it isnt long:
i hope this is enough information, any tips or help from the experts would be awesome! thanks