Search: excel-get-workbook-sheets

position in the table. (* for 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" Table name (String) - Table name you

) - Position you want to add. Sheet name (String)* - The name of the sheet in the workbook where the change

Excel Insert Columns Table

Excel Activities

Excel Insert Columns Table

-20220505141633-1.png]] (* for 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" * **Table name (String

(String)*** - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" * **Table

) 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

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 you want

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

) 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

that are duplicated in a specified range. (*for 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" Range (String

of the sheet in the workbook where the change must be made. E.g: "Sheet1" Misc Public (Boolean) - Check

Excel Remove Duplicates Range

Excel Activities

Excel Remove Duplicates Range

. [[image:image-20220505141832-1.png]] (*for 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

. E.g: "A1:H5" * **Sheet name (String)*** - The name of the sheet in the workbook where the change must

into a specified spreadsheet cell or a range. If the sheet does not exist, a new one is created. (* for mandatory) In the body of activity Workbook Path - The path of the Excel file you want to use. E.g: “C

of the Excel file you want to use. E.g: “C:\FolderName\ClientList.xlsx” Sheet name (String)* - The sheet you

Excel Activities

of the Excel file you want to use. E.g: “C:\FolderName\ClientList.xlsx” * **Sheet name** - The sheet you want

: “A20” == **Properties** == **Input** * **Workbook Path (String)*** - The path of the Excel file you

spreadsheet cell or a range. If the sheet does not exist, a new one is created. [[image:image-20220505135743

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

stored in a DataTable variable to the end of a specified Excel spreadsheet. If the sheet does not exist

of activity Workbook Path - The full path of the Excel spreadsheet that you want to use. If the Excel file

variables. Properties Input Workbook Path (String)* - The full path of the Excel spreadsheet that you

Excel Activities

variable to the end of a specified Excel spreadsheet. If the sheet does not exist, a new one is created

) == **In the body of activity** == * **Workbook Path ** - The full path of the Excel spreadsheet that you want to use. If the Excel file to be used is located in the project folder, its relative path can be used

of worksheets (Sheets) from a specified workbook (Workbook). Read Cell: Reads the value of an Excel cell

the same sheet. Copy Sheet: Copies a sheet from a specified workbook and pastes it to another specified

a range of cell data (Range) from a specified workbook (Workbook) worksheet (SheetName). Delete Sheet

a specified workbook (**Workbook**) worksheet (**SheetName**). * Delete Sheet: Deletes the specified sheet

. * Get Cell Color: Extracts the background color of a cell and saves it as a Color variable * Get sheets: Uses the Microsoft Graph Get worksheet API to retrieve and return an array of worksheets (**Sheets

. E.g: [482156710] Get Excel Column Name Output Result (String) - Stores column name in a string

Get Excel Column Name

Get Excel Column Name

Excel Activities

] Get Excel Column Name **Output** * **Result (String) **- Stores column name in a string variable.

RCA.Activities.Excel.ExcelSaveAsWorkbook Description The activity allows you to save changes as a new file. This only can be used in Excel Application Scope Activity. (* for mandatory) In the body

code better. E.g: Save as Workbook Options File Format (DropDown list box) - You can choose different

Excel Save As Workbook

Excel Save As Workbook

Excel Activities

be used in Excel Application Scope Activity. [[image:image-20220505135028-1.jpeg]] (* for mandatory

of the activity to organize and structure your code better. E.g: Save as Workbook **Options** * **File Format