Search: insert-data-table

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

Results 1 - 10 of 68 next page » Page 1 2 3 4 5 6 7

Excel Insert Columns Table

Last modified by VuNH54 on 2023/04/19 17:07
Rendered document content
must be made. E.g: "Sheet1" Table name (String) - Table name you want to insert. E.g: "Table1" Misc
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
Title
Excel Insert Columns Table
Location
Excel Insert Columns Table
Raw document content
)** - Table name you want to insert. E.g: "Table1" * **Column name (String)** - Name of column you want
name (String)** - Table name you want to insert. E.g: "Table1" **Misc** * **Public (Boolean
to organize and structure your code better. E.g: [028225900] Excel Insert Columns Table ))) {{velocity

Excel Insert Rows

Last modified by Giang Tran on 2022/05/13 06:22
Rendered document content
to insert one or more rows in a table, range, or sheet at the specified location. This only can be used
(String)* - The name of the sheet that you want to insert row. E.g: “Employee Name” Number of row (Int) - Number of rows you want to insert in Excel sheet E.g: 5 Row position (Int) - Position where the rows
Title
Excel Insert Rows
Location
Excel Insert Rows
Raw 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 in Excel Application Scope
of the activity** == * **Sheet name (String)*** - The name of the sheet that you want to insert row. E.g

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
file you want to insert. This field accepts only strings and String variables. E.g: “C:\FolderName
path of the image or click “…” button to choose file you want to insert. This field accepts only
Title
Excel Insert Image
Location
Excel Insert Image
Raw document content
want to insert image to. E.g: “Employee Data” * **Range (String)* **- The range you want to add image
(String)** - Input the full path of the image or click “…” button to choose file you want to insert
path of the image or click “…” button to choose file you want to insert. This field accepts only

Activities

Last modified by admin on 2022/07/01 15:42
Rendered document content
Append Range Excel Append Range Excel Application Scope Excel Close Workbook Excel Copy Paste Range Excel Copy Sheet Excel Delete Range Excel Get Workbook Sheet Excel Get Workbook Sheets Excel Insert Columns Table Excel Insert Or Delete Columns Excel Insert Or Delete Rows Excel Insert Rows Excel
Raw document content
/Activities/Excel%20Activities/Activities/Excel%20Get%20Workbook%20Sheets/]] * [[Excel Insert Columns Table
%20Table/]] * [[Excel Insert Or Delete Columns>>url:https://docs.akabot.com/bin/view/Activities/Excel
Insert Or Delete Rows>>url:https://docs.akabot.com/bin/view/Activities/Excel%20Activities/Activities

Excel Insert Or Delete Columns

Last modified by VuNH54 on 2023/04/19 17:08
Rendered document content
) - 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
if you want to public the activity. Remember to consider data security requirement before using
Title
Excel Insert Or Delete Columns
Location
Excel Insert Or Delete Columns
Raw document content
)** - The column where the insertion or removal begins. E.g: 2 * **Sheet name (String)*** - The name of the sheet
)** - The column where the insertion or removal begins. E.g: 2 **Input** * **Change Mode (Dropdown List
to public the activity. Remember to consider data security requirement before using this property

Excel Insert Or Delete Rows

Last modified by Giang Tran on 2022/05/13 06:19
Rendered document content
) - 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
: "Sheet1" Misc Public (Boolean) - Check if you want to public the activity. Remember to consider data
Title
Excel Insert Or Delete Rows
Location
Excel Insert Or Delete Rows
Raw document content
)** - The row where the insertion or removal begins. By default, this is filled in with 1. E.g: 2 * **Sheet
or remove. E.g: 1 * **Row Position (Int32)** - The row where the insertion or removal begins. By default
. Remember to consider data security requirement before using this property. * **Display Name (String

Excel Append Range

Last modified by VuNH54 on 2023/04/19 16:57
Rendered document content
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
Raw document content
" %) ((( 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

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
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

Write CSV File

Last modified by Giang Tran on 2023/09/25 16:27
Rendered document content
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
Raw document content
** == * **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

Read Range

Last modified by Giang Tran on 2022/05/13 06:53
Rendered document content
(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
Raw document content
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
want to read. E.g: "Sheet1" * **Range** - Range of the data. If it isn’t specified, the whole
next page » Page 1 2 3 4 5 6 7
RSS feed for search on [insert-data-table]
Created by admin on 2022/04/17 14:38