Hi M. Irfan,
I think Aspose.Cells for Java can serve your need.
Is License required for deploying Aspose.cells in production environment?
Kindly post your query @ Aspose.Purchase: http://www.aspose.com/community/forums/aspose.purchase/220/showforum.aspx<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
If there are any production issues with Aspose.cells, then what will be turnaround time for the support?
Support call tree & escalation tree details.
Our technical support is really fast and we always try to fix user issues (if we find) asap.You may utilize forums and absolute live support options.
Basic queries:--------------Can Aspose.cells Generate excels in Linux environment?
Yes, it works fine on Linux.
COM-DCOM bridge will be called during excel generation?
Does Microsoft office needs to be installed in a machine where Aspose.cells is deployed to generate the excels?
No, there is no need MS Excel to be installed either on the client or server side on a network.
Sample code for generation of excel using Aspose.cells including some basic formatting options(Setting Number format, text format, date format, zoom etc)
Sample code for reading data from an excel using Aspose.cells and importing the data into Java objects.
You can export excel data to fill some collection or object array. Please check:
Can Aspose.cells read data from >30MB excel data without any memories issues.
Can Aspose.cells generate excel with >30MB size without any memories issues.
Yes, Normally memory issues are concerned with JVM, so, you may try to extend the JVM memory to run your program. e.g.., java -Xmx512m -classpath... YourMainApp
What is the Min and Max memory needed to generate an excel (If the data is huge)?
What will be the memory consumed to generate an excel (If the data is huge)?
Well, Aspose.Cells for Java takes less memory to create / manipulate excel files.