Search: excel-get-workbook-sheets

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

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

Excel Activities

/]] * [[Excel Get Workbook Sheet>>url:https://docs.akabot.com/bin/view/Activities/Excel%20Activities/Activities/Excel%20Get%20Workbook%20Sheet/]] * [[Excel Get Workbook Sheets>>url:https://docs.akabot.com/bin/view

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

RCA.Activities.Excel.ExecuteMacro Description This activity allows you to execute the macro within a workbook. The Workbook file needs to be a Macro-Enabled Workbook. Changes are immediately saved. Can only be used in the Excel Application Scope activity. (* for mandatory) Properties Common

Excel Activities

" %) ((( RCA.Activities.Excel.ExecuteMacro == **Description** == This activity allows you to execute the macro within a workbook. The Workbook file needs to be a Macro-Enabled Workbook. Changes are immediately saved. Can only be used in the Excel Application Scope activity. [[image:image-20220505134614-1.jpeg]] (* for mandatory

of a specified cell or cell range using a Color variable. Can only be used within the Excel Application Scope activity. (* for mandatory) Properties Input Sheet name (String)* - The name of the sheet 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

using a Color variable. Can only be used within the Excel Application Scope activity. [[image:image-20220505133337-1.jpeg]] (* for mandatory) == **Properties** == **Input** * **Sheet name (String)* **- The name of the sheet that contains the cell you want to color. E.g: “Name of the sheet” * **Range

Workbook Path (String)* - The path of the Excel file you want to read. E.g: “C:\FolderName\SaleReport.xlsx

) - The path of the Excel file you want to read. E.g: “C:\FolderName\SaleReport.xlsx” Sheet name (String

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

Excel Activities

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

: "A1:B2" == **Properties** == **Input** * **Workbook Path (String) **- The path of the Excel

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

) 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

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

Excel Activities

]] (*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” * **Sheet name (String)*** - The sheet

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

or graphs from a specified Excel file as images. (* for mandatory) Properties Input Image Format

(String)* - Directory to save file. E.g: “C:\DestinationSaveFolderName\” Sheet Name (String) - The name of the sheet that contains the chart you want to export. E.g: “SheetHasChartName” Misc Public (Checkbox

Excel Activities

Excel file as images. (% class="wikigeneratedid" id="H" %) [[image:image-20220505134428-1.jpeg

)* **- Directory to save file. E.g: “C:\DestinationSaveFolderName\” * **Sheet Name (String)** - The name of the sheet that contains the chart you want to export. E.g: “SheetHasChartName” **Misc** * **Public

or sheet (including values, formulas, table format, and cell format) and pastes it to another location in the current workbook or to a different workbook. (* for mandatory) Properties Copy to SpeadSheet

only strings and String variables. E.g: “E10” Destination Sheet (String)* - The sheet you want to paste

Excel Copy Paste Range

Excel Activities

Excel Copy Paste Range

" %) ((( RCA.Activities.Excel.ExcelCopyPasteRange == **Description** == This activity allows to copy a range or sheet (including values, formulas, table format, and cell format) and pastes it to another location in the current workbook or to a different workbook. [[image:image-20220505131502-1.jpeg]] (* for mandatory) == **Properties** == **Copy

in an Excel workbook. Can also be used to shift an entire row or column by using the ShiftCells and ShiftOption property fields. (* for mandatory) Properties Input Sheet Name (String) - The name of the sheet contains the data you want to delete. By default, this is filled in with "Sheet1." Only String

Excel Delete Range

Excel Activities

Excel Delete Range

(% class="akb-page-with-toc" %) ((( (% class="akb-page-content" %) ((( RCA.Activities.Excel.ExcelDeleteRange == **Description** == This activity allows deleting a specified range in an Excel workbook

** == **Input** * **Sheet Name (String)** - The name of the sheet contains the data you want to delete

Destination Destination File Path (String)* - The workbook where you want to copy the sheet. If this field is left empty, the sheet is copied in the current scope workbook. This field supports only strings

RCA.Activities.Excel.ExcelCopySheet Description This activity allows you to copy a sheet from

Excel Copy Sheet

Excel Activities

Excel Copy Sheet

" %) ((( RCA.Activities.Excel.ExcelCopySheet == **Description** == This activity allows you to copy a sheet from a specified workbook and paste it into another specified workbook. [[image:image-20220505131921-1.jpeg]] (* for mandatory

the sheet. If this field is left empty, the sheet is copied in the current scope workbook. This field