Issue with Free Spire.XLS 5.1.0 Library Creating Pivot Table

[poplo46498488]

Description:

When attempting to create a Pivot Table using Free Spire.XLS version 5.1.0 and passing a large number of columns and rows as input data, the resulting file is prone to corruption.

Issue Details:

Symptoms: The generated file becomes corrupted or unusable after attempting to create a Pivot Table with an extensive dataset.

Scenario: When utilizing Free Spire.XLS version 5.1.0 to generate a Pivot Table from a substantial amount of input data, specifically an excessive number of columns and rows, the resultant file encounters corruption issues.

Observations:

The library appears to struggle when handling a large volume of input data for Pivot Table creation.
Upon attempting to create Pivot Tables with a high number of columns and rows, the generated file exhibits inconsistencies or fails to open properly in Excel applications.
Expected Behavior:

The library should be able to handle a larger volume of data when creating Pivot Tables without causing corruption or rendering the resulting file unusable.

Steps to Reproduce:

Utilize Free Spire.XLS 5.1.0 library for creating a Pivot Table.
Pass a considerable number of columns and rows as input data.
Generate the Pivot Table and save the resulting file.

Impact:

This issue significantly impacts users who need to work with extensive datasets and rely on Free Spire.XLS for generating Pivot Tables. The resulting corrupted files hinder productivity and disrupt normal workflow.

Request:

We kindly request the development team to investigate and address this critical issue promptly. Enhancements or fixes to improve the library's ability to handle larger datasets when creating Pivot Tables would be greatly appreciated.

Additional Information:

The system environment includes [Windows 10, java 1.6].
The issue has been consistently reproducible in multiple test scenarios, indicating a fundamental limitation or bug within the library.
Your immediate attention and resolution regarding this matter are highly valued and would significantly benefit our operations.

Thank you .

[Ula.wang]

Hi,

Thank you for your inquiry.
Sorry, our team doesn’t regularly maintain and update in the free version. If you want a better performance experience, you can try using our latest commercial version Spire.Xls for Java 13.12.12, which can handle larger datasets when creating pivot tables. Please use the latest version to test again.
If you have any issue, just feel free to contact us.

Download Link：https://www.e-iceblue.com/Download/xls-for-java.html

Sincerely,
Ula
E-iceblue support team