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

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

Purpose: Raised when a field label is requested
Notes:

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



Top Method Summary
Options Name Purpose
+ CloseSpreadsheetDocument (SpreadsheetDocument) Closes the SpreadsheetDocument by calling the Dispose method.
Inherited from Consultingwerk.Utilities.Excel.ExcelUtility
+ ExportExcel (ExportWorksheetArguments, handle) Exports from a Temp-Table into an Excel Worksheet
# ExportRows (WorksheetPart, ExportWorksheetArguments, handle, integer) ExportRows into an Excel Worksheet
+ CHARACTER GetCellValue (WorkbookPart, Cell) Gets and returns the Value of a Cell
Inherited from Consultingwerk.Utilities.Excel.ExcelUtility
+ DocumentFormat.OpenXml.Spreadsheet.Cell GetRowCell (Row, character) Gets the Cell Object from a Row
Inherited from Consultingwerk.Utilities.Excel.ExcelUtility
+ DocumentFormat.OpenXml.Packaging.WorkbookPart GetWorkbookPart (SpreadsheetDocument) Gets and returns the WorkbookPart of the specified SpreadsheetDocument
Inherited from Consultingwerk.Utilities.Excel.ExcelUtility
+ DocumentFormat.OpenXml.Packaging.WorksheetPart GetWorksheetPart (WorkbookPart) Gets and returns the WorksheetPart of the specified WorkbookPart
Inherited from Consultingwerk.Utilities.Excel.ExcelUtility
+ DocumentFormat.OpenXml.Spreadsheet.SheetData GetWorksheetSheetData (WorkbookPart) Gets and returns the WorksheetSheetData of the specified WorkbookPart
Inherited from Consultingwerk.Utilities.Excel.ExcelUtility
+ InsertCellValue (WorksheetPart, character, integer, character) Inserts a Cell Value into the indexed Row and Column of an Excel Worksheet
Inherited from Consultingwerk.Utilities.Excel.ExcelUtility
# OnCompleted (EventArgs) Raises the Completed event
# OnProgressChanged (EventArgs) Raises the ProgressChanged event
# OnRequestFieldLabel (RequestFieldLabelEventArgs) Raises the RequestFieldLabel
+ DocumentFormat.OpenXml.Packaging.SpreadsheetDocument OpenSpreadsheetDocument (character, logical) Opens the SpreadsheetDocument
Inherited from Consultingwerk.Utilities.Excel.ExcelUtility
+ SaveSpreadsheetDocument (SpreadsheetDocument) Saves and closes the SpreadsheetDocument
Inherited from Consultingwerk.Utilities.Excel.ExcelUtility
+ SaveWorkbook (WorkbookPart) Saves the Workbook element of the specified WorkbookPart
Inherited from Consultingwerk.Utilities.Excel.ExcelUtility
+ SetExcelCellValues (WorksheetPart, integer, Object[]) Sets the Excel Cell Values based on the provided values Object[]
Inherited from Consultingwerk.Utilities.Excel.ExcelUtility

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

