Search: excel-get-workbook-sheets

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

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

) 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

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 - The path of the Excel file you want to write to. E.g: “C:\FolderName\ClientList.xlsx” Sheet name - The name of the sheet in which the range that you want to write to is. By default

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

Excel Activities

-20220505135914-1.jpeg]] (* for mandatory) == **In the body of activity** == * **Workbook Path** - The path of the Excel file you want to write to. E.g: “C:\FolderName\ClientList.xlsx” * **Sheet name** - The name of the sheet in which the range that you want to write to is. By default, this is filled in with "Sheet1." E.g

) In the body of activity Sheet name (String)* - The name of the sheet in the workbook where you want to search

(String)* - The range where you want to perform the search. E.g: "A1:H5" Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" Value (String) - The value that you

Excel LookUp Range

Excel Activities

Excel LookUp Range

]] (* for mandatory) == **In the body of activity** == * **Sheet name (String)*** - The name of the sheet in the workbook where you want to search. E.g: "Sheet1" * **Range (String)*** - The range where you want

where you want to perform the search. E.g: "A1:H5" * **Sheet name (String)*** - The name of the sheet

or removal begins. E.g: 2 Sheet name (String)* - The name of the sheet in the workbook where the change must

columns to the document. ・Delete: Remove columns from the document. Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" Misc Public (Boolean) - Check

Excel Insert Or Delete Columns

Excel Activities

Excel Insert Or Delete Columns

**: Remove columns from the document. * **Sheet name (String)*** - The name of the sheet in the workbook

)** - The column where the insertion or removal begins. E.g: 2 * **Sheet name (String)*** - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" == **Properties** == **Destination** * **Number

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

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

or removal begins. By default, this is filled in with 1. E.g: 2 Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" Properties Destination Number of rows (Int32

Excel Insert Or Delete Rows

Excel Activities

Excel Insert Or Delete Rows

)** - The row where the insertion or removal begins. By default, this is filled in with 1. E.g: 2 * **Sheet name (String)*** - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1

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