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
Creator
- 14Giang Tran
- 7admin
- 2VuNH54
- 1LongVA
Last modification date
Creation date
Object type
Uploaded by
- 12Giang Tran
- 3VuNH54
- 3admin
- 1LongVA
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 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) - When selected, column headers are also written to the specified range. By default, this check box
- 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 to the specified range. By default, this check box is not selected. ))) {{velocity}} #if ($xcontext.action
…with the value specified in the Sheetname property. All cells within the specified range are overwritten. Changes
[1] Release Notes
Located in
- Rendered document content
the information from a specified Excel workbook cell range for use in other activities, such as Write Range. Read
…: Enters a text or a formula in a cell. The activity can be used with an Excel file selected for a parent Use Excel File activity or with the Project Notebook. Write Range: Writes a DataTable variable
- Raw document content
the information from a specified Excel workbook cell range for use in other activities, such as Write Range
…Cell: Enters a text or a formula in a cell. The activity can be used with an Excel file selected for a parent Use Excel File activity or with the Project Notebook. * Write Range: Writes a DataTable variable
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 only be used in the Excel Application Scope activity. (* is mandatory) In the body of activity
- 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
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
Write Range
Located in
- Rendered document content
) - If you select this, the column headers from the specified spreadsheet range are also extracted
…) 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
- Title
Write Range
- Location
Excel Activities
…Write Range
- Raw document content
Headers (Checkbox)** - If you select this, the column headers from the specified spreadsheet range
…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
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
next page »
Page
1
2
3
RSS feed for search on [excel-select-range]