Support Center

How many rows does the GemBox.Spreadsheet support

GemBox.Spreadsheet's Load and Save method have limitations on the maximum number of rows, columns and sheets based on the file’s format.
For example, the XLS file format specifies worksheet size of 65,536 rows and 256 columns (XLS specifications and limits) and the XLSX file format specifies worksheet size of 1,048,576 rows and 16,384 columns (XLSX specifications and limits). Additionally GemBox.Spreadsheet's model has the same limitations as XLSX file format (the file format closest to GemBox.Spreadsheet Content Model).

The entire excel file is loaded to the rich model (rows, cells, styles and other objects) so an appropriate memory will be required (for more cells you would need more memory). You can confirm the amount of spreadsheet data you handle with the GemBox.Spreadsheet by evaluating its performances on your machine.

The following link contains an example of how you can test GemBox.Spreadsheet’s performances on large spreadsheet files.

GemBox.Spreadsheet Benchmarks Charts

The following are results of GemBox.Spreadsheet’s performances on a large spreadsheet file.
The used test file contained a single sheet with 10 columns and performances were measured on the interval from a single row to 1 million rows.

ELAPSED SECONDS [s]
ROWS COUNT 1 10 100 1,000 10,000 100,000 250,000 500,000 750,000 1,000,000
LOAD 0.001 0.001 0.004 0.035 0.323 3.396 8.528 17.131 25.838 35.150
UPDATE 0.001 0.001 0.001 0.005 0.034 0.343 0.830 1.691 2.544 3.528
SAVE 0.003 0.005 0.006 0.022 0.189 1.975 5.313 11.412 17.633 24.201

Elapsed seconds chart

ALLOCATED MEMORY [MB]
ROWS COUNT 1 10 100 1,000 10,000 100,000 250,000 500,000 750,000 1,000,000
LOAD 0.085 0.092 0.15 0.725 6.542 64.392 160.338 320.588 482.887 641.091
UPDATE 0 0 0 0 0 0 0 0 0 0
SAVE 0 0 0 0 0 0 0 0 0 0

Allocated memory chart

10 of 11 people found this page helpful
Subscribe to this article to get an email notification when it is updated.

0 Comments

  • There are no comments.