Search: excel-get-workbook-sheet

. E.g: Get Workbook Sheets Table of Content Output Sheet (List< String >) - List of string that contains sheet names. It is written by their index order. Should assign to a variable.

for a sheet based on its index and returns its name as a String variable. This only can be used in Excel

Excel Get Workbook Sheets

Excel Get Workbook Sheets

Excel Activities

and structure your code better. E.g: Get Workbook Sheets ))) (% class="akb-toc" %) ((( (% class="akb-toc-title

" %) ((( RCA.Activities.Excel.ExcelGetWorkbookSheets == **Description** == This activity allows you to look for a sheet based on its index and returns its name as a String variable. This only can be used in Excel Application Scope Activity

code better. E.g: Get Workbook Sheet Output Sheet (String) - List of string that contains sheet names

for a sheet based on its index and returns its name as a String variable. be used in Excel Application Scope Activity. (* for mandatory) Properties Input Index (Int)* - The index of the sheet that you want

Excel Get Workbook Sheet

Excel Get Workbook Sheet

Excel Activities

. You can edit the name of the activity to organize and structure your code better. E.g: Get Workbook

" %) ((( RCA.Activities.Excel.ExcelGetWorkbookSheet == **Description** == This activity allows you to look for a sheet based on its index and returns its name as a String variable. be used in Excel Application Scope Activity. [[image:image

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 Copy Sheet

Excel Activities

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

Workbook. This only can be used in Excel Application Scope Activity. (* for mandatory) Properties

of the activity to organize and structure your code better. E.g: Close Workbook Use Workbook Workbook (WorkbookApplication)* - The workbook that you want to close. It can be an output from Excel Application Scope or any

Excel Close Workbook

Excel Close Workbook

Excel Activities

" %) ((( RCA.Activities.Excel.ExcelCloseWorkbook == **Description** == The activity allows you to close an open Workbook. This only can be used in Excel Application Scope Activity. [[image:image-20220505135216-1.jpeg]] (* for mandatory

can edit the name of the activity to organize and structure your code better. E.g: Close Workbook

RCA.Activities.Excel.ExcelSaveAsWorkbook Description This activity allows you to save changes to the workbook. This only can be used in Excel Application Scope Activity. (* for mandatory) Properties

of the activity to organize and structure your code better. E.g: Excel Save Workbook

Excel Save Workbook

Excel Save Workbook

Excel Activities

" %) ((( RCA.Activities.Excel.ExcelSaveAsWorkbook == **Description** == This activity allows you to save changes to the workbook. This only can be used in Excel Application Scope Activity. [[image:image-20220505134823-1.jpeg

of this activity. You can edit the name of the activity to organize and structure your code better. E.g: Excel

a specified sheet, in order to perform further actions. (* for mandatory) Properties Input Sheet name (String)* - The name of the sheet from which to select the specified range. By default, this is filled

. E.g: Select Sheet

Excel Select Sheet

Excel Select Sheet

Excel Activities

" %) ((( RCA.Activities.Excel.ExcelSelectSheet == **Description** == The activity allows you to select and execute a specified sheet

) == **Properties** == **Input** * **Sheet name (String)* **- The name of the sheet from which to select

. You can edit the name of the activity to organize and structure your code better. E.g: Select Sheet

only be used in the Excel Application Scope activity. (* is mandatory) In the body of activity Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1

of an Excel range and store it in a DataTable variable. If the range is not specified, the whole spreadsheet

Excel Read Range

Excel Activities

Excel Read Range

** == * **Sheet name (String)*** - The name of the sheet in the workbook where the change must be made. E.g

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

as a cell, the whole spreadsheet starting from that cell is read. Can only be used in the Excel Application

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

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

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. (* is mandatory) In the body of the activity “Sheet Name” – Name of the sheet contains the cell which is aimed

Excel Read Cell

Excel Activities

Excel Read Cell

" %) ((( 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. [[image:image-20220505112903-1.jpeg]] (* is mandatory) == **In the body of the activity** == * **“Sheet Name”** – Name