Project Brief Intro requires answer to queries for Unix environment

Aspose.Cells Product Family
1

Project Brief Intro

Presently my customer is working on a project which is deployed on Windows environment. The application server which we used is BEA Weblogic and the database is oracle. The reports which were generated out of our application are of Pdf and Xls format. We use Oracle reports for generating the Pdf’s and Windows J-Integra for generating the Xls. We are planning to move our application to Unix environment. Hence, we want to explore the option of using Aspose.cells to generate excel reports and import data from excels.

Below are our queries:

Queries on Licensing Information:-

Is License required for deploying Aspose.cells in production environment?

If there are any production issues with Aspose.cells, then what will be turnaround time for the support?

Support call tree & escalation tree details.

Basic queries:--------------Can Aspose.Cells Generate excels in Linux environment?

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?

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.

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.

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)?

thx.

M.irfan.

2

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: Aspose.Purchase - Free Support Forum - aspose.com

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?

No.

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)

Please check:

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.

Yes.

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.

Thank you.

3

When the customer us trying to export data with more than 3lac records in different sheets in an excel by using Aspose, they are encountering Out Of Memory exception. Is there any way to get what is the ideal memory parameters to generate excels with any number of records?

Right now they are generating excels by calling Aspose code from Sun JVM with memory parameters as ( Minimum – 128, Maximum – 256). If they call the X code to generate excels from Sun JVM with the same memory parameters, then the excels are getting generated without any issues.

Looking forward for your help on this. thx…

Irfan.

4

Hi,

I am not familiar with the X code, but I think there must be some difference between different implementations for this task. Such as, maybe the supported features of Excel by them are different, and they are using different data structure and logic, initializing different objects for doing with a Workbook.

For Aspose, if you encounter the OutOfMemoryException, I think you have to specify more memory for JVM. The memory needed when process a Workbook depends on not only the count of records(cells), but also the data type, styles applyed on them, ..., and so on. Commonly the more records you set to the Workbook, the more memory will be needed.