Difference between revisions of "Activity:CreateOLEExcelScope (Activity)"
| Line 1: | Line 1: | ||
The CreateOLEExcelScope opens an Excel file and provides access to its workbooks and sheets. | The CreateOLEExcelScope opens an Excel file and provides access to its workbooks and sheets. | ||
| − | {{Attention|Only Excel 97-2003 (*.xls) is supported yet!}} | + | {{Attention|Only files from Excel 97-2003 (*.xls) is supported yet!}} |
=Description= | =Description= | ||
| Line 19: | Line 19: | ||
! Argument!! Type !! Direction !! Purpose | ! Argument!! Type !! Direction !! Purpose | ||
|- align="left" | |- align="left" | ||
| − | | | + | | ContainsHeader|| {{Boolean_MSDN}}|| In || Excel sheet has headers |
|- align="left" | |- align="left" | ||
| − | | | + | | DisplayName|| {{String_MSDN}}|| In || Diplay name of the activity |
|- align="left" | |- align="left" | ||
| − | | | + | | FullPath|| {{String_MSDN}}|| In || The full path of the file |
|- align="left" | |- align="left" | ||
| Password|| {{String_MSDN}}|| In || The corresponding password for the user | | Password|| {{String_MSDN}}|| In || The corresponding password for the user | ||
| − | |||
| − | |||
|- align="left" | |- align="left" | ||
| Result|| {{Boolean_MSDN}}|| Out || True if successful, false if failed | | Result|| {{Boolean_MSDN}}|| Out || True if successful, false if failed | ||
| + | |- align="left" | ||
| + | | Tables|| List{{OLETableDescriptor}}|| Out || not used | ||
|} | |} | ||
===Usage=== | ===Usage=== | ||
| − | This activity is used to | + | This activity is used to open an Excel document as an OLE compliant data source. It is a nestable activity, which means it can host any amount of sub-activities that will be processed sequentially. The hosted activities are typically [[Activity:CreateOLETableScope (Activity)|CreateOLETableScope]] activities, either as direct children but also wrapped within looping activities like ForEach or While. |
=Example= | =Example= | ||
| − | The | + | The CreateOLEExcelScope activity, as used in the larger example "Read MetaClass names from UBIK database": |
[[File:UI_Activity_CreateOLEDBScope_Example.png|x700px]] | [[File:UI_Activity_CreateOLEDBScope_Example.png|x700px]] | ||
Revision as of 13:33, 23 February 2015
The CreateOLEExcelScope opens an Excel file and provides access to its workbooks and sheets.
 | Only files from Excel 97-2003 (*.xls) is supported yet! |
[edit]
Description
| Create OLE Excel Scope | |
|---|---|
| Name | CreateOLEExcelScope |
| Purpose | Open an Excel file via OLE |
| Category | UBIK Data Exchange |
| Returns | True if successful |
| Version | 2.4.1+ |
Arguments
| Argument | Type | Direction | Purpose |
|---|---|---|---|
| ContainsHeader | Boolean | In | Excel sheet has headers |
| DisplayName | String | In | Diplay name of the activity |
| FullPath | String | In | The full path of the file |
| Password | String | In | The corresponding password for the user |
| Result | Boolean | Out | True if successful, false if failed |
| Tables | ListOLETableDescriptor | Out | not used |
Usage
This activity is used to open an Excel document as an OLE compliant data source. It is a nestable activity, which means it can host any amount of sub-activities that will be processed sequentially. The hosted activities are typically CreateOLETableScope activities, either as direct children but also wrapped within looping activities like ForEach or While.
Example
The CreateOLEExcelScope activity, as used in the larger example "Read MetaClass names from UBIK database":
