Search: excel-delete-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
- 23Activities
- 1akaBot Studio
Last author
- 10Giang Tran
- 10VuNH54
- 2Nga Nguyen
- 2admin
Last modification date
Creation date
Object type
Uploaded by
- 20Giang Tran
- 1VuNH54
Upload date
Activities
Located in
- Rendered document content
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 Insert Columns Table Excel Insert Or Delete Columns Excel Insert Or Delete Rows Excel Insert Rows Excel
- Location
Excel Activities
- Raw document content
://docs.akabot.com/bin/view/Activities/Excel%20Activities/Activities/Excel%20Copy%20Sheet/]] * [[Excel Delete Range
…/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 and store in a DataTable variable. If the range isn’t specified, the whole spreadsheet starting from
…(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 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 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 Delete Range
Located in
- Rendered document content
RCA.Activities.Excel.ExcelDeleteRange Description This activity allows deleting a specified range
…variables and strings are supported. E.g: “Employee Data” Range (String)* - The range you want to delete
…. E.g: Delete Range Options ShiftCells (Checkbox) - If you check it, cell formatting is shifted
- 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
…the cells in the deleted range. The available options are ShiftUp, ShiftDown, EntireRow, and EntireColumn
Excel Insert Or Delete Rows
Located in
- Rendered document content
whether the activity adds or removes rows. ・Add: Add rows to the document. ・Delete: Remove rows from
…edit the name of the activity to organize and structure your code better. E.g: [038325762] Excel Insert Or Delete Rows Options CopyOrigin (Dropdown List) - There are two opitons for you to format the rows
- Title
Excel Insert Or Delete Rows
- Location
Excel Insert Or Delete Rows
…Excel Activities
- Raw document content
. E.g: [038325762] Excel Insert Or Delete Rows **Options** * **CopyOrigin (Dropdown List
…the activity adds or removes rows. **・Add**: Add rows to the document. **・Delete**: Remove rows from
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
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 Set Border
Located in
- Rendered document content
RCA.Activities.Excel.ExelSetBorder Description The activity allows you to set the borders through different ranges in Excel. This only can be used in Excel Application Scope Activity. (* is mandatory
…. E.g: “Employee Infomation” Range (String)* - The Range that you want to border. E.g: “A1:K10” Misc
- Title
Excel Set Border
- Location
Excel Activities
…Excel Set Border
- Raw document content
" %) ((( RCA.Activities.Excel.ExelSetBorder == **Description** == The activity allows you to set the borders through different ranges in Excel. This only can be used in Excel Application Scope Activity. (% class="wikigeneratedid" id="H
…Infomation” * **Range (String)*** - The Range that you want to border. E.g: “A1:K10” **Misc
next page »
Page
1
2
3
RSS feed for search on [excel-delete-range]