ExcelDataSource.FillAsync() Method

Populates the ExcelDataSource in an asynchronous manner.

Namespace: DevExpress.DataAccess.Excel

Assembly: DevExpress.DataAccess.v23.2.dll

NuGet Packages: DevExpress.DataAccess, DevExpress.Win.PivotGrid, DevExpress.Win.TreeMap

Declaration

C#

public Task FillAsync()

VB.NET

Public Function FillAsync As Task

Returns

Type	Description
Task	A task that populates the data source.

Remarks

Use this method to populate an Excel data source in an individual task asynchronously. Unlike the Fill() method call, FillAsync does not lock other actions performed concurrently. For instance, the user interface remains operational while the data source is populated.

Call the FillAsync method with the await operator.

Example

The code sample below creates an ExcelDataSource and populates it in an asynchronous manner.

C#

using DevExpress.DataAccess.Excel;
using DevExpress.XtraReports.UI;
using System.Threading;
XtraReport report = new XtraReport();
// Creates and configures the Excel data source.
ExcelDataSource excelDataSource = new ExcelDataSource();
excelDataSource.Name = "Excel Data Source";
excelDataSource.FileName = "Sales.xlsx";
ExcelWorksheetSettings worksheetSettings = new ExcelWorksheetSettings("SalesPerson", "A1:L2000");
excelDataSource.SourceOptions = new ExcelSourceOptions(worksheetSettings);
// Populates the data source.
await excelDataSource.FillAsync();
report.DataSource = excelDataSource;

VB.NET

Dim report As New XtraReport()
' Creates and configures the Excel data source.
Dim excelDataSource As New ExcelDataSource()
excelDataSource.Name = "Excel Data Source"
excelDataSource.FileName = "Sales.xlsx"
Dim worksheetSettings As New ExcelWorksheetSettings("SalesPerson", "A1:L2000")
excelDataSource.SourceOptions = New ExcelSourceOptions(worksheetSettings)
' Populates the data source.
Await excelDataSource.FillAsync()
report.DataSource = excelDataSource

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the FillAsync() method.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

winforms-pivot-grid-custom-group-intervals/CS/CustomGroupIntervals/Form1.cs#L10

// Fill the ExcelDataSource asynchronously
excelDataSource1.FillAsync();
// This line of code is generated by Data Source Configuration Wizard

winforms-print-pivot-and-chart-controls/CS/WinformsExport/Form1.cs#L27

    // Fill the ExcelDataSource asynchronously
    excelDataSource1.FillAsync();
}

VB.NET

winforms-pivot-grid-custom-group-intervals/VB/CustomGroupIntervals/Form1.vb#L13

' Fill the ExcelDataSource asynchronously
excelDataSource1.FillAsync()
' This line of code is generated by Data Source Configuration Wizard

winforms-print-pivot-and-chart-controls/VB/WinformsExport/Form1.vb#L26

    ' Fill the ExcelDataSource asynchronously
    excelDataSource1.FillAsync()
End Sub