Search: excel-read-cell

LookUp Range Excel Read Cell Excel Read Range Excel Remove Duplicates Range Excel Save As Workbook Excel

Write Cell Excel Write Range Execute Macro Export Chart Read Column Read Range Read Row Write Cell Write

Append Range Excel Append Range Excel Application Scope Excel Close Workbook Excel Copy Paste

Excel Activities

://docs.akabot.com/bin/view/Activities/Excel%20Activities/Activities/Excel%20LookUp%20Range/]] * [[Excel Read Cell

/Activities/Read%20Row/]] * [[Write Cell>>url:https://docs.akabot.com/bin/view/Activities/Excel%20Activities

/]] * [[Excel Read Range>>url:https://docs.akabot.com/bin/view/Activities/Excel%20Activities/Activities/Excel

The Excel Activities offers deep integration with Microsoft Excel and ships with a number of activities that automate the tasks you perform in Excel. These activities enable the robots to: Read information from a cell, columns, rows or ranges, and write to other spreadsheets or workbooks. Execute macros

Excel Activities

Excel Activities

The Excel Activities offers deep integration with Microsoft Excel and ships with a number of activities that automate the tasks you perform in Excel. These activities enable the robots to: * ((( Read information from a cell, columns, rows or ranges, and write to other spreadsheets or workbooks. ))) * Execute

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

Excel Set Range Color

Excel Activities

Excel Set Range Color

" %) ((( 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

RCA.Activities.Excel.ReadRange Description This activity allows you to read the Excel range

that cell is read. This activity uses ClosedXML library (* for mandatory) In the body of activity Workbook Path (String)* - The path of the Excel file you want to read. E.g: “C:\FolderName\SaleReport.xlsx

Read Range

Excel Activities

Read Range

" %) ((( RCA.Activities.Excel.ReadRange == **Description** == This activity allows you to read the Excel range and store in a DataTable variable. If the range isn’t specified, the whole spreadsheet starting from that cell is read

) == **In the body of activity** == * **Workbook Path (String)*** - The path of the Excel file you want to read

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

Read Row

Excel Activities

Read Row

" %) ((( 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

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

Excel Delete Range

Excel Activities

Excel Delete Range

" %) ((( 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

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

Excel LookUp Range

Excel Activities

Excel LookUp Range

" %) ((( 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

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

Excel Set Border

Excel Activities

Excel Set Border

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

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

Excel Read Cell

Excel Read Cell

Excel Activities

" %) ((( 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

RCA.Activities.Excel Version 2.1.1.0 Bugs fixed [ExcelApplicationScope]Edit message when excel file is set password protected sheet. [ExportChart]Export chart missing when name file excel has chart

characters. [ExcelApplicationScope] A loop opens Excel file in the background. Even though the workflow has

when excel file is set password protected sheet. * [ExportChart]Export chart missing when name file excel has chart name same. * [ExcelApplicationScope] At Textbox[Designer], change length when input more than 200 characters. * [ExcelApplicationScope] A loop opens Excel file in the background. Even though