Search: excel-select-sheet

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

, and stores it in an IEnumerable<object> variable. Rename sheet: Renames a sheet in an Excel file Write Cell: Enters a text or a formula in a cell. The activity can be used with an Excel file selected for a parent

, and stores it in an IEnumerable<object> variable. * Rename sheet: Renames a sheet in an Excel file * Write Cell: Enters a text or a formula in a cell. The activity can be used with an Excel file selected

: === **1.  Sheets sub-package** === (% class="box" %) ((( * Add Delete Column: Adds blank columns

of an Excel row beginning from the cell specified in the StartingCell field: and stores it in an lEnumerable<object> variable. (* is mandatory) In the body of activity Sheet name - The sheet you want to read

, this is filled in with "A1". E.g: "A1" Properties Input Sheet name (String)* - The sheet you want to read. E.g

Excel Read Row

Excel Activities

Excel Read Row

the values of an Excel row beginning from the cell specified in the StartingCell field: and stores

of activity** == * **Sheet name** - The sheet you want to read. E.g: "Sheet1" * **Starting Cell** - The cell

" == **Properties** == **Input** * **Sheet name (String)*** - The sheet you want to read. E.g: "Sheet1

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

are supported. E.g: “C:\FolderName\ClientList.xlsx” Sheet Name - The name of the sheet in which to add

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

. If the starting cell isn't specified, the data is written starting from the A1 cell. If the sheet does not exist

range are overwritten. Changes are immediately saved. Can only be used in the Excel Application Scope activities. (* is mandatory) In the body of activity Sheet Name - The sheet you want to write

Excel Write Range

Excel Activities

Excel Write Range

Range Excel **Options** * **Add Headers (Checkbox) **- When selected, column headers are also written

, the data is written starting from the A1 cell. If the sheet does not exist, a new one is created

are immediately saved. Can only be used in the Excel Application Scope activities. [[image:image-20220505114134-2

) 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" Properties Input Sheet name (String)* - The sheet you want to read. E.g: "Sheet1

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

** * **Sheet name (String)*** - The sheet you want to read. E.g: "Sheet1" * **Starting Cell (String

) 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

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

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

into a specified spreadsheet cell or a range. If the sheet does not exist, a new one is created with the name specified in the Sheet Name property. If a value exists, it is overwritten. Changes are immediately saved. Can only be used in the Excel Application Scope activities. (* is mandatory) In the body

Excel Write Cell

Excel Activities

Excel Write Cell

spreadsheet cell or a range. If the sheet does not exist, a new one is created with the name specified in the Sheet Name property. If a value exists, it is overwritten. Changes are immediately saved. Can only be used in the Excel Application Scope activities. [[image:image-20220505113619-1.jpeg]] (* is mandatory

to specified Excel Sheets. This only can be used in Excel Application Scope Activity. (* is mandatory

\sky.png” Sheet name (String) - The sheet that you want to display. E.g: “ThisIsSheetName” Range (String

strings and String variables. E.g: “C:\FolderName\sky.png” Sheet name (String)* - The sheet that you want

Excel Insert Image

Excel Activities

Excel Insert Image

" %) ((( RCA.Activities.Excel.ExcelInsertImage == **Description** == This activity allows you to add images to specified Excel Sheets. This only can be used in Excel Application Scope Activity. (% class="wikigeneratedid" id="H

. This field accepts only strings and String variables. E.g: “C:\FolderName\sky.png” * **Sheet name (String

(* for mandatory) In the body of activity Sheet name - The sheet you want to read. E.g: "Sheet1" Starting Cell

" Properties Input Sheet name (String)* - The sheet you want to read. E.g: "Sheet1" Starting Cell (String

the name of the activity to organize and structure your code better. E.g: [482156710] Excel Read Column

Excel Read Column

Excel Activities

Excel Read Column

** == * **Sheet name** - The sheet you want to read. E.g: "Sheet1" * **Starting Cell** - The cell from which

" == **Properties** == **Input** * **Sheet name (String)*** - The sheet you want to read. E.g: "Sheet1

your code better. E.g: [482156710] Excel Read Column **Options** * **Preserve Format (Boolean

in a Data Table variable to the end of a specified Excel spreadsheet. (* is mandatory) In the body of activity Sheet Name - The name of the sheet in which to add the specified range. By default

 - The data to be added. This field supports only DataTable variables. Properties Input Sheet Name (String

Excel Append Range

Excel Activities

Excel Append Range

to the end of a specified Excel spreadsheet. [[image:image-20220505131238-1.jpeg]] (* is mandatory) == **In the body of activity** == * **Sheet Name** - The name of the sheet in which to add the specified range

. == **Properties** == **Input** * **Sheet Name (String)*** - The name of the sheet in which to add the specified