Search: excel-save-workbook

) In the body of activity Workbook Path - The path of the Excel file you want to write to. E.g: “C:\FolderName

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

, as a DataTable variable. Only DataTable variables are supported. == **Properties** == **Input** * **Workbook

. (* for mandatory) In the body of activity Workbook Path - The path of the Excel file you want to use. E.g: “C

to write to. String supported only. E.g: “A20” Properties Input Workbook Path (String)* - The path of the Excel file you want to use. E.g: “C:\FolderName\ClientList.xlsx” Sheet name (String)* - The sheet you

Excel Activities

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

-1.jpeg]] (* for mandatory) == **In the body of activity** == * **Workbook Path** - The path of the Excel file you want to use. E.g: “C:\FolderName\ClientList.xlsx” * **Sheet name** - The sheet you want

range are overwritten. Changes are immediately saved. Can only be used in the Excel Application Scope

of the activity to organize and structure your code better. E.g: Write Range Excel Options Add Headers (Checkbox

Excel Write Range

Excel Activities

Excel Write Range

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

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

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

 - The Excel cell or range that you want to write to. If the range isn't specified, the whole spreadsheet

Excel Write Cell

Excel Activities

Excel Write Cell

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

: “ClientName” * **Cell** - The Excel cell or range that you want to write to. If the range isn't specified

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

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

Excel Save As Workbook

Excel Save As Workbook

Excel Activities

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

" %) ((( 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. [[image:image-20220505135028-1.jpeg]] (* for mandatory

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

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

Excel Read Range

Excel Activities

Excel Read Range

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

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

workbook and provides a scope for Excel Activities. (* for mandatory) In the body of the activity Workbook Path (String) - The path of the Excel file you want to read. E.g: “C:\FolderName\Contacts.xlsx

(String) - The password required for editing password protected Excel workbooks, if necessary. Only String

Excel Application Scope

Excel Activities

Excel Application Scope

" %) ((( RCA.Activities.Excel.ExcelApplicationScope == **Description** == This activity allows to open an Excel workbook and provides a scope

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

protected Excel workbooks, if necessary. Only String variables and strings are supported. * **Workbook Path

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

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

Excel Activities

) == **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

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

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

RCA.Activities.Excel.ReadRange Description This activity allows you to read the Excel range

specified, the whole spreadsheet will be read. E.g: "A1:B2" Properties Input Workbook Path (String

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

or graphs from a specified Excel file as images. (* for mandatory) Properties Input Image Format (DropDownList)* - Select the file type that you want to save the exported chart/graph as. It contains 3 types: Png, Bmp and Jpg. Name Contains (String)* - The name of the chart. E.g: “Chart sale” Path to Save

Excel Activities

Excel file as images. (% class="wikigeneratedid" id="H" %) [[image:image-20220505134428-1.jpeg

type that you want to save the exported chart/graph as. It contains 3 types: Png, Bmp and Jpg. * **Name Contains (String)*** - The name of the chart. E.g: “Chart sale” * **Path to Save (String