WorksheetExtensions Class

Defines extension methods for the Worksheet interface.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use these methods in production code.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Docs.v23.2.dll

NuGet Package: DevExpress.Document.Processor

Declaration

C#

public static class WorksheetExtensions

VB.NET

Public Module WorksheetExtensions

Remarks

To enable worksheet extensions, add a reference to the DevExpress.Docs.v23.2.dll assembly and explicitly import the DevExpress.Spreadsheet namespace into the code with the using directive (Imports in Visual Basic).

You can call extension methods in the same way as instance methods of the Worksheet object.

The example below shows how to use the Import extension method to insert data from a list into a worksheet.

ImportActions.cs

using DevExpress.Spreadsheet;
using System.Collections.Generic;
//...

Worksheet worksheet = workbook.Worksheets[0];

// Create a list that contains string values.
List<string> cities = new List<string>();
cities.Add("New York");
cities.Add("Rome");
cities.Add("Beijing");
cities.Add("Delhi");

// Insert list values into the worksheet vertically.
// Data starts with the B1 cell.
worksheet.Import(cities, 0, 1, true);

ImportActions.vb

Imports DevExpress.Spreadsheet
Imports System.Collections.Generic
'...

Dim worksheet As Worksheet = workbook.Worksheets(0)

' Create a list that contains string values.
Dim cities As New List(Of String)()
cities.Add("New York")
cities.Add("Rome")
cities.Add("Beijing")
cities.Add("Delhi")

' Insert list values into the worksheet vertically.
' Data starts with the B1 cell.
worksheet.Import(cities, 0, 1, True)

Refer to the Import and Export Data section for more examples on how to use the WorksheetExtensions methods to import data into a worksheet or export data from a worksheet to a data table.

Inheritance

Object

WorksheetExtensions