Microsoft Office.Excel
Description
Read-out a specified excel range and saves the result inside a data table.
Properties
Analyst
- Description: Optional text for documentation purposes.
Common
-
Continue On Error: Continues the execution of the workflow even if an error occurs during the execution of the activity.
-
Delay Before: Delay time in milliseconds before the activity is executed. The default value is 250 milliseconds.
-
Delay After: Delay time in milliseconds after executing of the activity. The default value is 250 milliseconds.
-
Disable Log: Disables the logging functionality for this activity.
-
Disable Protocol: Disables the protocol functionality for this activity.
-
Exclude from Global Delay: Excludes this activity from the Global Delay functionality.
-
Timeout: Duration in milliseconds in which the activity tries to execute.
Input
- Range: Set range to read out.
- Sheet Name: Name of the sheet in excel workbook.
Options
- Return Visible Text: Choose to return visible text.
- Add Headers: Choose to add headers.
- Delete Empty Columns: Choose to delete empty columns.
- Delete Empty Rows: Choose to delete empty rows.
-
Till Last Row: Choose to
read excel sheet to the last row. Note: If set, this property overwrites the Range property.
- Till Last Column: Choose to read excel sheet to the last column. (Note, overwrites 'Range').
Output
- Data Table: Output as data table.