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
Last author
- 15VuNH54
- 14Giang Tran
- 9admin
- 6Nga Nguyen
- 1DatPT
- … 2 more
Creator
- 30Giang Tran
- 9admin
- 4Nga Nguyen
- 2VuNH54
- 1JP Comtor
- … 1 more
Last modification date
Creation date
Object type
Uploaded by
- 27Giang Tran
- 4Nga Nguyen
- 3VuNH54
- 3admin
- 2LongVA
Upload date
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
Write Cell
Located in
- Rendered document content
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
…content - The value or formula that you want to be written to a cell or range. Only string variables
- Location
Excel Activities
- Raw document content
spreadsheet cell or a range. If the sheet does not exist, a new one is created. [[image:image-20220505135743
…of the Excel file you want to use. E.g: “C:\FolderName\ClientList.xlsx” * **Sheet name** - The sheet you want
…to be written to a cell or range. Only string variables, generic variables and strings are supported. E.g
Send Exchange Mail
Located in
- Rendered document content
server that is used. The options displayed in this field range from the 2007 to the 2013 version. Please
…have a 2016 exchange server, you can select the Exchange2013 option. Server (String)* - The email
- Raw document content
displayed in this field range from the 2007 to the 2013 version. Please note that the version number
…can select the Exchange2013 option. * **Server (String)*** - The email server host that is to be used
Select File
Located in
- Rendered document content
RCA.Activities.Core.SelectFile Description This activity opens a dialog, allows you to select a file and returns full path of the selected file. Properties Input Filter (String) – Used to specify the type of file you want to select. This filter should contain a description of the filter
- Title
Select File
- Location
Select File
- Raw document content
" %) ((( RCA.Activities.Core.SelectFile == **Description** == This activity opens a dialog, allows you to select a file and returns full path of the selected file. [[image:image-20220505093334-1.jpeg]] == **Properties** == **Input** * **Filter (String) **– Used to specify the type of file you want to select. This filter should contain
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
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
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 Column
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
…, this is filled in with "A1". E.g: "A1" Workbook Path (String)* - The path of the Excel file you want to read. E.g
…] Read Column Options Preserve Format (Boolean) - Selecting this check box keeps the formatting
- Location
Excel Activities
- Raw document content
]] (* for mandatory) == **In the body of activity** == * **Workbook Path (String)*** - The path of the Excel file
…" * **Workbook Path (String)*** - The path of the Excel file you want to read. E.g: “C:\FolderName
…] Read Column **Options** * **Preserve Format (Boolean) **- Selecting this check box keeps
Move Message To Another Folder
Located in
- Rendered document content
that is used. The options displayed in this field range from 2007 to the 2013 version. Please note
…exchange server, you can select the Exchange2013 option. Server (String)* - The email server host
- Raw document content
the lowest version of the Exchange server that is used. The options displayed in this field range from 2007
…. This means that if you have a 2016 exchange server, you can select the Exchange2013 option. * **Server
Get Exchange Email Messages
Located in
- Rendered document content
) – Specifies the lowest version of the Exchange server that is used. The options displayed in this field range
…of service you support. This means that if you have a 2016 exchange server, you can select the Exchange2013
…) - Specifies whether to retrieve only unread messages. By default, this check box is selected. Order By Date
- Raw document content
. The options displayed in this field range from 2007 to the 2013 version. Please note that the version number
…can select the Exchange2013 option. * **Server (String)*** - The email server host that is to be used
…. By default, this check box is selected. * **Order By Date (OrderByDate)** - Order mail messages by date
next page »
Page
1
2
3
4
5
RSS feed for search on [excel-select-range]