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

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

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

, this is filled in with "A1". E.g: "A1" Workbook Path (String)* - The path of the Excel file you want to read. E.g

Excel Activities

]] (* for mandatory) == **In the body of activity** == * **Workbook Path (String)*** - The path of the Excel file

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

) 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

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

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

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

Excel Insert Columns Table

Excel Activities

Excel Insert Columns Table

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

to organize and structure your code better. E.g: [028225900] Excel Insert Columns Table ))) {{velocity

) 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