Search: excel-save-as-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

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

RCA.Activities.Excel.ExcelDeleteRange Description This activity allows deleting a specified range in an Excel workbook. Can also be used to shift an entire row or column by using the ShiftCells and ShiftOption property fields. (* for mandatory) Properties Input Sheet Name (String) - The name

Excel Delete Range

Excel Activities

Excel Delete Range

(% class="akb-page-with-toc" %) ((( (% class="akb-page-content" %) ((( RCA.Activities.Excel.ExcelDeleteRange == **Description** == This activity allows deleting a specified range in an Excel workbook. Can also be used to shift an entire row or column by using the ShiftCells and ShiftOption property

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

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

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