Activity:CreateOLEExcelScope (Activity) - Revision history

KNO at 14:41, 23 September 2015

2015-09-23T14:41:51Z

2015-09-17T15:23:59Z

2015-03-19T10:26:54Z

2015-02-23T15:45:12Z

2015-02-23T14:46:28Z

‎Example

2015-02-23T14:45:56Z

2015-02-23T14:45:08Z

‎Example

2015-02-23T14:44:34Z

‎Example

2015-02-23T14:42:50Z

‎Example

2015-02-23T14:26:24Z

‎Example

@@ Line 33: / Line 33: @@
 ===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 [[Activity:CreateOLETableScope (Activity)|CreateOLETableScope]] activities, either as direct children but also wrapped within looping activities like ForEach or While.
 =Example=

@@ Line 1: / Line 1: @@
 The CreateOLEExcelScope opens an Excel file and provides access to its workbooks and sheets.
 =Description=
@@ Line 46: / Line 45: @@
 * [[Activity:CreateOLETableScope (Activity)]]
-[[Category:OLE]]
+[[Category:OLE|CreateOLEExcelScope (Activity)]]

@@ Line 29: / Line 29: @@
 | Result|| {{Boolean_MSDN}}|| Out || True if successful, false if failed
 |- align="left"
-| Tables|| List<{{OLETableDescriptor}}>|| Out || not used
+| Tables|| List<[[OLETableDescriptor]]>|| Out || not used
 |}

@@ Line 38: / Line 38: @@
 The CreateOLEExcelScope activity with a workflow and its arguments.
 {{Hint|Check '''ContainsHeader''' if the Excel document uses a header row!}}
-[[File:UI_Activity_CreateOLEExcelScope.png|CreateOLEExcelScope]]
+[[File:UI_Activity_CreateOLEExcelScope.png|border|CreateOLEExcelScope]]
-[[File:UI_Activity_CreateOLEExcelScope_Arguments.png|CreateOLEExcelScope]]
+[[File:UI_Activity_CreateOLEExcelScope_Arguments.png|border|CreateOLEExcelScope]]
 <headertabs />

@@ Line 37: / Line 37: @@
 =Example=
 The CreateOLEExcelScope activity with a workflow and its arguments.
-{{Hint|Check '''ContainsHeader''' if the Excel document has a header row!}}
+{{Hint|Check '''ContainsHeader''' if the Excel document uses a header row!}}
 [[File:UI_Activity_CreateOLEExcelScope.png|CreateOLEExcelScope]]
 [[File:UI_Activity_CreateOLEExcelScope_Arguments.png|CreateOLEExcelScope]]

@@ Line 36: / Line 36: @@
 =Example=
-The CreateOLEExcelScope activity, as used in the larger example "Read MetaClass names from UBIK database":
+The CreateOLEExcelScope activity, as used in the larger example "Read data from an Excel document":
 [[File:UI_Activity_CreateOLEDBScope_Example.png|x700px]]