Export data to Excel | .NET MAUI Excel Library

Overview

Syncfusion .NET MAUI Excel Library (XlsIO) provides support to export data to Excel from various data sources such as data tables, arrays, collections, databases, CSV, and TSV, through code.

Export from data tables to Excel

Data from ADO.NET objects such as data tables, data columns, and data views are exported to Excel worksheets. This option enables you to export:

To a specific cell or named range.
Data with or without headers.
Data based on value type of first row of a column or value type in each cell of a data column.
Data as hyperlinks.
Large amounts of data in seconds.

Data table to Excel.

Export from array to Excel

Export one-dimensional or two-dimensional arrays to an Excel worksheet. This also enables you to export:

To a specific cell.
As a one-dimensional array, either vertically or horizontally.
Data as hyperlinks.

Array to Excel

Export from collection to Excel

Export a collection with desired data to an Excel worksheet, which enables you to export:

From N number of collections.
From nested collections.
Data with or without headers.
Images.
Data as hyperlinks.

Collection to Excel.

Export from database to Excel

Syncfusion Excel Library enables you to export data from databases like SQL and Access. This helps you export data into Excel tables. Data that is updated in the database will reflect in the Excel table.

Export data to Excel

Export from CSV or TSV to Excel

Comma-separated value (CSV) files and tab-separated value (TSV) files are helpful in generating lightweight reports with few columns and a high number of rows, quickly. Excel Library supports opening and saving CSV and TSV files with a few lines of code.

CSV or TSV to Excel.