Search: excel-select-range

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

Results 1 - 10 of 47 next page » Page 1 2 3 4 5

Excel Select Range

Last modified by Giang Tran on 2022/05/13 06:26
Rendered document content
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
)* - The range to be selected. Only String variables and strings are supported. E.g: “A1:K10” Misc Public
Title
Excel Select Range
Location
Excel Select Range
Excel Activities
Raw document content
" %) ((( RCA.Activities.Excel.ExcelSelectRange == **Description** == The activity allows you to select and execute a specified range from
which to select the specified range. By default, this is filled in with "Sheet1". Only String variables and strings are supported. * **Range (String)*** - The range to be selected. Only String variables

Activities

Last modified by admin on 2022/07/01 15:42
Rendered document content
Save Workbook Excel Select Range Excel Select Sheet Excel Set Border Excel Set Range Color Excel
Append Range Excel Append Range Excel Application Scope Excel Close Workbook Excel Copy Paste Range Excel Copy Sheet Excel Delete Range Excel Get Workbook Sheet Excel Get Workbook Sheets Excel
Location
Excel Activities
Raw document content
%20Save%20Workbook/]] * [[Excel Select Range>>url:https://docs.akabot.com/bin/view/Activities/Excel
/Excel%20Activities/Activities/Append%20Range/]] * [[Excel Append Range>>url:https://docs.akabot.com/bin
/Excel%20Close%20Workbook/]] * [[Excel Copy Paste Range>>url:https://docs.akabot.com/bin/view/Activities

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 Write Range

Last modified by VuNH54 on 2023/04/20 10:42
Rendered document content
range are overwritten. Changes are immediately saved. Can only be used in the Excel Application Scope
of the activity to organize and structure your code better. E.g: Write Range Excel Options Add Headers (Checkbox) - When selected, column headers are also written to the specified range. By default, this check box
Title
Excel Write Range
Location
Excel Write Range
Excel Activities
Raw document content
Range Excel **Options** * **Add Headers (Checkbox) **- When selected, column headers are also written to the specified range. By default, this check box is not selected. ))) {{velocity}} #if ($xcontext.action
with the value specified in the Sheetname property. All cells within the specified range are overwritten. Changes

[1] Release Notes

Located in
Last modified by VuNH54 on 2023/09/08 14:41
Rendered document content
the information from a specified Excel workbook cell range for use in other activities, such as Write Range. Read
: Enters a text or a formula in a cell. The activity can be used with an Excel file selected for a parent Use Excel File activity or with the Project Notebook. Write Range: Writes a DataTable variable
Raw document content
the information from a specified Excel workbook cell range for use in other activities, such as Write Range
Cell: Enters a text or a formula in a cell. The activity can be used with an Excel file selected for a parent Use Excel File activity or with the Project Notebook. * Write Range: Writes a DataTable variable

Excel Read Range

Last modified by VuNH54 on 2023/04/20 09:37
Rendered document content
of an Excel range and store it in a DataTable variable. If the range is not specified, the whole spreadsheet is read. If the range is specified as a cell, the whole spreadsheet starting from that cell is read. Can only be used in the Excel Application Scope activity. (* is mandatory) In the body of activity
Title
Excel Read Range
Location
Excel Read Range
Excel Activities
Raw document content
" %) ((( RCA.Activities.Excel.ExcelReadRange == **Description** == This activity allows you to read the value of an Excel range and store it in a DataTable variable. If the range is not specified, the whole spreadsheet is read. If the range is specified as a cell, the whole spreadsheet starting from that cell is read. Can only be used in the Excel Application

Excel Append Range

Last modified by VuNH54 on 2023/04/19 16:57
Rendered document content
. E.g: Excel Append Range
in a Data Table variable to the end of a specified Excel spreadsheet. (* is mandatory) In the body of activity Sheet Name - The name of the sheet in which to add the specified range. By default
Title
Excel Append Range
Location
Excel Append Range
Excel Activities
Raw document content
the name of the activity to organize and structure your code better. E.g: Excel Append Range
to the end of a specified Excel spreadsheet. [[image:image-20220505131238-1.jpeg]] (* is mandatory) == **In the body of activity** == * **Sheet Name** - The name of the sheet in which to add the specified range

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 Select Sheet

Last modified by Giang Tran on 2022/05/13 06:27
Rendered document content
(String)* - The name of the sheet from which to select the specified range. By default, this is filled
RCA.Activities.Excel.ExcelSelectSheet Description The activity allows you to select and execute
. E.g: Select Sheet
Title
Excel Select Sheet
Location
Excel Select Sheet
Excel Activities
Raw document content
" %) ((( RCA.Activities.Excel.ExcelSelectSheet == **Description** == The activity allows you to select and execute a specified sheet
) == **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

Excel Remove Duplicates Range

Last modified by Giang Tran on 2022/05/13 06:24
Rendered document content
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
Title
Excel Remove Duplicates Range
Location
Excel Remove Duplicates Range
Excel Activities
Raw document content
. 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
next page » Page 1 2 3 4 5
RSS feed for search on [excel-select-range]
Created by admin on 2022/04/17 14:38