Search: excel-select-range

Append Range

Located in

Last modified by VuNH54 on 2023/04/19 16:55

Rendered document content: . E.g: “append excel range”
…
stored in a DataTable variable to the end of a specified Excel spreadsheet. If the sheet does not exist
…
of activity Workbook Path - The full path of the Excel spreadsheet that you want to use. If the Excel file
Title: Append Range
Location: Excel Activities
…
Append Range
Raw document content: . E.g: “append excel range” ))) {{velocity}} #if ($xcontext.action != 'export') (% class="akb-toc
…
variable to the end of a specified Excel spreadsheet. If the sheet does not exist, a new one is created
…
) == **In the body of activity** == * **Workbook Path ** - The full path of the Excel spreadsheet that you want

Excel Append Range

Located in

Last modified by VuNH54 on 2023/04/19 16:57

Rendered document content: . E.g: Excel Append Range
…
in a Data Table variable to the end of a specified Excel spreadsheet. (* is mandatory) In the body of activity Sheet Name - The name of the sheet in which to add the specified range. By default
Title: Excel Append Range
Location: Excel Append Range
…
Excel Activities
Raw document content: the name of the activity to organize and structure your code better. E.g: Excel Append Range
…
to the end of a specified Excel spreadsheet. [[image:image-20220505131238-1.jpeg]] (* is mandatory) == **In the body of activity** == * **Sheet Name** - The name of the sheet in which to add the specified range

Excel Application Scope

Located in

Last modified by VuNH54 on 2023/04/19 16:56

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
…
RCA.Activities.Excel.ExcelApplicationScope Description This activity allows to open an Excel
Title: Excel Application Scope
Location: Excel Activities
…
Excel Application Scope
Raw document content: )** - 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
…
)**- When selected, the Excel file is opened in the foreground while performing actions on it. When

Excel Copy Paste Range

Located in

Last modified by Giang Tran on 2022/05/13 04:28

Rendered document content: range. You can select between Value, Formula, Number Format, Cell Format and All.
…
RCA.Activities.Excel.ExcelCopyPasteRange Description This activity allows to copy a range
…
, this is filled in with "Sheet1." Only String variables and strings are supported. E.g: “Sheet name” Source Range
Title: Excel Copy Paste Range
Location: Excel Copy Paste Range
…
Excel Activities
Raw document content: )** - A dropdown specifying what additional data to copy for the specified range. You can select between Value
…
" %) ((( RCA.Activities.Excel.ExcelCopyPasteRange == **Description** == This activity allows to copy a range or sheet (including values, formulas
…
: “Sheet name” * **Source Range (String)*** - The range of the data you want to copy. This field supports

Excel Delete Range

Located in

Last modified by Giang Tran on 2022/05/13 04:31

Rendered document content: RCA.Activities.Excel.ExcelDeleteRange Description This activity allows deleting a specified range in an Excel workbook. Can also be used to shift an entire row or column by using the ShiftCells
…
variables and strings are supported. E.g: “Employee Data” Range (String)* - The range you want to delete
Title: Excel Delete Range
Location: Excel Delete Range
…
Excel Activities
Raw document content: " %) ((( RCA.Activities.Excel.ExcelDeleteRange == **Description** == This activity allows deleting a specified range in an Excel workbook
…
Data” * **Range (String)* **- The range you want to delete. This field supports only strings
…
Range **Options** * **ShiftCells (Checkbox) **- If you check it, cell formatting is shifted

Excel Insert Image

Located in

Last modified by VuNH54 on 2023/04/19 17:20

Rendered document content: to specified Excel Sheets. This only can be used in Excel Application Scope Activity. (* is mandatory
…
\sky.png” Sheet name (String) - The sheet that you want to display. E.g: “ThisIsSheetName” Range (String) - The range you want to add image to. E.g: “K1:L1” Properties Input Image path (String)* - Input the full
Title: Excel Insert Image
Location: Excel Activities
…
Excel Insert Image
Raw document content: " %) ((( RCA.Activities.Excel.ExcelInsertImage == **Description** == This activity allows you to add images to specified Excel Sheets. This only can be used in Excel Application Scope Activity. (% class="wikigeneratedid" id="H
…
) **- The sheet that you want to display. E.g: “ThisIsSheetName” * **Range (String) **- The range you want to add

Excel Insert Rows

Located in

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 in Excel Application Scope Activity. (* for mandatory) In the body of the activity Sheet name
…
) - 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 Activities
…
Excel Insert Rows
Raw document content: in a table, range, or sheet at the specified location. This only can be used in Excel Application Scope
…
: “Employee Name” * **Number of row (Int) **- Number of rows you want to insert in Excel sheet E.g: 5

Excel Read Cell

Located in

Last modified by Giang Tran on 2022/05/13 06:23

Rendered document content: RCA.Activities.Excel.ExcelReadCell Description This activity allows to read value of an Excel cell and store it in a variable. It is only be used inside the Excel Application Scope activity
…
to be read. If there is no amendment, “Sheet1” is automatically selected. “Cell” - Specified cell need has
Title: Excel Read Cell
Location: Excel Activities
…
Excel Read Cell
Raw document content: " %) ((( RCA.Activities.Excel.ExcelReadCell == **Description** == This activity allows to read value of an Excel cell and store 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

Excel Read Range

Located in

Last modified by VuNH54 on 2023/04/20 09:37

Rendered document content: of an Excel range and store it in a DataTable variable. If the range is not specified, the whole spreadsheet is read. If the range is specified as a cell, the whole spreadsheet starting from that cell is read. Can only be used in the Excel Application Scope activity. (* is mandatory) In the body of activity
Title: Excel Read Range
Location: Excel Read Range
…
Excel Activities
Raw document content: " %) ((( RCA.Activities.Excel.ExcelReadRange == **Description** == This activity allows you to read the value of an Excel range and store it in a DataTable variable. If the range is not specified, the whole spreadsheet is read. If the range is specified as a cell, the whole spreadsheet starting from that cell is read. Can only be used in the Excel Application

Excel Select Range

Located in

Last modified by Giang Tran on 2022/05/13 06:26

Rendered document content: a specified range from an Excel spreadsheet, in order to perform further actions. (* for mandatory) 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
…
Excel Activities
Raw document content: " %) ((( RCA.Activities.Excel.ExcelSelectRange == **Description** == The activity allows you to select and execute a specified range from
…
which to select the specified range. By default, this is filled in with "Sheet1". Only String variables and strings are supported. * **Range (String)*** - The range to be selected. Only String variables