Search: output-data-table

Data Table (DataTable) - Represents the output DataTable that contains the information obtained from

of the CSV file E.g: “C:\CSVFolder\clientList.csv” Misc Public (CheckBox) - If you check it, the data of this activity will be shown in the log. Be careful, consider data security before using it. Display Name (String

, it is selected. **Output** * **Data Table (DataTable)** - Represents the output DataTable that contains

” **Misc** * **Public (CheckBox) **- If you check it, the data of this activity will be shown in the log. Be careful, consider data security before using it. * **Display Name (String) **- The name of this activity

(DataTable) - Stores the data extracted from the specified Excel range in a data table variable. Only data

” Sheet name (String)* - The sheet you want to read. E.g: "Sheet1" Range - Range of the data. If it isn’t

)- The sheet you want to read. E.g: "Sheet1" Range - Range of the data. If it isn’t specified, the whole

is cleared **Output** * **DataTable (DataTable)** - Stores the data extracted from the specified Excel range in a data table variable. Only data table variables are supported ))) {{velocity

: "Sheet1" * **Range** - Range of the data. If it isn’t specified, the whole spreadsheet will be read. E.g

the file path of the CSV here. String supported only. Data Table (DataTable) - Specifies the DataTable to be written in the CSV file. Properties Input Data Table (DataTable)* - Specifies the DataTable

\clientList.csv” Misc Public (CheckBox) - If you check it, the data of this activity will be shown in the log

** == * **File Path (String)** - You can add the file path of the CSV here. String supported only. * **Data Table (DataTable)** - Specifies the DataTable to be written in the CSV file. == **Properties** == **Input** * **Data Table (DataTable)*** - Specifies the DataTable to be written in the CSV file

, data tables or other types of collections. (* for Mandatory) Properties Input Values (IEnumerable)*- Iterate through the data and process each piece of information individually. Able to input variable

it, the data of this activity will be shown in the log. Be careful, consider data security before using

" %) ((( RCA.Activities.Core.ForEach == **Description** == This activity allows you to loop through arrays, lists, data tables

) == **Properties** == **Input** * **Values (IEnumerable)***- Iterate through the data and process each piece

. E.g: [389861710] For Each < T > * **Public (Checkbox)** - If you check it, the data of this activity

. E.g: Get Workbook Sheets Table of Content Output Sheet (List< String >) - List of string

to public it. Remember to consider data security requirement before using it. Display Name (String

" %) ((( Table of Content ))) {{toc depth="4" start="2"/}} ))) ))) **Output** * **Sheet (List< String

) **- Check if you want to public it. Remember to consider data security requirement before using

and choose data type is "Table". Step 3: (This step is optional) Turn on button "Required" to set require

and data type for each column Step 6: Click "Save" button Table of Content

and Table Field 1. Add Form Field Step 1: On Add Learning Instance screen, click "Add Field" button

the table name on "Label" field and choose data type is "Table". ))) [[image:image-20221028164141-11.png

types of fields: Form Field and Table Field == **1. Add Form Field** == (% class="box infomessage

the field name on "Label" field and choose data type for field on "Data Type" field ))) [[image:image

in a Data Table variable to the end of a specified Excel spreadsheet. (* is mandatory) In the body

, this is filled in with "Sheet1". Only String variables and strings are supported. E.g: “ClientNames” Data Table

." Only String variables and strings are supported. E.g: “ClientNames” Data Table (DataTable)* - The data

" %) ((( RCA.Activities.Excel.ExcelAppendRange == **Description** == This activity allows adding information stored in a Data Table variable

: “ClientNames” * **Data Table** - The data to be added. This field supports only DataTable variables

: “ClientNames” * **Data Table (DataTable)*** - The data to be added. This field supports only DataTable

based upon the value entered in the ROI data set table, as well as the days until your defined goal

the Manual Time value entered in the ROI data set table. Goal Input Static display of your defined

to date, based upon the Manual Time value entered in the ROI data set table. Displays the Top 10

 value entered in the **ROI data set table**. ))) |((( **Goal ** )))|((( Input )))|((( Static display

in the **ROI data set table**. ))) |((( **Cumulative Time Saved** )))|((( Column Chart )))|((( Total time saved

** )))|((( Input )))|((( Displays the current total of money saved based upon the value entered in the **ROI data

position in the table. (* for mandatory) In the body of activity Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" Table name (String) - Table name you

must be made. E.g: "Sheet1" Table name (String) - Table name you want to insert. E.g: "Table1" Misc

Excel Insert Columns Table

Excel Insert Columns Table

" %) ((( RCA.Activities.Excel.ExcelInsertColumnsTable == **Description** == Adds a specified column at a certain position in the table. [[image:image

)*** - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" * **Table name (String)** - Table name you want to insert. E.g: "Table1" * **Column name (String)** - Name of column you want

of activity File path (String) - You can add the file path of the CSV here. String supported only. Data Table (DataTable) - The data table you want to append. Properties File File Path (String)* - The file path of the CSV file E.g: “C:\CSVFolder\clientList.csv” Input Data Table (DataTable)* - Specifies the DataTable

of the CSV here. String supported only. * **Data Table (DataTable)** - The data table you want to append

\clientList.csv” **Input** * **Data Table (DataTable)*** - Specifies the DataTable to be appended to the CSV

)** - If you check it, the data of this activity will be shown in the log. Be careful, consider data security