Performance Metrics in Excel (XlsIO) Library

17 Dec 20251 minute to read

This section evaluates the performance of the Syncfusion Excel (XlsIO) library when handling text, date and time, number, boolean, and formula data types during operations such as reading and creating Excel documents.

Create and Save

The table below illustrates the performance of creating and saving an Excel document containing 100,000 rows and 50 columns for different data types.

Data type	Time Taken (sec)	Sample Link
Text	13	GitHub page
DateTime	15	GitHub page
Number	5	GitHub page
Boolean	5	GitHub page
Formula	35	GitHub page

Load and Read

The table below illustrates the performance of loading and reading cell values from an Excel document with 100,000 rows and 50 columns for different data types.

Data type	Time Taken (sec)	Sample Link
Text	9	GitHub page
DateTime	5	GitHub page
Number	6	GitHub page
Boolean	4	GitHub page
Formula	9	GitHub page