Search: excel-save-workbook

of the activity to organize and structure your code better. E.g: Excel Save Workbook

RCA.Activities.Excel.ExcelSaveAsWorkbook Description This activity allows you to save changes to the workbook. This only can be used in Excel Application Scope Activity. (* for mandatory) Properties

Excel Save Workbook

Excel Save Workbook

Excel Activities

" %) ((( RCA.Activities.Excel.ExcelSaveAsWorkbook == **Description** == This activity allows you to save changes to the workbook. This only can be used in Excel Application Scope Activity. [[image:image-20220505134823-1.jpeg

Save Workbook ))) {{velocity}} #if ($xcontext.action != 'export') (% class="akb-toc

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

RCA.Activities.Excel.ExecuteMacro Description This activity allows you to execute the macro within a workbook. The Workbook file needs to be a Macro-Enabled Workbook. Changes are immediately saved. Can only be used in the Excel Application Scope activity. (* for mandatory) Properties Common

Excel Activities

" %) ((( RCA.Activities.Excel.ExecuteMacro == **Description** == This activity allows you to execute the macro within a workbook. The Workbook file needs to be a Macro-Enabled Workbook. Changes are immediately saved. Can only be used in the Excel Application Scope activity. [[image:image-20220505134614-1.jpeg]] (* for mandatory

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

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

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

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

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