Performance Metrics in Excel (XlsIO) Library

This section evaluates the performance of the Syncfusion XlsIO library when handling String, DateTime, Number, Boolean, and Formula data types during operations such as opening, reading, creating, and saving Excel files. It provides insights into the efficiency and capabilities of XlsIO for processing these data types across various platforms.

Open and Read

The table below illustrates the performance of data types for open operations.

Data types Test case Matrix (Open) XlsIO (ms) Sample
String 150 rows * 10000 columns 2213 GitHub page
DateTime 150 rows * 10000 columns 1369 GitHub page
Number 150 rows * 10000 columns 1151 GitHub page
Boolean 150 rows * 10000 columns 1173 GitHub page
Formula 150 rows * 10000 columns 1545 GitHub page

You can find the sample used for open operation performance evaluation on this GitHub page.

The table below illustrates the performance of data types for read operations.

Data types Test case Matrix (Read) XlsIO (ms) Sample
String 150 rows * 10000 columns 139 GitHub page
DateTime 150 rows * 10000 columns 506 GitHub page
Number 150 rows * 10000 columns 294 GitHub page
Boolean 150 rows * 10000 columns 99 GitHub page
Formula 150 rows * 10000 columns 165 GitHub page

You can find the sample used for read operation performance evaluation on this GitHub page.

Create and Save

The table below illustrates the performance of data types for create operations.

Data types Test case Matrix (Create) XlsIO (ms) Sample
String 150 rows * 10000 columns 1177 GitHub page
DateTime 150 rows * 10000 columns 2301 GitHub page
Number 150 rows * 10000 columns 436 GitHub page
Boolean 150 rows * 10000 columns 422 GitHub page
Formula 150 rows * 10000 columns 4089 GitHub page

You can find the sample used for create operation performance evaluation on this GitHub page.

The table below illustrates the performance of data types for save operations.

Data types Test case Matrix (Save) XlsIO (ms) Sample
String 150 rows * 10000 columns 1422 GitHub page
DateTime 150 rows * 10000 columns 1270 GitHub page
Number 150 rows * 10000 columns 916 GitHub page
Boolean 150 rows * 10000 columns 781 GitHub page
Formula 150 rows * 10000 columns 1222 GitHub page

You can find the sample used for save operation performance evaluation on this GitHub page.