PUBLIC CloseSpreadsheetDocument (SpreadsheetDocument)
Inherited from Consultingwerk.Utilities.Excel.ExcelUtility
/*
Purpose: Closes the SpreadsheetDocument by calling the Dispose method.
Notes: The Dispose is important to release the memory and close the file.
(otherwise the file will be locked and cannot be opened)

Parameters:
poSpreadsheetDocument DocumentFormat.OpenXml.Packaging.SpreadsheetDocument
Top

PUBLIC 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

PROTECTED ExportRows (WorksheetPart, ExportWorksheetArguments, handle, integer)
Purpose: ExportRows into an Excel Worksheet
Notes:

Parameters:
poWorksheetPart DocumentFormat.OpenXml.Packaging.WorksheetPart
WorksheetPart
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

PUBLIC CHARACTER GetCellValue (WorkbookPart, Cell)
Inherited from Consultingwerk.Utilities.Excel.ExcelUtility
/*
Purpose: Gets and returns the Value of a Cell
Notes:

Parameters:
poWorkbookPart DocumentFormat.OpenXml.Packaging.WorkbookPart
poCell DocumentFormat.OpenXml.Spreadsheet.Cell
Returns CHARACTER
Cell Value
Top

PUBLIC DocumentFormat.OpenXml.Spreadsheet.Cell GetRowCell (Row, character)
Inherited from Consultingwerk.Utilities.Excel.ExcelUtility
/*
Purpose: Gets the Cell Object from a Row
Notes:

Parameters:
poRow DocumentFormat.OpenXml.Spreadsheet.Row
pcCellReference CHARACTER
Returns DocumentFormat.OpenXml.Spreadsheet.Cell
Cell Object
Top

PUBLIC DocumentFormat.OpenXml.Packaging.WorkbookPart GetWorkbookPart (SpreadsheetDocument)
Inherited from Consultingwerk.Utilities.Excel.ExcelUtility
/*
Purpose: Gets and returns the WorkbookPart of the specified SpreadsheetDocument
Notes:

Parameters:
oSpreadsheetDocument DocumentFormat.OpenXml.Packaging.SpreadsheetDocument
Returns DocumentFormat.OpenXml.Packaging.WorkbookPart
WorkbookPart Object
Top

PUBLIC DocumentFormat.OpenXml.Packaging.WorksheetPart GetWorksheetPart (WorkbookPart)
Inherited from Consultingwerk.Utilities.Excel.ExcelUtility
/*
Purpose: Gets and returns the WorksheetPart of the specified WorkbookPart
Notes:

Parameters:
poWorkbookPart DocumentFormat.OpenXml.Packaging.WorkbookPart
Returns DocumentFormat.OpenXml.Packaging.WorksheetPart
WorksheetPart Object
Top

PUBLIC DocumentFormat.OpenXml.Spreadsheet.SheetData GetWorksheetSheetData (WorkbookPart)
Inherited from Consultingwerk.Utilities.Excel.ExcelUtility
/*
Purpose: Gets and returns the WorksheetSheetData of the specified WorkbookPart
Notes:

Parameters:
poWorkbookPart DocumentFormat.OpenXml.Packaging.WorkbookPart
Returns DocumentFormat.OpenXml.Spreadsheet.SheetData
SheetData Object
Top

PUBLIC InsertCellValue (WorksheetPart, character, integer, character)
Inherited from Consultingwerk.Utilities.Excel.ExcelUtility
Purpose: Inserts a Cell Value into the indexed Row and Column of an Excel Worksheet
Notes:

Parameters:
poWorksheetPart DocumentFormat.OpenXml.Packaging.WorksheetPart
WorksheetPart
pcContent CHARACTER
Character The content to insert
piRowIndex INTEGER
Integer The row to insert into
pcCol CHARACTER
Character The column to insert into
Top

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

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

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

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

PROTECTED OnRequestFieldLabel (RequestFieldLabelEventArgs)
Purpose: Raises the RequestFieldLabel
Notes:

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

PUBLIC DocumentFormat.OpenXml.Packaging.SpreadsheetDocument OpenSpreadsheetDocument (character, logical)
Inherited from Consultingwerk.Utilities.Excel.ExcelUtility
/*
Purpose: Opens the SpreadsheetDocument
Notes: The second attribute is optional and defaults to false. If set to true the document will be opened in update mode.

Parameters:
pcFileName CHARACTER
plEditable LOGICAL
Returns DocumentFormat.OpenXml.Packaging.SpreadsheetDocument
SpreadsheetDocument Object
Top

PUBLIC SaveSpreadsheetDocument (SpreadsheetDocument)
Inherited from Consultingwerk.Utilities.Excel.ExcelUtility
/*
Purpose: Saves and closes the SpreadsheetDocument
Notes:

Parameters:
poSpreadsheetDocument DocumentFormat.OpenXml.Packaging.SpreadsheetDocument
Top

PUBLIC SaveWorkbook (WorkbookPart)
Inherited from Consultingwerk.Utilities.Excel.ExcelUtility
/*
Purpose: Saves the Workbook element of the specified WorkbookPart
Notes:

Parameters:
poWorkbookPart DocumentFormat.OpenXml.Packaging.WorkbookPart
Top

PUBLIC SetExcelCellValues (WorksheetPart, integer, Object[])
Inherited from Consultingwerk.Utilities.Excel.ExcelUtility
Purpose: Sets the Excel Cell Values based on the provided values Object[]
Notes:

Parameters:
poWorksheetPart DocumentFormat.OpenXml.Packaging.WorksheetPart
WorksheetPart
piCount INTEGER
Integer The row to insert into
poValues System.Object[]
Object[] The values to insert


Event Detail
Top

PUBLIC 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

PUBLIC 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

PUBLIC 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

PUBLIC INTEGER RowsExported

Returns INTEGER


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