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=
! Argument!! Type !! Direction !! Purpose
|- align="left"
| DataSourceContainsHeader|| {{String_MSDNBoolean_MSDN}}|| In || The unique name of the database to connect toExcel sheet has headers
|- align="left"
| InitialCatalogDisplayName|| {{String_MSDN}}|| In || The database instance to connect toDiplay name of the activity
|- align="left"
| UserNameFullPath|| {{String_MSDN}}|| In || The user name to connect withfull path of the file
|- align="left"
| Password|| {{String_MSDN}}|| In || The corresponding password for the user
|- align="left"
| Tables|| List<OLETableDescriptor>|| Out || A list of all found tables in the database
|- align="left"
| Result|| {{Boolean_MSDN}}|| Out || True if successful, false if failed
|- align="left"
| Tables|| List{{OLETableDescriptor}}|| Out || not used
|}
===Usage===
This activity is used to start the communication with 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=
The CreateOLESQLScope CreateOLEExcelScope activity, as used in the larger example "Read MetaClass names from UBIK database":
[[File:UI_Activity_CreateOLEDBScope_Example.png|x700px]]