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

Inherits: Progress.Lang.Object

File:ExcelWorksheetExporter
Author(s):Sebastian Düngel / Consultingwerk Ltd.
Created:Thu Jun 14 11:12:32 CEST 2012

Navigate to: Methods | Constructors | Events | Properties



Top Method Summary
Options Name Purpose
+ ExportExcel (ExportWorksheetArguments, handle) Export rows from an Progress temp-table to a Excel worksheet
# ExportRows (Worksheet, ExportWorksheetArguments, handle, integer) Exports rows from Progress temp-table to an Excel-Worksheet
+ Microsoft.Office.Interop.Excel.Worksheet GetWorksheet (Workbook, character, integer) Returns the reference to the Worksheet referenced by either Name or Index
# OnCompleted (EventArgs) Raises the Completed event
# OnProgressChanged (EventArgs) Raises the ProgressChanged event
+ Microsoft.Office.Interop.Excel.Workbook OpenWorkbook (Application, character) Opens an Excel Workbook

Top Constructor Summary
Options Name Purpose
+ ExcelWorksheetExporter () Constructor for the ExcelWorksheetExporter class

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

Top Property Summary
Options Name Purpose
+ INTEGER RowsExported Returns the number of rows that have been exported


Method Detail
Top

PUBLIC ExportExcel (ExportWorksheetArguments, handle)
Purpose: Export rows from an Progress temp-table to a Excel worksheet
Notes:

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

PROTECTED ExportRows (Worksheet, ExportWorksheetArguments, handle, integer)
Purpose: Exports rows from Progress temp-table to an Excel-Worksheet
Notes:

Parameters:
poWorksheet Microsoft.Office.Interop.Excel.Worksheet
The reference to the Excel Worksheet
poExportWorksheetArguments Consultingwerk.Utilities.Excel.ExportWorksheetArguments
A reference to an ImportWorksheetArguments instance with the parameters for this method
phTempTable HANDLE
OUTPUT TABLE-HANDLE The temp-table to import to (note the schema for the temp-table is provided by the caller)
piStartRow INTEGER
Sets the Startrow of the Worksheet to be Exported
Top

PUBLIC Microsoft.Office.Interop.Excel.Worksheet GetWorksheet (Workbook, character, integer)
Purpose: Returns the reference to the Worksheet referenced by either Name or
Index
Notes: The Worksheet name has preference over the index if set

Parameters:
poWorkbook Microsoft.Office.Interop.Excel.Workbook
The reference to the workbook that contains the Worksheet
pcWorksheetName CHARACTER
The name of the worksheet to return
piWorksheetIndex INTEGER
The index (number) of the worksheet to return
Returns Microsoft.Office.Interop.Excel.Worksheet
The reference to the Excel worksheet
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

PUBLIC Microsoft.Office.Interop.Excel.Workbook OpenWorkbook (Application, character)
Purpose: Opens an Excel Workbook
Notes:

Parameters:
poExcel Microsoft.Office.Interop.Excel.Application
The reference to an Excel Application instance
pcFileName CHARACTER
The file name of the Workbook to open
Returns Microsoft.Office.Interop.Excel.Workbook
The reference to the Workbook instance


Constructor Detail
Top

PUBLIC ExcelWorksheetExporter ()
Purpose: Constructor for the ExcelWorksheetExporter class
Notes:



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


Property Detail
Top

PUBLIC INTEGER RowsExported
Purpose: Returns the number of rows that have been exported
Notes:

Returns INTEGER


©2006-2016 Consultingwerk Ltd.         info@consultingwerk.de         http://www.consultingwerk.de       26.08.2016 08:47:03