Namespace: Consultingwerk.Utilities.Excel
Class 
ExcelWorksheetExporter Copy to Clipboard
Parent classes:
Progress.Lang.Object
Consultingwerk.Utilities.Excel.ExcelStyleSheetUtility
Consultingwerk.Utilities.Excel.ExcelUtility
Consultingwerk.Utilities.Excel.ExcelWorksheetExporter

Inherits: Consultingwerk.Utilities.Excel.ExcelUtility
Implements: Consultingwerk.Utilities.Excel.IExcelWorksheetExporter


Navigate to: Methods | Constructors | Events | Properties | ProDatasets | Temp-Tables



Top Method Summary
Options Name Purpose
ExportExcel (ExportWorksheetArguments, handle) Exports from a Temp-Table into an Excel Worksheet
ExportRows (WorkbookPart, SheetData, ExportWorksheetArguments, handle, integer) ExportRows into an Excel Worksheet
OnCompleted (EventArgs) Raises the Completed event
OnProgressChanged (EventArgs) Raises the ProgressChanged event
OnRequestFieldLabel (RequestFieldLabelEventArgs) Raises the RequestFieldLabel

Top Event Summary
Options Name Purpose
Completed (Object, EventArgs) Raised when the Export has finished
ProgressChanged (Object, EventArgs) Raised when the Export has processed the RowsPerProgressEvent number of rows
RequestFieldLabel (Object, RequestFieldLabelEventArgs) Raised when a field label is requested

Top Property Summary
Options Name Purpose
INTEGER RowsExported


Method Detail
Top

ExportExcel (ExportWorksheetArguments, handle)
Purpose: Exports from a Temp-Table into an Excel Worksheet
Notes:

Parameters:
poExportWorksheetArguments Consultingwerk.Utilities.Excel.ExportWorksheetArguments
A reference to an ExportWorksheetArguments instance with the parameters for this method
phTempTable HANDLE
TABLE-HANDLE The temp-table to export too
Top

ExportRows (WorkbookPart, SheetData, ExportWorksheetArguments, handle, integer)
Purpose: ExportRows into an Excel Worksheet
Notes:

Parameters:
poWorkbookPart DocumentFormat.OpenXml.Packaging.WorkbookPart
WorkbookPart
poSheetData DocumentFormat.OpenXml.Spreadsheet.SheetData
SheetData
poExportWorksheetArguments Consultingwerk.Utilities.Excel.ExportWorksheetArguments
ExportWorksheetArguments
phTempTable HANDLE
TABLE-HANDLE The temp-table to export too
piStartRow INTEGER
Integer The row to start exporting from
Top

OnCompleted (EventArgs)
Purpose: Raises the Completed event
Notes:

Parameters:
e Consultingwerk.EventArgs
The Consultingwerk.EventArgs instance for the event
Top

OnProgressChanged (EventArgs)
Purpose: Raises the ProgressChanged event
Notes:

Parameters:
e Consultingwerk.EventArgs
The Consultingwerk.EventArgs instance for the event
Top

OnRequestFieldLabel (RequestFieldLabelEventArgs)
Purpose: Raises the RequestFieldLabel
Notes:

Parameters:
e Consultingwerk.Utilities.Excel.RequestFieldLabelEventArgs
The RequestFieldLabelEventArgs with the data for the event


Event Detail
Top

Completed (Object, EventArgs)
Purpose: Raised when the Export has finished
Notes:

Parameters:
sender Progress.Lang.Object
The instance the raised the event
e Consultingwerk.EventArgs
The Consultingwerk.EventArgs instance for this event
Top

ProgressChanged (Object, EventArgs)
Purpose: Raised when the Export has processed the RowsPerProgressEvent number
of rows
Notes:

Parameters:
sender Progress.Lang.Object
The instance the raised the event
e Consultingwerk.EventArgs
The Consultingwerk.EventArgs instance for this event
Top

RequestFieldLabel (Object, RequestFieldLabelEventArgs)
Purpose: Raised when a field label is requested
Notes:

Parameters:
sender Progress.Lang.Object
The object that raised the RequestFieldLabel event
e Consultingwerk.Utilities.Excel.RequestFieldLabelEventArgs
The RequestFieldLabelEventArgs with the data for the event


Property Detail
Top

INTEGER RowsExported

Returns INTEGER


©2006-2026 Consultingwerk Ltd.         info@consultingwerk.de         http://www.consultingwerk.de       13.04.2026 10:30:51