CsvDocumentImporterOptions.Worksheet Property

Gets or sets a destination worksheet into which data is imported.

Namespace: DevExpress.XtraSpreadsheet.Import

Assembly: DevExpress.Spreadsheet.v23.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

[DefaultValue("")]
public override string Worksheet { get; set; }

VB.NET

<DefaultValue("")>
Public Overrides Property Worksheet As String

Property Value

Type	Default	Description
String	String.Empty	The worksheet name.

Property Paths

You can access this nested property as listed below:

Object Type	Path to Worksheet
WorkbookImportOptions	.Csv .Worksheet

Remarks

The code snippet below creates a new worksheet and imports data from a CSV file into this worksheet.

C#

using DevExpress.Spreadsheet;
// ...

// Create a new worksheet.
workbook.Worksheets.Add("Data");
// Import data from a CSV file into this worksheet.
workbook.Options.Import.Csv.Worksheet = "Data";
workbook.LoadDocument(@"Documents\Book1.csv");

VB.NET

Imports DevExpress.Spreadsheet
' ...

' Create a new worksheet.
workbook.Worksheets.Add("Data")
' Import data from a CSV file into this worksheet.
workbook.Options.Import.Csv.Worksheet = "Data"
workbook.LoadDocument("Documents\Book1.csv")