Search: insert-data-table

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

Results 1 - 10 of 14 next page » Page 1 2

Write Range

Last modified by VuNH54 on 2023/04/20 10:55
Rendered document content
. Only string variables and strings are supported. Data Table - The data that you want to write
to start writing data. Only string variables and strings are supported. Data Table (DataTable)* - The data
RCA.Activities.Excel.WriteRange Description This activity allows you to write the data from
Raw document content
and strings are supported. * **Data Table** - The data that you want to write to the specified range
which to start writing data. Only string variables and strings are supported. * **Data Table (DataTable
" %) ((( RCA.Activities.Excel.WriteRange == **Description** == This activity allows you to write the data from a DataTable variable

Write Cell

Last modified by VuNH54 on 2023/04/20 10:53
Rendered document content
:\FolderName\ClientList.xlsx” Sheet name - The sheet you want to write the data to. E.g: “ClientNames” Cell
want to write the data to. E.g: “ClientNames” Value (String) - The value or formula that you want
: “A20” Misc Public (Checkbox) - If you check it, the data of this activity will be shown in the log
Raw document content
to write the data to. E.g: “ClientNames” * **Cell content **- The value or formula that you want
to write the data to. E.g: “ClientNames” * **Value (String) **- The value or formula that you want
only. E.g: “A20” **Misc** * **Public (Checkbox)** - If you check it, the data of this activity

Read Column

Last modified by VuNH54 on 2023/04/20 10:48
Rendered document content
(String)* - The cell from which to start extracting the column data. By default, this is filled
" Starting Cell (String)* - The cell from which to start extracting the column data. By default
. Remember to consider data security requirement before using this property. Display Name (String) - The name
Raw document content
data. By default, this is filled in with "A1". E.g**:** "A1" == **Properties** == **Input
)*** - The cell from which to start extracting the column data. By default, this is filled in with "A1". E.g: "A1
to consider data security requirement before using this property. * **Display Name (String) **- The name

Excel Write Range

Last modified by VuNH54 on 2023/04/20 10:42
Rendered document content
. E.g: “A10” Data Table - The data that you want to write to the specified range, as a DataTable variable. Only DataTable variables are supported. Properties Input Data Table (DataTable)* - The data
RCA.Activities.Excel.ExcelWriteRange Description This activity allows you to write the data from
Raw document content
and strings are supported. E.g: “A10” * **Data Table** - The data that you want to write to the specified
** * **Data Table (DataTable)*** - The data that you want to write to the specified range, as a DataTable
" %) ((( RCA.Activities.Excel.ExcelWriteRange == **Description** == This activity allows you to write the data from a DataTable variable

Excel Write Cell

Last modified by VuNH54 on 2023/04/20 10:39
Rendered document content
Public (Checkbox) - Check if you want to public it. Remember to consider data security requirement before
Raw document content
it. Remember to consider data security requirement before using it. * **Display Name (String)** - The name
-toc-title" %) ((( Table of Content ))) {{toc depth="4" start="2"/}} ))) #end {{/velocity}} )))

Excel Save As Workbook

Last modified by VuNH54 on 2023/04/20 09:45
Rendered document content
if you want to public it. Remember to consider data security requirement before using it. Display Name
Raw document content
” **Misc** * **Public (Checkbox)** - Check if you want to public it. Remember to consider data security
" %) ((( Table of Content ))) {{toc depth="4" start="2"/}} ))) #end {{/velocity}} )))

Excel Read Range

Last modified by VuNH54 on 2023/04/20 09:37
Rendered document content
to consider data security requirement before using it. Display Name (String) - The name of this activity. You
Raw document content
) **- Check if you want to public it. Remember to consider data security requirement before using
') (% class="akb-toc" %) ((( (% class="akb-toc-title" %) ((( Table of Content ))) {{toc depth="4" start="2

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

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 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
next page » Page 1 2
RSS feed for search on [insert-data-table]
Created by admin on 2022/04/17 14:38