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
- 25Activities
- 1akaBot Studio
Last author
- 11Giang Tran
- 11VuNH54
- 2Nga Nguyen
- 2admin
Last modification date
Creation date
Object type
Uploaded by
- 22Giang Tran
- 1VuNH54
Upload date
Excel Read Range
Located in
- 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
…Range (String)* - The range that you want to read. If the range isn't specified, the whole spreadsheet
- 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
Activities
Located in
- Rendered document content
LookUp Range Excel Read Cell Excel Read Range Excel Remove Duplicates Range Excel Save As Workbook Excel
…Write Cell Excel Write Range Execute Macro Export Chart Read Column Read Range Read Row Write Cell Write
…Append Range Excel Append Range Excel Application Scope Excel Close Workbook Excel Copy Paste
- Location
Excel Activities
- Raw document content
/]] * [[Excel Read Range>>url:https://docs.akabot.com/bin/view/Activities/Excel%20Activities/Activities/Excel
…%20Column/]] * [[Read Range>>url:https://docs.akabot.com/bin/view/Activities/Excel%20Activities/Activities
…/Excel%20Activities/Activities/Append%20Range/]] * [[Excel Append Range>>url:https://docs.akabot.com/bin
Read Range
Located in
- Rendered document content
RCA.Activities.Excel.ReadRange Description This activity allows you to read the Excel range
…Workbook Path (String)* - The path of the Excel file you want to read. E.g: “C:\FolderName\SaleReport.xlsx” Sheet name (String)* - The sheet you want to read. E.g: "Sheet1" Range - Range of the data. If it isn’t
- Title
Read Range
- Location
Read Range
…Excel Activities
- Raw document content
" %) ((( 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
Excel Activities
Located in
- Rendered document content
The Excel Activities offers deep integration with Microsoft Excel and ships with a number of activities that automate the tasks you perform in Excel. These activities enable the robots to: Read information from a cell, columns, rows or ranges, and write to other spreadsheets or workbooks. Execute macros
- Title
Excel Activities
- Location
Excel Activities
- Raw document content
The Excel Activities offers deep integration with Microsoft Excel and ships with a number of activities that automate the tasks you perform in Excel. These activities enable the robots to: * ((( Read information from a cell, columns, rows or ranges, and write to other spreadsheets or workbooks. ))) * Execute
Excel Read Cell
Located in
- Rendered document content
RCA.Activities.Excel.ExcelReadCell Description This activity allows to read value of an Excel cell and store it in a variable. It is only be used inside the Excel Application Scope activity
…to be read. If there is no amendment, “Sheet1” is automatically selected. “Cell” - Specified cell need has
- Title
Excel Read Cell
- Location
Excel Read Cell
…Excel Activities
- Raw document content
" %) ((( RCA.Activities.Excel.ExcelReadCell == **Description** == This activity allows to read value of an Excel cell and store it in a variable. It is only be used inside the Excel Application Scope activity. [[image:image-20220505112903-1
…of the sheet contains the cell which is aimed to be read. If there is no amendment, “Sheet1” is automatically
Excel Append Range
Located in
- 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 Select Range
Located in
- 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. By default, this is filled in with "Sheet1". Only String variables and strings are supported. Range (String
- 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 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
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
next page »
Page
1
2
3
RSS feed for search on [excel-read-range]