Search: add-data-row
Last modified by admin on 2022/04/24 04:58
Refine your search
Select a category and activate filters on the current results
Location
- 24Activities
- 1akaBot Studio
Last author
- 11Giang Tran
- 10VuNH54
- 4DatPT
Creator
- 24Giang Tran
- 1admin
Last modification date
Creation date
Upload date
Append CSV File
Located in
- 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
Located in
- 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
Located in
- 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
Located in
- 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
Located in
- 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
Located in
- 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
Located in
- 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
Located in
- 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
Located in
- 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
Located in
- 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]