The CreateOLEExcelScope opens an Excel file and provides access to its workbooks and sheets.
{{Attention|Only files from Excel 97-2003 (*.xls) is supported yet!}}
=Description=
| Result|| {{Boolean_MSDN}}|| Out || True if successful, false if failed
|- align="left"
| Tables|| List{{<[[OLETableDescriptor}}]]>|| 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 [[Activity:CreateOLETableScope (Activity)|CreateOLETableScope]] activities, either as direct children but also wrapped within looping activities like ForEach or While.
{{Attention|On 32 bit platforms only .xls files can be processed, whereas on 64 bit platforms also new Excel extensions are possible.}}
=Example=
The CreateOLEExcelScope activity, as used in with a workflow and its arguments.{{Hint|Check '''ContainsHeader''' if the larger example "Read MetaClass names from UBIK database":Excel document uses a header row!}}[[File:UI_Activity_CreateOLEDBScope_ExampleUI_Activity_CreateOLEExcelScope.png|x700pxborder|CreateOLEExcelScope]][[File:UI_Activity_CreateOLEExcelScope_Arguments.png|border|CreateOLEExcelScope]]
<headertabs />
* [[Workflow Designer]]
* [[Activity:CreateOLETableScope (Activity)]]
* [[HowTo:Connect_To_Oracle_With_A_Workflow]]
[[Category:OLE|CreateOLEExcelScope (Activity)]]