Search: excel-read-range
Last modified by admin on 2022/04/24 04:58
Refine your search
Select a category and activate filters on the current results
Location
Last author
- 14VuNH54
- 11Giang Tran
- 6admin
- 3Nga Nguyen
Creator
- 26Giang Tran
- 4admin
- 2VuNH54
- 1LongVA
- 1Nga Nguyen
Last modification date
Creation date
Object type
Uploaded by
- 22Giang Tran
- 3VuNH54
- 1LongVA
- 1Nga Nguyen
- 1admin
Upload date
Excel Write Range
Located in
- 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
…. E.g: “A10” Data Table - The data that you want to write to the specified range, as a DataTable
- 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
…with the value specified in the Sheetname property. All cells within the specified range are overwritten. Changes are immediately saved. Can only be used in the Excel Application Scope activities. [[image:image-20220505114134-2
Excel LookUp Range
Located in
- 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
…" %) ((( 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
Excel Delete Range
Located in
- 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 Remove Duplicates Range
Located in
- 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
Excel Set Range Color
Located in
- Rendered document content
of a specified cell or cell range using a Color variable. Can only be used within the Excel Application Scope
…that contains the cell you want to color. E.g: “Name of the sheet” Range (String)* - The range of data
…. E.g: Set Range Color
- Title
Excel Set Range Color
- Location
Excel Set Range Color
…Excel Activities
- Raw document content
" %) ((( RCA.Activities.Excel.ExcelSetRangeColor == **Description** == This activity allows changing color of a specified cell or cell range using a Color variable. Can only be used within the Excel Application Scope activity. [[image:image
…)* **- The name of the sheet that contains the cell you want to color. E.g: “Name of the sheet” * **Range
Excel Copy Paste Range
Located in
- Rendered document content
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 (String)* - The range of the data you want to copy. This field supports only strings and String variables
- Title
Excel Copy Paste Range
- Location
Excel Copy Paste Range
…Excel Activities
- Raw document content
" %) ((( 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 only strings and String variables. E.g: “Source range” **Misc** * **Public (Checkbox) **- Check
Excel Write Cell
Located in
- Rendered document content
- The Excel cell or range that you want to write to. If the range isn't specified, the whole spreadsheet is read. If the range is specified as a cell, the whole spreadsheet starting from that cell is read. Only
…: “Hello world” or “=B1+C2” Properties Input Cell (String)* - The Excel cell or range that you want
- Title
Excel Write Cell
- Location
Excel Activities
…Excel Write Cell
- Raw document content
: “ClientName” * **Cell** - The Excel cell or range that you want to write to. If the range isn't specified, the whole spreadsheet is read. If the range is specified as a cell, the whole spreadsheet starting from
…)*** - The Excel cell or range that you want to write to. If the range isn't specified, the whole spreadsheet
Excel Application Scope
Located in
- Rendered document content
Workbook Path (String) - The path of the Excel file you want to read. E.g: “C:\FolderName\Contacts.xlsx
…variables and strings are supported. Workbook Path (String)* - The path of the Excel file you want to read
…are disabled in the specified Excel file. No macros can be run. ・ReadFromExcelSettings - Reads the current
- Title
Excel Application Scope
- Location
Excel Activities
…Excel Application Scope
- Raw document content
of the activity** == * **Workbook Path (String)** - The path of the Excel file you want to read. E.g: “C
…(String)*** - The path of the Excel file you want to read. E.g: “C:\FolderName\Contacts.xlsx” * **Password
…macros are disabled in the specified Excel file. No macros can be run. ・ReadFromExcelSettings - Reads
Append Range
Located in
- Rendered document content
. E.g: “append excel range”
…stored in a DataTable variable to the end of a specified Excel spreadsheet. If the sheet does not exist
…of activity Workbook Path - The full path of the Excel spreadsheet that you want to use. If the Excel file
- Title
Append Range
- Location
Excel Activities
…Append Range
- Raw document content
. E.g: “append excel range” ))) {{velocity}} #if ($xcontext.action != 'export') (% class="akb-toc
…variable to the end of a specified Excel spreadsheet. If the sheet does not exist, a new one is created
…) == **In the body of activity** == * **Workbook Path ** - The full path of the Excel spreadsheet that you want
Excel Insert Image
Located in
- Rendered document content
to specified Excel Sheets. This only can be used in Excel Application Scope Activity. (* is mandatory
…\sky.png” Sheet name (String) - The sheet that you want to display. E.g: “ThisIsSheetName” Range (String) - The range you want to add image to. E.g: “K1:L1” Properties Input Image path (String)* - Input the full
- Title
Excel Insert Image
- Location
Excel Activities
…Excel Insert Image
- Raw document content
" %) ((( RCA.Activities.Excel.ExcelInsertImage == **Description** == This activity allows you to add images to specified Excel Sheets. This only can be used in Excel Application Scope Activity. (% class="wikigeneratedid" id="H
…) **- The sheet that you want to display. E.g: “ThisIsSheetName” * **Range (String) **- The range you want to add
« previous page
next page »
Page
1
2
3
4
RSS feed for search on [excel-read-range]