Excel

Guide for the Activities under the Excel Category

Excel Sequence
Description The holder that launches the Excel application and contains the Excel related activities. Attributes Output Result File Path - The...
Thu, 11 Apr, 2019 at 2:56 PM
Append Range
Description Adds the information stored in a DataTable variable to the end of a specified Excel spreadsheet. Attributes Input DataTable - The ...
Thu, 11 Apr, 2019 at 2:59 PM
Execute Macro
Description Execute the macro inside a workbook. The Workbook file needs to be a Macro-Enabled Workbook. Properties Output MacroOutput - The v...
Thu, 11 Apr, 2019 at 3:29 PM
Get Cell Color
Description Gets the color of the cell or a range of cells. The output would be a color variable. Attributes Output Color - The color variable...
Thu, 11 Apr, 2019 at 3:33 PM
Insert Column
Description Inserts a new column into a spreadsheet. Attributes Input Column - The name of the column where the column would be added. Work...
Thu, 11 Apr, 2019 at 3:36 PM
Insert Row
Description Inserts a new row into a spreadsheet. Attributes Input Row - The name of the row where the row would be added. Worksheet - The ...
Thu, 11 Apr, 2019 at 4:35 PM
Read Cell
Description Reads the content of the specified cell and returns the value as an output. Attributes Output Value - The name of the variable wh...
Thu, 11 Apr, 2019 at 4:38 PM
Read Cell Formula
Description Reads the content of the specified cell or range of cells and returns the value as an output. Attributes Output Value - The String...
Thu, 11 Apr, 2019 at 4:40 PM
Read Column
Description Reads the content of the specified column and returns the value as an output. Attributes OutputĀ  Values - The name of the variable...
Thu, 11 Apr, 2019 at 4:44 PM
Read Range
Description Reads the content of the specified cell or range of cells and returns the value as an output. Attributes Output DataTable - Store...
Thu, 11 Apr, 2019 at 4:46 PM