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

Inherits: Progress.Lang.Object
Inherited by: Consultingwerk.Utilities.Excel.ExcelWorksheetExporter Consultingwerk.Utilities.Excel.ExcelWorksheetImporter

File:ExcelUtility
Purpose:Base class of the ExcelWorksheetImporter and Exporter
Author(s):Mike Fechner / Consultingwerk Ltd.
Created:Sun Jul 07 11:44:31 CEST 2019
Purpose: Returns the reference to the Worksheet referenced by either Name or
Index
Notes: The Worksheet name has preference over the index if set

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



Top Method Summary
Options Name Purpose
+ Microsoft.Office.Interop.Excel.Worksheet GetWorksheet (Workbook, character, integer) Returns the reference to the Worksheet referenced by either Name or Index
# Microsoft.Office.Interop.Excel.Workbook OpenWorkbook (Application, character, logical) Opens an Excel Workbook


Method Detail
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 Microsoft.Office.Interop.Excel.Workbook OpenWorkbook (Application, character, logical)
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
plReadOnly LOGICAL
Logical value indicating if the Workbook should be opened read only
Returns Microsoft.Office.Interop.Excel.Workbook
The reference to the Workbook instance


©2006-2023 Consultingwerk Ltd.         info@consultingwerk.de         http://www.consultingwerk.de       08.12.2024 13:24:10