Search: excel-write-range

to insert one or more rows in a table, range, or sheet at the specified location. This only can be used in Excel Application Scope Activity. (* for mandatory) In the body of the activity Sheet name

) - Number of rows you want to insert in Excel sheet E.g: 5 Row position (Int) - Position where the rows

Excel Insert Rows

Excel Activities

Excel Insert Rows

in a table, range, or sheet at the specified location. This only can be used in Excel Application Scope

: “Employee Name” * **Number of row (Int) **- Number of rows you want to insert in Excel sheet E.g: 5

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

RCA.Activities.Excel.ExcelLookUpRange Description Searches in a specified range

. E.g: "Sheet1" Range (String)* - The range where you want to perform the search. E.g: "A1:H5" Value

Excel LookUp Range

Excel LookUp Range

Excel Activities

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

" %) ((( RCA.Activities.Excel.ExcelLookUpRange == **Description** == Searches in a specified range for the coordinates of a cell

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

RCA.Activities.Excel.ExelSetBorder Description The activity allows you to set the borders through different ranges in Excel. This only can be used in Excel Application Scope Activity. (* is mandatory

. E.g: “Employee Infomation” Range (String)* - The Range that you want to border. E.g: “A1:K10” Misc

Excel Set Border

Excel Activities

Excel Set Border

" %) ((( RCA.Activities.Excel.ExelSetBorder == **Description** == The activity allows you to set the borders through different ranges in Excel. This only can be used in Excel Application Scope Activity. (% class="wikigeneratedid" id="H

Infomation” * **Range (String)*** - The Range that you want to border. E.g: “A1:K10” **Misc

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

that are duplicated in a specified range. (*for 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" Range (String

Excel Remove Duplicates Range

Excel Remove Duplicates Range

Excel Activities

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

" %) ((( RCA.Activities.Excel.ExcelRemoveDuplicatesRange == **Description** == Deletes all the rows that are duplicated in a specified range

" * **Range (String)** - The range from which you want to remove duplicate rows. E.g: "A1:H5

a specified range from an Excel spreadsheet, in order to perform further actions. (* for mandatory) Properties Input Sheet name (String) - The name of the sheet from which to select the specified range. By default, this is filled in with "Sheet1". Only String variables and strings are supported. Range (String

Excel Select Range

Excel Select Range

Excel Activities

" %) ((( RCA.Activities.Excel.ExcelSelectRange == **Description** == The activity allows you to select and execute a specified range from an Excel spreadsheet, in order to perform further actions. [[image:image-20220505133120-1.jpeg

which to select the specified range. By default, this is filled in with "Sheet1". Only String variables

RCA.Activities.Excel Version 2.1.1.0 Bugs fixed [ExcelApplicationScope]Edit message when excel file is set password protected sheet. [ExportChart]Export chart missing when name file excel has chart

characters. [ExcelApplicationScope] A loop opens Excel file in the background. Even though the workflow has

when excel file is set password protected sheet. * [ExportChart]Export chart missing when name file excel has chart name same. * [ExcelApplicationScope] At Textbox[Designer], change length when input more than 200 characters. * [ExcelApplicationScope] A loop opens Excel file in the background. Even though

RCA.Activities.Excel Version 2.1.1.0 Bugs fixed [ExcelApplicationScope]Edit message when excel file is set password protected sheet. [ExportChart]Export chart missing when name file excel has chart

characters. [ExcelApplicationScope] A loop opens Excel file in the background. Even though the workflow has

Excel Activities

when excel file is set password protected sheet. * [ExportChart]Export chart missing when name file excel has chart name same. * [ExcelApplicationScope] At Textbox[Designer], change length when input more than 200 characters. * [ExcelApplicationScope] A loop opens Excel file in the background. Even though

is a solution for application integration, business processes automation. It provides a wide range of activities

automation projects. The activities are grouped into different categories such as: Excel, XML, ControlFlow

. The activities are grouped in different categories such as: Flow chart, Control Flow, Primitives, Core, Excel

a wide range of activities to model almost of the business processes within one organization – from

into different categories such as: Excel, XML, ControlFlow, Primitives, Care, HTTP... |4|Designer|Display you

]] The activities are grouped in different categories such as: Flow chart, Control Flow, Primitives, Core, Excel

the information from a specified Excel workbook cell range for use in other activities, such as Write Range. Read

 Use Excel File activity or with the Project Notebook. Write Range: Writes a DataTable variable

, and stores it in an IEnumerable<object> variable. Rename sheet: Renames a sheet in an Excel file Write Cell

the information from a specified Excel workbook cell range for use in other activities, such as Write Range

for a parent Use Excel File activity or with the Project Notebook. * Write Range: Writes a DataTable variable

, and stores it in an IEnumerable<object> variable. * Rename sheet: Renames a sheet in an Excel file * Write

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

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

. E.g: “A10” Data Table - The data that you want to write to the specified range, as a DataTable

Excel Write Range

Excel Write Range

Excel Activities

** * **Data Table (DataTable)*** - The data that you want to write to the specified range, as a DataTable

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

" %) ((( RCA.Activities.Excel.ExcelWriteRange == **Description** == This activity allows you to write the data from a DataTable variable