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

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

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

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

. 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.

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