Search: select-item-1
Last modified by admin on 2022/04/24 04:58
Refine your search
Select a category and activate filters on the current results
Last author
- 13Giang Tran
- 7DatPT
- 3VuNH54
Creator
- 19Giang Tran
- 4admin
Last modification date
Creation date
Upload date
Excel Insert Or Delete Rows
Located in
- Rendered document content
or removal begins. By default, this is filled in with 1. E.g: 2 Input Change Mode (Dropdown List) - Selects
…) - The number of rows you wish to add or remove. E.g: 1 Position (Int32) - The row where the insertion or removal begins. By default, this is filled in with 1. E.g: 2 Sheet name (String)* - The name of the sheet
- Raw document content
, this is filled in with 1. E.g: 2 **Input** * **Change Mode (Dropdown List) **- Selects whether
…. [[image:image-20220505140814-1.png]] (* for mandatory) == **In the body of activity** == * **Number of row (Int32)** - The number of rows you wish to add or remove. E.g: 1 * **Position (Int32
Excel Insert Or Delete Columns
Located in
- 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 Input Change Mode (Dropdown List) - Selects whether the activity adds or removes columns. ・Add: Add
- Raw document content
. [[image:image-20220505141134-1.png]] (* for mandatory) == **In the body of activity** == * **Number 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 Copy Paste Range
Located in
- Rendered document content
Copy Items (Dropdown checkboxes) - A dropdown specifying what additional data to copy for the specified range. You can select between Value, Formula, Number Format, Cell Format and All.
- Raw document content
or to a different workbook. [[image:image-20220505131502-1.jpeg]] (* for mandatory) == **Properties** == **Copy
…and structure your code better. E.g: Copy Range **Options** * **Copy Items (Dropdown checkboxes)** - A dropdown specifying what additional data to copy for the specified range. You can select between Value
Select Folder
Located in
- Rendered document content
RCA.Activities.Core.SelectFolder Description This activity opens a dialog, allows you to select a folder and returns full path of the selected folder. Properties Misc Public (Checkbox) - If you
…to organize and structure your code better. E.g: [351576757] Select Folder Output Selected Folder (String
- Title
Select Folder
- Location
[1] Core Activities
…Select Folder
- Raw document content
" %) RCA.Activities.Core.SelectFolder == **Description** == This activity opens a dialog, allows you to select a folder and returns full path of the selected folder. [[image:image-20220505093358-1.jpeg]] == **Properties** == **Misc
…edit the name of the activity to organize and structure your code better. E.g: [351576757] Select
Select File
Located in
- Rendered document content
RCA.Activities.Core.SelectFile Description This activity opens a dialog, allows you to select a file and returns full path of the selected file. Properties Input Filter (String) – Used to specify the type of file you want to select. This filter should contain a description of the filter
- Title
Select File
- Location
[1] Core Activities
…Select File
- Raw document content
" %) ((( RCA.Activities.Core.SelectFile == **Description** == This activity opens a dialog, allows you to select a file and returns full path of the selected file. [[image:image-20220505093334-1.jpeg]] == **Properties** == **Input** * **Filter (String) **– Used to specify the type of file you want to select. This filter should contain
Excel Select Range
Located in
- Rendered document content
RCA.Activities.Excel.ExcelSelectRange Description The activity allows you to select and execute
…) Properties Input Sheet name (String) - The name of the sheet from which to select the specified range
…)* - The range to be selected. Only String variables and strings are supported. E.g: “A1:K10” Misc Public
- Title
Excel Select Range
- Location
Excel Select Range
- Raw document content
" %) ((( RCA.Activities.Excel.ExcelSelectRange == **Description** == The activity allows you to select and execute a specified range from an Excel spreadsheet, in order to perform further actions. [[image:image-20220505133120-1.jpeg
…which to select the specified range. By default, this is filled in with "Sheet1". Only String variables
Excel Select Sheet
Located in
- Rendered document content
RCA.Activities.Excel.ExcelSelectSheet Description The activity allows you to select and execute
…(String)* - The name of the sheet from which to select the specified range. By default, this is filled
…. E.g: Select Sheet
- Title
Excel Select Sheet
- Location
Excel Select Sheet
- Raw document content
" %) ((( RCA.Activities.Excel.ExcelSelectSheet == **Description** == The activity allows you to select and execute a specified sheet, in order to perform further actions. [[image:image-20220505132753-1.jpeg]] (* for mandatory) == **Properties** == **Input** * **Sheet name (String)* **- The name of the sheet from which to select
Excel Read Cell
Located in
- Rendered document content
to be read. If there is no amendment, “Sheet1” is automatically selected. “Cell” - Specified cell need has to identify to read. If there is no amendment, “A1” is automatically selected. Properties Input Cell
…) - Selecting this check box keeps the formatting of the cell that you want to read. By default, the check box
- Raw document content
it in a variable. It is only be used inside the Excel Application Scope activity. [[image:image-20220505112903-1
…selected. * **“Cell” **- Specified cell need has to identify to read. If there is no amendment, “A1” is automatically selected. == **Properties** == **Input** * **Cell (String)*** - The cell that you want
Excel Application Scope
Located in
- Rendered document content
the macro level for the current Excel file. By default, EnableAll is selected. The drop-down contains three
…Excel Macro settings Read Only (Checkbox): Opens the specified workbook in Read-Only mode. Selecting
…or has an edit password. By default, this check box is not selected. Visible (Checkbox )- When selected
- Raw document content
for Excel Activities. [[image:image-20220505111836-1.jpeg]] (* for mandatory) == **In the body
…)** - Specifies the macro level for the current Excel file. By default, EnableAll is selected. The drop-down
…. Selecting this check box enables you to perform data extraction operations in an Excel file which is locked
Excel LookUp Range
Located in
- Rendered document content
] Excel Lookup Range Option Look in (Dropdown List) - Select type of value to look up into range that has been selected: Formulas, Values, Comments Output Result (String) - The cell where the specified
- Raw document content
with a certain value and returns them as String variables. [[image:image-20220505142148-1.png
…. E.g: [759682936] Excel Lookup Range **Option** * **Look in (Dropdown List) **- Select type of value to look up into range that has been selected: Formulas, Values, Comments **Output
next page »
Page
1
2
3
RSS feed for search on [select-item-1]