PrintingSystemBase.XlSheetCreated Event

Occurs after creation of an XLS or XLSX document worksheet has finished.

Namespace: DevExpress.XtraPrinting

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

Declaration

C#

public event XlSheetCreatedEventHandler XlSheetCreated

VB.NET

Public Event XlSheetCreated As XlSheetCreatedEventHandler

Event Data

The XlSheetCreated event's data class is XlSheetCreatedEventArgs. The following properties provide information specific to this event:

Property	Description
Index	Specifies the Excel sheet index number.
SheetName	Specifies the Excel sheet name.

Remarks

The XlSheetCreated event is not raised when a document is exported to a single file (the XlsExportOptions.ExportMode or XlsxExportOptions.ExportMode option is set to SingleFile).

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the XlSheetCreated event.

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#

Reporting_How-to-store-and-use-custom-document-data-in-the-Web-Document-Viewer/CS/CustomCachedDocumentSourceSerialization/CategoriesReport.cs#L11

InitializeComponent();
this.PrintingSystem.XlSheetCreated += PrintingSystem_XlSheetCreated;
this.PrintingSystem.AddService(typeof(CustomPageDataService), new CustomPageDataService(pageAdditionalData));

VB.NET

Reporting_How-to-store-and-use-custom-document-data-in-the-Web-Document-Viewer/VB/CustomCachedDocumentSourceSerialization/CategoriesReport.vb#L13

InitializeComponent()
AddHandler PrintingSystem.XlSheetCreated, AddressOf PrintingSystem_XlSheetCreated
Me.PrintingSystem.AddService(GetType(CustomPageDataService), New CustomPageDataService(pageAdditionalData))