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
Last author
- 11VuNH54
- 10Giang Tran
- 8admin
- 2Nga Nguyen
- 1LongVA
Creator
- 24Giang Tran
- 7admin
- 1LongVA
Last modification date
Creation date
Object type
Uploaded by
- 20Giang Tran
- 2LongVA
- 2admin
- 1VuNH54
Upload date
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 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
[1] Release Notes
Located in
- Rendered document content
workbook. If no other workbook is specified, it is copied to the source file. Delete Range: Uses the Microsoft Graph Clear range (when Shift is None) or Delete range (when Shift is Up or Left) API to delete a range of cell data (Range) from a specified workbook (Workbook) worksheet (SheetName). Delete Sheet
- Raw document content
to the source file. * Delete Range: Uses the Microsoft Graph Clear range (when **Shift** is //None//) or Delete range (when **Shift** is //Up// or //Left//) API to delete a range of cell data (**Range**) from
…the information from a specified Excel workbook cell range for use in other activities, such as Write 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 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
…: “Hello world” or “=B1+C2” Properties Input Cell (String)* - The Excel cell or range that you want
…into a specified spreadsheet cell or a range. If the sheet does not exist, a new one is created with the name
- 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 Excel cell or range that you want to write to. If the range isn't specified, the whole spreadsheet
…spreadsheet cell or a range. If the sheet does not exist, a new one is created with the name specified
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
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
Write Range
Located in
- Rendered document content
) In the body of activity Workbook Path - The path of the Excel file you want to write to. E.g: “C:\FolderName\ClientList.xlsx” Sheet name - The name of the sheet in which the range that you want to write to is. By default
…to the specified range, as a DataTable variable. Only DataTable variables are supported. Properties Input
- Title
Write Range
- Location
Excel Activities
…Write Range
- Raw document content
of the Excel file you want to write to. E.g: “C:\FolderName\ClientList.xlsx” * **Sheet name** - The name of the sheet in which the range that you want to write to is. By default, this is filled in with "Sheet1." E.g
…and strings are supported. * **Data Table** - The data that you want to write to the specified range
[01] akaBot Studio 2.2.0.2
Located in
- Rendered document content
What's New [Added] Added Excel Set Range Format activity: This activity allows user to format cells and ranges according to a specific format. [Added] Screen Status Check Activity: This activity
…and automate Excel tasks using Visual Basic for Applications. Insert VBA Activity: This activity allows you
- Raw document content
** == * [Added] Added Excel Set Range Format activity: This activity allows user to format cells and ranges
…for working with VBA code within your automation workflows, empowering you to customize and automate Excel
…new VBA code into a workbook or a specific module. It helps you extend the functionality of your Excel
« previous page
next page »
Page
1
2
3
4
RSS feed for search on [excel-delete-range]