Search: excel-read-cell
Last modified by admin on 2022/04/24 04:58
Refine your search
Select a category and activate filters on the current results
Result type
- 13Document
- 8Attachment
Location
Last author
- 6Giang Tran
- 5VuNH54
- 2admin
Creator
- 9Giang Tran
- 2VuNH54
- 1LongVA
- 1admin
Last modification date
Creation date
Object type
Uploaded by
- 14Giang Tran
- 6VuNH54
- 1LongVA
- 1admin
Upload date
- Sort by:
- Relevance
Excel Read Cell
Located in
- 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
Excel Read Row
Located in
- Rendered document content
RCA.Activities.Excel.ExcelReadRow Description This activity allows you to reads the values of an Excel row beginning from the cell specified in the StartingCell field: and stores it in an lEnumerable
…can edit the name of the activity to organize and structure your code better. E.g: Excel Read Row
- Title
Excel Read Row
- Location
Excel Read Row
…Excel Activities
- Raw document content
the values of an Excel row beginning from the cell specified in the StartingCell field: and stores
…of activity** == * **Sheet name** - The sheet you want to read. E.g: "Sheet1" * **Starting Cell** - The cell
…. You can edit the name of the activity to organize and structure your code better. E.g: Excel Read Row
Excel Read Range
Located in
- 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
Excel Read Column
Located in
- Rendered document content
(* for mandatory) In the body of activity Sheet name - The sheet you want to read. E.g: "Sheet1" Starting Cell
…" Properties Input Sheet name (String)* - The sheet you want to read. E.g: "Sheet1" Starting Cell (String
…the name of the activity to organize and structure your code better. E.g: [482156710] Excel Read Column
- Title
Excel Read Column
- Location
Excel Read Column
…Excel Activities
- Raw document content
** == * **Sheet name** - The sheet you want to read. E.g: "Sheet1" * **Starting Cell** - The cell from which
…your code better. E.g: [482156710] Excel Read Column **Options** * **Preserve Format (Boolean
…RCA.Activities.Excel.ExcelReadColumn == **Description** == Read all data into column has
Read Column
Located in
- Rendered document content
) In the body of activity Workbook Path (String)* - The path of the Excel file you want to read. E.g: “C:\FolderName\SaleReport.xlsx” Sheet name (String)* - The sheet you want to read. E.g: "Sheet1" Starting Cell
…, this is filled in with "A1". E.g: "A1" Workbook Path (String)* - The path of the Excel file you want to read. E.g
- Title
Read Column
- Location
Excel Activities
…Read Column
- Raw document content
" %) ((( RCA.Activities.Excel.ReadColumn == **Description** == Reads the values from a column beginning with the cell specified
…to read. E.g: "Sheet1" * **Starting Cell (String)*** - The cell from which to start extracting the column
…** * **Sheet name (String)*** - The sheet you want to read. E.g: "Sheet1" * **Starting Cell (String
Read Row
Located in
- Rendered document content
RCA.Activities.Excel.ReadRow Description Reads the values from a row beginning with the cell
…) In the body of activity Workbook Path (String)* - The path of the Excel file you want to read. E.g: “C:\FolderName\SaleReport.xlsx” Sheet name (String)* - The sheet you want to read. E.g: "Sheet1" Starting Cell
- Title
Read Row
- Location
Excel Activities
…Read Row
- Raw document content
" %) ((( RCA.Activities.Excel.ReadRow == **Description** == Reads the values from a row beginning with the cell specified
…you want to read. E.g: "Sheet1" * **Starting Cell (String)*** - The cell from which to start
…** == **Input** * **Sheet name (String)*** - The sheet you want to read. E.g: "Sheet1" * **Starting Cell
Excel Set Range Color
Located in
- 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
Excel Delete Range
Located in
- 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
Excel LookUp Range
Located in
- Rendered document content
for the coordinates of a cell with a certain value and returns them as String variables. (* for mandatory
…] 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
- Title
Excel LookUp Range
- Location
Excel Activities
…Excel LookUp Range
- Raw document content
" %) ((( RCA.Activities.Excel.ExcelLookUpRange == **Description** == Searches in a specified range for the coordinates of a cell
…. E.g: [759682936] Excel Lookup Range **Option** * **Look in (Dropdown List) **- Select type
…** * **Result (String) **- The cell where the specified value is found. ))) {{velocity
Excel Set Border
Located in
- 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
next page »
Page
1
2
3
RSS feed for search on [excel-read-cell]