Search: add-data-column

Last modified by admin on 2022/04/24 04:58

Results 1 - 9 of 9 Page 1

Read CSV File

Last modified by Giang Tran on 2023/09/25 16:27
Rendered document content
a specified CSV File. (* is mandatory) In the body of activity File Path (String) - You can add the file
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
Raw document content
Path (String)** - You can add the file path of the CSV here. String supported only. == **Properties
” **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

Write CSV File

Last modified by Giang Tran on 2023/09/25 16:27
Rendered document content
DataTable to a CSV File. (* is mandatory) In the body of activity 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
Raw document content
** == * **File Path (String)** - You can add the file path of the CSV here. String supported only. * **Data
” * **Add Headers (CheckBox)** - Boolean that specifies if the column names from the DataTable will be added
** == **Input** * **Data Table (DataTable)*** - Specifies the DataTable to be written in the CSV file

Read Range

Last modified by Giang Tran on 2022/05/13 06:53
Rendered document content
Options Add Headers - If you select this, the column headers from the specified spreadsheet range
” 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
Raw document content
. E.g: Read Range **Options** * **Add Headers **- If you select this, the column headers from
: "Sheet1" * **Range** - Range of the data. If it isn’t specified, the whole spreadsheet will be read. E.g
want to read. E.g: "Sheet1" * **Range** - Range of the data. If it isn’t specified, the whole

Excel Delete Range

Last modified by Giang Tran on 2022/05/13 04:31
Rendered document content
in an Excel workbook. Can also be used to shift an entire row or column by using the ShiftCells
of the sheet contains the data you want to delete. By default, this is filled in with "Sheet1." Only String variables and strings are supported. E.g: “Employee Data” Range (String)* - The range you want to delete
Raw document content
. Can also be used to shift an entire row or column by using the ShiftCells and ShiftOption property
** == **Input** * **Sheet Name (String)** - The name of the sheet contains the data you want to delete
Data” * **Range (String)* **- The range you want to delete. This field supports only strings

Add Log Fields

Last modified by Giang Tran on 2022/05/13 03:34
Rendered document content
RCA.Activities.Core.AddLogFields Description This activity allows you to add customized log
(Checkbox) - If you check it, the data of this activity will be shown in the log. Be careful, consider data
of the activity to organize and structure your code better. E.g: [056739368] Add Log Fields
Title
Add Log Fields
Location
Add Log Fields
Raw document content
" %) ((( RCA.Activities.Core.AddLogFields == **Description** == This activity allows you to add customized log fields to each and every
lines. **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

Excel Insert Or Delete Rows

Last modified by Giang Tran on 2022/05/13 06:19
Rendered document content
RCA.Activities.Excel.ExcelInsertOrDeleteRows Description Adds or removes a specified number
) - The number of rows you wish to add or remove. E.g: 1 Position (Int32) - The row where the insertion
) - The number of rows you wish to add or remove. E.g: 1 Row Position (Int32) - The row where the insertion
Raw document content
" %) ((( RCA.Activities.Excel.ExcelInsertOrDeleteRows == **Description** == Adds or removes a specified number of rows at a certain position
of row (Int32)** - The number of rows you wish to add or remove. E.g: 1 * **Position (Int32
" == **Properties** == **Destination** * **Number of rows (Int32)** - The number of rows you wish to add

Comment Out

Last modified by Giang Tran on 2022/05/13 03:32
Rendered document content
RCA.Activities.Core.CommentOut Description This activity allows you to add different activities that won’t be executed at run time. Properties 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
Raw document content
" %) ((( RCA.Activities.Core.CommentOut == **Description** == This activity allows you to add different activities that won’t
(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. You can edit

Append CSV File

Last modified by Giang Tran on 2023/09/25 16:27
Rendered document content
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
Raw document content
]] (* is mandatory) == **In the body 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
\clientList.csv” **Input** * **Data Table (DataTable)*** - Specifies the DataTable to be appended to the CSV

Excel Insert Rows

Last modified by Giang Tran on 2022/05/13 06:22
Rendered document content
RCA.Activities.Excel.ExcelInsertRows Description This activity allows you to add more rows to insert one or more rows in a table, range, or sheet at the specified location. This only can be used
Public (Checkbox) - Check if you want to public it. Remember to consider data security requirement before
Raw document content
(% class="akb-page-with-toc" %) ((( (% class="akb-page-content" %) ((( RCA.Activities.Excel.ExcelInsertRows == **Description** == This activity allows you to add more rows to insert one or more rows
at. **Misc** * **Public (Checkbox)** - Check if you want to public it. Remember to consider data security
Page 1
RSS feed for search on [add-data-column]
Created by admin on 2022/04/17 14:38