Search: excel-save-workbook

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

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

in the workbook where the change must be made. E.g: "Sheet1" Properties Destination Number of rows (Int32

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

edit the name of the activity to organize and structure your code better. E.g: [038325762] Excel Insert

Excel Insert Or Delete Rows

Excel Activities

Excel Insert Or Delete Rows

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

. E.g: [038325762] Excel Insert Or Delete Rows **Options** * **CopyOrigin (Dropdown List

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

of the sheet in the workbook where the change must be made. E.g: "Sheet1" Value (String) - The value that you

] Excel Lookup Range Option Look in (Dropdown List) - Select type of value to look up into range

Excel LookUp Range

Excel Activities

Excel LookUp Range

in the workbook where you want to search. E.g: "Sheet1" * **Range (String)*** - The range where you want

in the workbook where the change must be made. E.g: "Sheet1" * **Value (String)** - The value that you want

. E.g: [759682936] Excel Lookup Range **Option** * **Look in (Dropdown List) **- Select type

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

to organize and structure your code better. E.g: [464936660] Excel Remove Duplicates Range

Excel Remove Duplicates Range

Excel Activities

Excel Remove Duplicates Range

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

. E.g: [464936660] Excel Remove Duplicates Range ))) {{velocity}} #if ($xcontext.action != 'export

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

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

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

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

RCA.Activities.Excel.ExcelGetWorkbookSheet Description This activity allows you to look for a sheet based on its index and returns its name as a String variable. be used in Excel Application Scope

code better. E.g: Get Workbook Sheet Output Sheet (String) - List of string that contains sheet names

Excel Get Workbook Sheet

Excel Get Workbook Sheet

Excel Activities

and returns its name as a String variable. be used in Excel Application Scope Activity. [[image:image

. You can edit the name of the activity to organize and structure your code better. E.g: Get Workbook

RCA.Activities.Excel.ExcelGetWorkbookSheets Description This activity allows you to look for a sheet based on its index and returns its name as a String variable. This only can be used in Excel

. E.g: Get Workbook Sheets Table of Content Output Sheet (List< String >) - List of string

Excel Get Workbook Sheets

Excel Get Workbook Sheets

Excel Activities

and returns its name as a String variable. This only can be used in Excel Application Scope Activity

and structure your code better. E.g: Get Workbook Sheets ))) (% class="akb-toc" %) ((( (% class="akb-toc-title

Workbook. This only can be used in Excel Application Scope Activity. (* for mandatory) Properties

of the activity to organize and structure your code better. E.g: Close Workbook Use Workbook Workbook (WorkbookApplication)* - The workbook that you want to close. It can be an output from Excel Application Scope or any

Excel Close Workbook

Excel Close Workbook

Excel Activities

" %) ((( RCA.Activities.Excel.ExcelCloseWorkbook == **Description** == The activity allows you to close an open Workbook. This only can be used in Excel Application Scope Activity. [[image:image-20220505135216-1.jpeg]] (* for mandatory

can edit the name of the activity to organize and structure your code better. E.g: Close Workbook