Search: excel-select-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
- 29Activities
- 1akaBot Studio
Last author
- 14Giang Tran
- 12VuNH54
- 2Nga Nguyen
- 2admin
Last modification date
Creation date
Object type
Uploaded by
- 26Giang Tran
- 1VuNH54
Upload date
Activities
Located in
- 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 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 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
Read Range
Located in
- Rendered document content
RCA.Activities.Excel.ReadRange Description This activity allows you to read the Excel range
…Options Add Headers - If you select this, the column headers from the specified spreadsheet range
…(DataTable) - Stores the data extracted from the specified Excel range in a data table variable. Only data
- Title
Read Range
- Location
Excel Activities
…Read Range
- Raw document content
" %) ((( RCA.Activities.Excel.ReadRange == **Description** == This activity allows you to read the Excel range and store
…. E.g: Read Range **Options** * **Add Headers **- If you select this, the column headers from the specified spreadsheet range are also extracted. By default, this check box is selected (set to True
Read Row
Located in
- Rendered document content
) In the body of activity Workbook Path (String)* - The path of the Excel file you want to read. E.g: “C
…in with "A1". E.g: "A1" Workbook Path (String)* - The path of the Excel file you want to read. E.g: “C
…] Read Row Options Preserve Format (Boolean) - Selecting this check box keeps the formatting of the row
- Location
Excel Activities
- Raw document content
]] (*for mandatory) == **In the body of activity** == * **Workbook Path (String)*** - The path of the Excel
…". E.g: "A1" * **Workbook Path (String)*** - The path of the Excel file you want to read. E.g: “C
…. E.g: [841596479] Read Row **Options** * **Preserve Format (Boolean) **- Selecting this check box
Export Chart
Located in
- Rendered document content
RCA.Activities.Excel.ExcelExportChart Description This activity allows you to export charts or graphs from a specified Excel file as images. (* for mandatory) Properties Input Image Format (DropDownList)* - Select the file type that you want to save the exported chart/graph as. It contains 3 types
- Location
Excel Activities
- Raw document content
Excel file as images. (% class="wikigeneratedid" id="H" %) [[image:image-20220505134428-1.jpeg]] (* for mandatory) == **Properties** == **Input** * **Image Format (DropDownList)* **- Select the file
Excel Copy Paste Range
Located in
- 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
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 Insert Or Delete Rows
Located in
- 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 Insert Rows
Located in
- 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
next page »
Page
1
2
3
RSS feed for search on [excel-select-range]