Changes
Created page with "The CreateOLEExcelScope opens an Excel file and provides access to its workbooks and sheets. {{Attention|Only Excel 97-2003 (*.xls) is supported yet!}} =Description= {{Activ..."
The CreateOLEExcelScope opens an Excel file and provides access to its workbooks and sheets.
{{Attention|Only Excel 97-2003 (*.xls) is supported yet!}}
=Description=
{{ActivityInfoBox
| title = Create OLE Excel Scope
| name = CreateOLEExcelScope
| image = [[File:UI_Activity_CreateOLEExcelScope.png|220px]]
| imagecaption = CreateOLEExcelScope (Expanded)
| purpose = Open an Excel file via OLE
| category = UBIK Data Exchange
| returns = True if successful
| version = 2.4.1+
}}
===Arguments===
{| class="wikitable sortable" | width = "50%"
|-
! Argument!! Type !! Direction !! Purpose
|- align="left"
| DataSource|| {{String_MSDN}}|| In || The unique name of the database to connect to
|- align="left"
| InitialCatalog|| {{String_MSDN}}|| In || The database instance to connect to
|- align="left"
| UserName|| {{String_MSDN}}|| In || The user name to connect with
|- 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
|}
===Usage===
This activity is used to start the communication with 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 activity, as used in the larger example "Read MetaClass names from UBIK database":
[[File:UI_Activity_CreateOLEDBScope_Example.png|x700px]]
<headertabs />
==See also==
* [[Workflow Designer]]
* [[Activity:CreateOLETableScope (Activity)]]
* [[HowTo:Connect_To_Oracle_With_A_Workflow]]
[[Category:OLE]]
{{Attention|Only Excel 97-2003 (*.xls) is supported yet!}}
=Description=
{{ActivityInfoBox
| title = Create OLE Excel Scope
| name = CreateOLEExcelScope
| image = [[File:UI_Activity_CreateOLEExcelScope.png|220px]]
| imagecaption = CreateOLEExcelScope (Expanded)
| purpose = Open an Excel file via OLE
| category = UBIK Data Exchange
| returns = True if successful
| version = 2.4.1+
}}
===Arguments===
{| class="wikitable sortable" | width = "50%"
|-
! Argument!! Type !! Direction !! Purpose
|- align="left"
| DataSource|| {{String_MSDN}}|| In || The unique name of the database to connect to
|- align="left"
| InitialCatalog|| {{String_MSDN}}|| In || The database instance to connect to
|- align="left"
| UserName|| {{String_MSDN}}|| In || The user name to connect with
|- 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
|}
===Usage===
This activity is used to start the communication with 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 activity, as used in the larger example "Read MetaClass names from UBIK database":
[[File:UI_Activity_CreateOLEDBScope_Example.png|x700px]]
<headertabs />
==See also==
* [[Workflow Designer]]
* [[Activity:CreateOLETableScope (Activity)]]
* [[HowTo:Connect_To_Oracle_With_A_Workflow]]
[[Category:OLE]]
