Search: excel-select-range

Last modified by admin on 2022/04/24 04:58

Results 41 - 47 of 47 « previous page Page 1 2 3 4 5

Excel LookUp Range

Last modified by Giang Tran on 2022/05/13 06:22
Rendered document content
] 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
Title
Excel LookUp Range
Location
Excel LookUp Range
Excel Activities
Raw document content
. E.g: [759682936] 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
" %) ((( RCA.Activities.Excel.ExcelLookUpRange == **Description** == Searches in a specified range for the coordinates of a cell

Excel Insert Rows

Last modified by Giang Tran on 2022/05/13 06:22
Rendered document content
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
Title
Excel Insert Rows
Location
Excel Activities
Excel Insert Rows
Raw document content
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 Insert Or Delete Rows

Last modified by Giang Tran on 2022/05/13 06:19
Rendered document content
or removal begins. By default, this is filled in with 1. E.g: 2 Input Change Mode (Dropdown List) - Selects
edit the name of the activity to organize and structure your code better. E.g: [038325762] Excel Insert
Title
Excel Insert Or Delete Rows
Location
Excel Activities
Excel Insert Or Delete Rows
Raw document content
, this is filled in with 1. E.g: 2 **Input** * **Change Mode (Dropdown List) **- Selects whether
. E.g: [038325762] Excel Insert Or Delete Rows **Options** * **CopyOrigin (Dropdown List

Excel Delete Range

Last modified by Giang Tran on 2022/05/13 04:31
Rendered document 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
variables and strings are supported. E.g: “Employee Data” Range (String)* - The range you want to delete
Title
Excel Delete Range
Location
Excel Delete Range
Excel Activities
Raw document content
" %) ((( RCA.Activities.Excel.ExcelDeleteRange == **Description** == This activity allows deleting a specified range in an Excel workbook
Data” * **Range (String)* **- The range you want to delete. This field supports only strings
Range **Options** * **ShiftCells (Checkbox) **- If you check it, cell formatting is shifted

Excel Copy Paste Range

Last modified by Giang Tran on 2022/05/13 04:28
Rendered document content
range. You can select between Value, Formula, Number Format, Cell Format and All.
RCA.Activities.Excel.ExcelCopyPasteRange Description This activity allows to copy a range
, this is filled in with "Sheet1." Only String variables and strings are supported. E.g: “Sheet name” Source Range
Title
Excel Copy Paste Range
Location
Excel Copy Paste Range
Excel Activities
Raw document content
)** - A dropdown specifying what additional data to copy for the specified range. You can select between Value
" %) ((( RCA.Activities.Excel.ExcelCopyPasteRange == **Description** == This activity allows to copy a range or sheet (including values, formulas
: “Sheet name” * **Source Range (String)*** - The range of the data you want to copy. This field supports

Release Notes

Last modified by Nga Nguyen on 2022/05/13 04:21
Rendered document content
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
Raw document content
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

[1] Release Notes

Last modified by Nga Nguyen on 2022/05/13 03:20
Rendered document content
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
Location
Excel Activities
Raw document content
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
RSS feed for search on [excel-select-range]
Created by admin on 2022/04/17 14:38