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.

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

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

11 of 12 people found this page helpful

Subscribe to this article to get an email notification when it is updated.