Search: excel-select-range

Save Workbook Excel Select Range Excel Select Sheet Excel Set Border Excel Set Range Color Excel

Append Range Excel Append Range Excel Application Scope Excel Close Workbook Excel Copy Paste Range Excel Copy Sheet Excel Delete Range Excel Get Workbook Sheet Excel Get Workbook Sheets Excel

Excel Activities

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

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

/Excel%20Close%20Workbook/]] * [[Excel Copy Paste Range>>url:https://docs.akabot.com/bin/view/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 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

/Activities/Append%20Range/">Append Range</a> <a href="/bin/view/Activities/Excel%20Activities/Activities/Excel%20Append%20Range/">Excel Append Range</a> <a href="/bin/view/Activities/Excel

/">CV Dropdown Select</a> <br> <a class="akb-more" href="/bin/view/Activities/Computer

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

Select File

Select File

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

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

. E.g: Set Range Color

Excel Set Range Color

Excel Set Range Color

Excel Activities

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

Options Add Headers - If you select this, the column headers from the specified spreadsheet range

(DataTable) - Stores the data extracted from the specified Excel range in a data table variable. Only data

Read Range

Excel Activities

Read Range

" %) ((( RCA.Activities.Excel.ReadRange == **Description** == This activity allows you to read the Excel range and store

. E.g: Read Range **Options** * **Add Headers **- If you select this, the column headers from the specified spreadsheet range are also extracted. By default, this check box is selected (set to True

) In the body of activity Workbook Path (String)* - The path of the Excel file you want to read. E.g: “C

in with "A1". E.g: "A1" Workbook Path (String)* - The path of the Excel file you want to read. E.g: “C

] Read Row Options Preserve Format (Boolean) - Selecting this check box keeps the formatting of the row

Excel Activities

]] (*for mandatory) == **In the body of activity** == * **Workbook Path (String)*** - The path of the Excel

". E.g: "A1" * **Workbook Path (String)*** - The path of the Excel file you want to read. E.g: “C

. E.g: [841596479] Read Row **Options** * **Preserve Format (Boolean) **- Selecting this check box

RCA.Activities.Excel.ExcelExportChart Description This activity allows you to export charts or graphs from a specified Excel file as images. (* for mandatory) Properties Input Image Format (DropDownList)* - Select the file type that you want to save the exported chart/graph as. It contains 3 types

Excel Activities

Excel file as images. (% class="wikigeneratedid" id="H" %) [[image:image-20220505134428-1.jpeg]] (* for mandatory) == **Properties** == **Input** * **Image Format (DropDownList)* **- Select the file

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

Excel Copy Paste Range

Excel Copy Paste Range

Excel Activities

)** - 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

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

Excel Delete Range

Excel Delete Range

Excel Activities

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