Search: excel-read-cell

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 Read Cell
…
Excel Activities
Raw document content: " %) ((( RCA.Activities.Excel.ExcelReadCell == **Description** == This activity allows to read value of an Excel cell and store
…
of the sheet contains the cell which is aimed 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

Located in

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

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

Located in

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

Rendered document content: RCA.Activities.Excel.ExcelSetRangeColor Description This activity allows changing color of a specified cell or cell range using a Color variable. Can only be used within the Excel Application Scope
…
that contains the cell you want to color. E.g: “Name of the sheet” Range (String)* - The range of data
Title: Excel Set Range Color
Location: Excel Activities
…
Excel Set Range Color
Raw document content: " %) ((( RCA.Activities.Excel.ExcelSetRangeColor == **Description** == This activity allows changing color of a specified cell or cell range using a Color variable. Can only be used within the Excel Application Scope activity. [[image:image
…
)* **- The name of the sheet that contains the cell you want to color. E.g: “Name of the sheet” * **Range

Located in

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

Rendered document content: in an Excel workbook. Can also be used to shift an entire row or column by using the ShiftCells
…
. E.g: Delete Range Options ShiftCells (Checkbox) - If you check it, cell formatting is shifted according to what is specified in the Shift Option property. If this box is unselected, only the cell data
Title: Excel Delete Range
Location: Excel Activities
…
Excel Delete Range
Raw document content: " %) ((( RCA.Activities.Excel.ExcelDeleteRange == **Description** == This activity allows deleting a specified range in an Excel workbook
…
Range **Options** * **ShiftCells (Checkbox) **- If you check it, cell formatting is shifted according to what is specified in the Shift Option property. If this box is unselected, only the cell data

Located in

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

Rendered document content: RCA.Activities.Excel.ExelSetBorder Description The activity allows you to set the borders through different ranges in Excel. This only can be used in Excel Application Scope Activity. (* is mandatory) Properties Input Sheet name (String)* - The name of the sheet that contains the cell you want to border
Title: Excel Set Border
Location: Excel Activities
…
Excel Set Border
Raw document content: in Excel. This only can be used in Excel Application Scope Activity. (% class="wikigeneratedid" id="H
…
name (String)* **- The name of the sheet that contains the cell you want to border. E.g: “Employee