Search: excel-write-cell

your processes are completed. Solution: You can write one unattended workflow to gather all

in reporting, as underlying data may change before all your processes are completed. Solution: You can write

%20Activities/Activities/Write%20CSV%20File/">Write CSV File</a> </div> </div> </div> <div

> </div> <div class="akb-card"> <div class="akb-card-title">Excel Avtivities</div> <div class="akb-card-body"> <div class="akb-link-list"> <a href="/bin/view/Activities/Excel

What's New [Added] Added Excel Set Range Format activity: This activity allows user to format cells and ranges according to a specific format. [Added] Screen Status Check Activity: This activity

and automate Excel tasks using Visual Basic for Applications. Insert VBA Activity: This activity allows you

** == * [Added] Added Excel Set Range Format activity: This activity allows user to format cells and ranges

for working with VBA code within your automation workflows, empowering you to customize and automate Excel

new VBA code into a workbook or a specific module. It helps you extend the functionality of your Excel

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) Properties Input Sheet name (String)* - The name of the sheet that contains the cell you want to border

Excel Set Border

Excel Activities

Excel Set Border

in Excel. This only can be used in Excel Application Scope Activity. (% class="wikigeneratedid" id="H

name (String)* **- The name of the sheet that contains the cell you want to border. E.g: “Employee

for the coordinates of a cell with a certain value and returns them as String variables. (* for mandatory

] Excel Lookup Range Option Look in (Dropdown List) - Select type of value to look up into range that has been selected: Formulas, Values, Comments Output Result (String) - The cell where the specified

Excel LookUp Range

Excel Activities

Excel LookUp Range

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

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

** * **Result (String) **- The cell where the specified value is found. ))) {{velocity

as a new file. This only can be used in Excel Application Scope Activity. (* for mandatory) In the body

file that you want to write over it. This field accepts only strings and String variables. E.g: “C

or click “…” button to choose an existed file that you want to write over it. This field accepts only

Excel Save As Workbook

Excel Activities

Excel Save As Workbook

be used in Excel Application Scope Activity. [[image:image-20220505135028-1.jpeg]] (* for mandatory

to choose an existed file that you want to write over it. This field accepts only strings and String

)*** - Input the full path of the file or click “…” button to choose an existed file that you want to write

RCA.Activities.Excel.ReadRange Description This activity allows you to read the Excel range

that cell is read. This activity uses ClosedXML library (* for mandatory) In the body of activity Workbook Path (String)* - The path of the Excel file you want to read. E.g: “C:\FolderName\SaleReport.xlsx

Excel Activities

" %) ((( RCA.Activities.Excel.ReadRange == **Description** == This activity allows you to read the Excel range and store in a DataTable variable. If the range isn’t specified, the whole spreadsheet starting from that cell is read

) == **In the body of activity** == * **Workbook Path (String)*** - The path of the Excel file you want to read

in an Excel workbook. Can also be used to shift an entire row or column by using the ShiftCells

. E.g: Delete Range Options ShiftCells (Checkbox) - If you check it, cell formatting is shifted according to what is specified in the Shift Option property. If this box is unselected, only the cell data

Excel Delete Range

Excel Activities

Excel Delete Range

" %) ((( RCA.Activities.Excel.ExcelDeleteRange == **Description** == This activity allows deleting a specified range in an Excel workbook

Range **Options** * **ShiftCells (Checkbox) **- If you check it, cell formatting is shifted according to what is specified in the Shift Option property. If this box is unselected, only the cell data

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