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

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


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



Top Method Summary
Options Name Purpose
ExtractRowValues (WorkbookPart, Row, Object[]) Extracts the values from the parameter poValues and populates the Individual Cell Values for the specified Row
Import (ImportWorksheetArguments, table-handle) Imports from an Excel Worksheet into a Temp-Table
ImportRows (WorkbookPart, SheetData, ImportWorksheetArguments, table-handle) Imports rows from an Excel worksheet to a Progress temp-table
OnCompleted (EventArgs) Raises the Completed event
OnProgressChanged (EventArgs) Raises the ProgressChanged event
ValidateCellValue (character, integer, character) Validates a cell value

Top Event Summary
Options Name Purpose
Completed (Object, EventArgs) Raised when the import has finished
ProgressChanged (Object, EventArgs) Raised when the import has processed the RowsPerProgressEvent number of rows

Top Property Summary
Options Name Purpose
CHARACTER ColumnReferences
INTEGER RowsImported


Method Detail
Top

ExtractRowValues (WorkbookPart, Row, Object[])
/*
Purpose: Extracts the values from the parameter poValues and populates the Individual Cell Values
for the specified Row
Notes:

Parameters:
poWorkbookPart DocumentFormat.OpenXml.Packaging.WorkbookPart
The reference to the Excel WorkbookPart
poRow DocumentFormat.OpenXml.Spreadsheet.Row
Row
poValues System.Object[]
Array of values
Top

Import (ImportWorksheetArguments, table-handle)
Purpose: Imports from an Excel Worksheet into a Temp-Table
Notes:

Parameters:
poImportWorksheetArguments Consultingwerk.Utilities.Excel.ImportWorksheetArguments
A reference to an ImportWorksheetArguments instance with the parameters for this method
phTempTable TABLE-HANDLE
OUTPUT TABLE-HANDLE The temp-table to import to (note the schema for the temp-table is provided by the caller BY-REFERENCE)
Top

ImportRows (WorkbookPart, SheetData, ImportWorksheetArguments, table-handle)
Purpose: Imports rows from an Excel worksheet to a Progress temp-table
Notes:

Parameters:
poWorkbookPart DocumentFormat.OpenXml.Packaging.WorkbookPart
The reference to the Excel WorkbookPart
poSheetData DocumentFormat.OpenXml.Spreadsheet.SheetData
The Excel SheetData
poImportWorksheetArguments Consultingwerk.Utilities.Excel.ImportWorksheetArguments
A reference to an ImportWorksheetArguments instance with the parameters for this method
phTempTable TABLE-HANDLE
OUTPUT TABLE-HANDLE The temp-table to import to (note the schema for the temp-table is provided by the caller)
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

ValidateCellValue (character, integer, character)
/*
Purpose: Validates a cell value
Notes:

Parameters:
pcCellValue CHARACTER
The cell value to validate
piRowIndex INTEGER
The row index of the cell
pcCellReference CHARACTER
The cell reference of the cell


Event Detail
Top

Completed (Object, EventArgs)
Purpose: Raised when the import 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 import 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


Property Detail
Top

CHARACTER ColumnReferences

Returns CHARACTER
Top

INTEGER RowsImported

Returns INTEGER


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