XlExportOptionsBase.SheetName Property

Gets or sets a name of the sheet in the created XLS file to which a document is exported.

Namespace: DevExpress.XtraPrinting

Assembly: DevExpress.Printing.v20.2.Core.dll

NuGet Packages: DevExpress.Printing.Core, DevExpress.WindowsDesktop.Printing.Core

Declaration

C#

[DefaultValue("Sheet")]
public string SheetName { get; set; }

VB.NET

<DefaultValue("Sheet")>
Public Property SheetName As String

Property Value

Type	Default	Description
String	"Sheet"	A String representing the sheet name set in the resulting XLS file.

Property Paths

You can access this nested property as listed below:

Library	Object Type	Path to SheetName
Cross-Platform Class Library	ExportOptions	.Xls .SheetName
WPF Controls	ExportOptionsContainer	.Xls .SheetName

Remarks

By default, the SheetName property returns an empty string, which means that the sheet name is equal to the Document.Name property value.

Related GitHub Examples

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

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#

XAF_how-to-customize-export-options-of-the-printing-system-in-winforms-e2108/CS/WinSolution.Module.Win/ConfigurePrintingSystemViewController.cs#L41

// XLS-specific options:
xlsExportOptions.SheetName = "CustomXlsSheetTitle";
xlsExportOptions.ShowGridLines = true;

how-to-customize-the-gridcontrols-data-aware-export-output-t247610/CS/GridDataAwareExportCustomization/Form1.cs#L44

// Specify a name of the sheet in the created XLSX file.
options.SheetName = "DevAV price";

XAF_how-to-customize-the-export-action-behavior-e2335/CS/CustomizeExportAction.Module/Controllers/CustomizeExportController.cs#L37

}
options.SheetName = View.Caption;
options.ShowGridLines = true;

Reporting_how-to-export-a-report-to-xlsx-format-e1539/CS/ExportToXLSX/Form1.cs#L27

xlsxOptions.ExportHyperlinks = true;
xlsxOptions.SheetName = "My Sheet";

VB.NET

XAF_how-to-customize-export-options-of-the-printing-system-in-winforms-e2108/VB/WinSolution.Module.Win/ConfigurePrintingSystemViewController.vb#L42

' XLS-specific options:
xlsExportOptions.SheetName = "CustomXlsSheetTitle"
xlsExportOptions.ShowGridLines = True

how-to-customize-the-gridcontrols-data-aware-export-output-t247610/VB/GridDataAwareExportCustomization/Form1.vb#L47

' Specify a name of the sheet in the created XLSX file.
options.SheetName = "DevAV price"

XAF_how-to-customize-the-export-action-behavior-e2335/VB/CustomizeExportAction.Module/Controllers/CustomizeExportController.vb#L39

End If
options.SheetName = View.Caption
options.ShowGridLines = True

Reporting_how-to-export-a-report-to-xlsx-format-e1539/VB/ExportToXLSX/Form1.vb#L29

xlsxOptions.ExportHyperlinks = True
xlsxOptions.SheetName = "My Sheet"