Jump to: navigation, search

CreateOLEExcelScope (Activity)


Revision as of 14:41, 23 September 2015 by KNO (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

The CreateOLEExcelScope opens an Excel file and provides access to its workbooks and sheets.

[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 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 CreateOLETableScope activities, either as direct children but also wrapped within looping activities like ForEach or While.

IC Attention.pngOn 32 bit platforms only .xls files can be processed, whereas on 64 bit platforms also new Excel extensions are possible.

Example

The CreateOLEExcelScope activity with a workflow and its arguments.

IC Hint square.pngCheck ContainsHeader if the Excel document uses a header row!

CreateOLEExcelScope CreateOLEExcelScope

See also