Search: add-data-row

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

Results 1 - 10 of 25 next page » Page 1 2 3

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

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
** == **Input** * **Data Table (DataTable)*** - Specifies the DataTable to be written in the CSV file
” **Misc** * **Public (CheckBox)** - If you check it, the data of this activity will be shown in the log

Write Range

Last modified by VuNH54 on 2023/04/20 10:55
Rendered document content
RCA.Activities.Excel.WriteRange Description This activity allows you to write the data from
. If the starting cell is not specified, the data is written starting from the A1 cell. (* for mandatory
, this is filled in with "Sheet1." E.g: “ClientNames” Starting Cell – The cell from which to start writing data
Raw document content
" %) ((( RCA.Activities.Excel.WriteRange == **Description** == This activity allows you to write the data from a DataTable variable
, the data is written starting from the A1 cell. (% class="wikigeneratedid" id="H" %) [[image:image
: “ClientNames” * **Starting Cell **– The cell from which to start writing data. Only string variables

Excel Write Range

Last modified by VuNH54 on 2023/04/20 10:42
Rendered document content
RCA.Activities.Excel.ExcelWriteRange Description This activity allows you to write the data from
. If the starting cell isn't specified, the data is written starting from the A1 cell. If the sheet does not exist
” Starting Cell - The cell from which to start writing data. Only string variables and strings are supported
Raw document content
" %) ((( RCA.Activities.Excel.ExcelWriteRange == **Description** == This activity allows you to write the data from a DataTable variable
, the data is written starting from the A1 cell. If the sheet does not exist, a new one is created
. E.g: “Sheet1” * **Starting Cell **- The cell from which to start writing data. Only string variables

Excel Write Cell

Last modified by VuNH54 on 2023/04/20 10:39
Rendered document content
of activity Sheet Name - The name of the sheet in which to add the specified cell to. By default
are supported. E.g: “A1:K10” Sheet Name (String)* - The name of the sheet in which to add the specified cell
Public (Checkbox) - Check if you want to public it. Remember to consider data security requirement before
Raw document content
) == **In the body of activity** == * **Sheet Name **- The name of the sheet in which to add the specified cell
of the sheet in which to add the specified cell to. By default, this is filled in with "Sheet1". Only String
it. Remember to consider data security requirement before using it. * **Display Name (String)** - The name

Excel Read Range

Last modified by VuNH54 on 2023/04/20 09:37
Rendered document content
" Range (String) - The range from which you want to remove duplicate rows. E.g: "A1:H5" Properties Input
to consider data security requirement before using it. Display Name (String) - The name of this activity. You
Raw document content
: "Sheet1" * **Range (String)** - The range from which you want to remove duplicate rows. E.g: "A1:H5
) **- Check if you want to public it. Remember to consider data security requirement before using

Excel Insert Image

Last modified by VuNH54 on 2023/04/19 17:20
Rendered document content
to insert image to. E.g: “Employee Data” Range (String)* - The range you want to add image to. E.g: “K1:L1
RCA.Activities.Excel.ExcelInsertImage Description This activity allows you to add images
) - The range you want to add image to. E.g: “K1:L1” Properties Input Image path (String)* - Input the full
Raw document content
want to insert image to. E.g: “Employee Data” * **Range (String)* **- The range you want to add image
" %) ((( RCA.Activities.Excel.ExcelInsertImage == **Description** == This activity allows you to add images to specified Excel Sheets
) **- The sheet that you want to display. E.g: “ThisIsSheetName” * **Range (String) **- The range you want to add

Excel Insert Or Delete Columns

Last modified by VuNH54 on 2023/04/19 17:08
Rendered document content
RCA.Activities.Excel.ExcelInsertOrDeleteColumns Description Adds or removes a specified number
) - The number of columns you wish to add or remove. E.g: 1 Position (Int32) - The column where the insertion
to add or remove. E.g: 1 Position (Int32) - The column where the insertion or removal begins. E.g: 2
Raw document content
" %) ((( RCA.Activities.Excel.ExcelInsertOrDeleteColumns == **Description** == Adds or removes a specified number of columns at a certain position
of columns (Int32)** - The number of columns you wish to add or remove. E.g: 1 * **Position (Int32
of column (Int32)** - The number of columns you wish to add or remove. E.g: 1 * **Position (Int32

Excel Insert Columns Table

Last modified by VuNH54 on 2023/04/19 17:07
Rendered document content
RCA.Activities.Excel.ExcelInsertColumnsTable Description Adds a specified column at a certain
) - Position you want to add. Sheet name (String)* - The name of the sheet in the workbook where the change
Public (Boolean) - Check if you want to public the activity. Remember to consider data security
Raw document content
" %) ((( RCA.Activities.Excel.ExcelInsertColumnsTable == **Description** == Adds a specified column at a certain position in the table. [[image:image
want to insert. E.g: "Column1" * **Position (Int32)** - Position you want to add. * **Sheet name
) **- Check if you want to public the activity. Remember to consider data security requirement before using
next page » Page 1 2 3
RSS feed for search on [add-data-row]
Created by admin on 2022/04/17 14:38