Search: excel-select-sheet
Last modified by admin on 2022/04/24 04:58
Refine your search
Select a category and activate filters on the current results
Location
- 37Activities
- 1Data Service
- 1XWiki
- 1akaBot Insights
- 1akaBot Studio
Last author
- 17Giang Tran
- 16VuNH54
- 5admin
- 2Nga Nguyen
- 1DatPT
Creator
- 33Giang Tran
- 5admin
- 2VuNH54
- 1LongVA
Last modification date
Creation date
Object type
Uploaded by
- 31Giang Tran
- 3VuNH54
- 1LongVA
- 1admin
Upload date
Release Notes
Located in
- Rendered document content
RCA.Activities.Excel Version 2.1.1.0 Bugs fixed [ExcelApplicationScope]Edit message when excel file is set password protected sheet. [ExportChart]Export chart missing when name file excel has chart
…characters. [ExcelApplicationScope] A loop opens Excel file in the background. Even though the workflow has
- Raw document content
when excel file is set password protected sheet. * [ExportChart]Export chart missing when name file excel has chart name same. * [ExcelApplicationScope] At Textbox[Designer], change length when input more than 200 characters. * [ExcelApplicationScope] A loop opens Excel file in the background. Even though
[1] Release Notes
Located in
- Rendered document content
RCA.Activities.Excel Version 2.1.1.0 Bugs fixed [ExcelApplicationScope]Edit message when excel file is set password protected sheet. [ExportChart]Export chart missing when name file excel has chart
…characters. [ExcelApplicationScope] A loop opens Excel file in the background. Even though the workflow has
- Location
Excel Activities
- Raw document content
when excel file is set password protected sheet. * [ExportChart]Export chart missing when name file excel has chart name same. * [ExcelApplicationScope] At Textbox[Designer], change length when input more than 200 characters. * [ExcelApplicationScope] A loop opens Excel file in the background. Even though
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
…of the activity** == * **Sheet name (String)*** - The name of the sheet that you want to insert row. E.g: “Employee Name” * **Number of row (Int) **- Number of rows you want to insert in Excel sheet E.g: 5
Excel Insert Or Delete Columns
Located in
- Rendered document content
or removal begins. E.g: 2 Sheet name (String)* - The name of the sheet in the workbook where the change must
…Input Change Mode (Dropdown List) - Selects whether the activity adds or removes columns. ・Add: Add columns to the document. ・Delete: Remove columns from the document. Sheet name (String)* - The name
- Title
Excel Insert Or Delete Columns
- Location
Excel Activities
…Excel Insert Or Delete Columns
- Raw document content
)** - The column where the insertion or removal begins. E.g: 2 * **Sheet name (String)*** - The name of the sheet
…) **- Selects whether the activity adds or removes columns. **・Add**: Add columns to the document. **・Delete**: Remove columns from the document. * **Sheet name (String)*** - The name of the sheet in the workbook
Write Cell
Located in
- Rendered document content
of the Excel file you want to use. E.g: “C:\FolderName\ClientList.xlsx” Sheet name (String)* - The sheet you
…into a specified spreadsheet cell or a range. If the sheet does not exist, a new one is created. (* for mandatory) In the body of activity Workbook Path - The path of the Excel file you want to use. E.g: “C
- Location
Excel Activities
- Raw document content
of the Excel file you want to use. E.g: “C:\FolderName\ClientList.xlsx” * **Sheet name** - The sheet you want
…spreadsheet cell or a range. If the sheet does not exist, a new one is created. [[image:image-20220505135743
…: “A20” == **Properties** == **Input** * **Workbook Path (String)*** - The path of the Excel file you
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
…only be used in the Excel Application Scope activity. (* is mandatory) In the body of activity Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1
- Title
Excel Read Range
- Location
Excel Activities
…Excel Read Range
- Raw document content
" %) ((( RCA.Activities.Excel.ExcelReadRange == **Description** == This activity allows you to read the value of an Excel range and store
…as a cell, the whole spreadsheet starting from that cell is read. Can only be used in the Excel Application
…** == * **Sheet name (String)*** - The name of the sheet in the workbook where the change must be made. E.g
Export Chart
Located in
- Rendered document content
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
…(String)* - Directory to save file. E.g: “C:\DestinationSaveFolderName\” Sheet Name (String) - The name
- 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
…)* **- Directory to save file. E.g: “C:\DestinationSaveFolderName\” * **Sheet Name (String)** - The name
Excel Insert Or Delete Rows
Located in
- Rendered document content
or removal begins. By default, this is filled in with 1. E.g: 2 Sheet name (String)* - The name of the sheet
…or removal begins. By default, this is filled in with 1. E.g: 2 Input Change Mode (Dropdown List) - Selects
…the document. Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g
- Title
Excel Insert Or Delete Rows
- Location
Excel Activities
…Excel Insert Or Delete Rows
- Raw document content
)** - The row where the insertion or removal begins. By default, this is filled in with 1. E.g: 2 * **Sheet name (String)*** - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1
…, this is filled in with 1. E.g: 2 **Input** * **Change Mode (Dropdown List) **- Selects whether
Excel Remove Duplicates Range
Located in
- Rendered document content
that are duplicated in a specified range. (*for mandatory) In the body of activity Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" Range (String
…) - The range from which you want to remove duplicate rows. E.g: "A1:H5" Sheet name (String)* - The name
- Title
Excel Remove Duplicates Range
- Location
Excel Activities
…Excel Remove Duplicates Range
- Raw document content
. [[image:image-20220505141832-1.png]] (*for mandatory) == **In the body of activity** == * **Sheet name (String)*** - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1
…. E.g: "A1:H5" * **Sheet name (String)*** - The name of the sheet in the workbook where the change must
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 activity. (* for mandatory) Properties Input Sheet name (String)* - The name of the sheet that contains the cell you want to color. E.g: “Name of the sheet” Range (String)* - The range of data
- Title
Excel Set Range Color
- Location
Excel Activities
…Excel Set Range Color
- Raw document content
using a Color variable. Can only be used within the Excel Application Scope activity. [[image:image-20220505133337-1.jpeg]] (* for mandatory) == **Properties** == **Input** * **Sheet name (String)* **- The name of the sheet that contains the cell you want to color. E.g: “Name of the sheet” * **Range
« previous page
next page »
Page
1
2
3
4
5
RSS feed for search on [excel-select-sheet]