Search: excel-read-range
Last modified by admin on 2022/04/24 04:58
Refine your search
Select a category and activate filters on the current results
Last author
- 13VuNH54
- 11Giang Tran
- 3Nga Nguyen
- 3admin
Creator
- 25Giang Tran
- 2VuNH54
- 2admin
- 1Nga Nguyen
Last modification date
Creation date
Object type
- 1Activities
- 1Live Table
- 1UI Extension
Uploaded by
- 21Giang Tran
- 2VuNH54
- 1Nga Nguyen
Upload date
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
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
…RCA.Activities.Excel.ReadColumn Description Reads the values from a column beginning
- Title
Read Column
- Location
Excel Activities
…Read Column
- Raw document content
" * **Workbook Path (String)*** - The path of the Excel file you want to read. E.g: “C:\FolderName
…" %) ((( RCA.Activities.Excel.ReadColumn == **Description** == Reads the values from a column beginning with the cell specified
…]] (* for mandatory) == **In the body of activity** == * **Workbook Path (String)*** - The path of the Excel file
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
…RCA.Activities.Excel.ReadRow Description Reads the values from a row beginning with the cell
- Title
Read Row
- Location
Excel Activities
…Read Row
- Raw document content
". E.g: "A1" * **Workbook Path (String)*** - The path of the Excel file you want to read. E.g: “C
…" %) ((( RCA.Activities.Excel.ReadRow == **Description** == Reads the values from a row beginning with the cell specified
…]] (*for mandatory) == **In the body of activity** == * **Workbook Path (String)*** - The path of the Excel
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
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
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
…: “Employee Name” * **Number of row (Int) **- Number of rows you want to insert in Excel sheet E.g: 5
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
…whether the body of the message is written in HTML format. Mark as Read(Checkbox) - Specifies whether to mark retrieved messages as read. By default, this check box is cleared. Only Unread Messages (Checkbox
- Raw document content
. The options displayed in this field range from 2007 to the 2013 version. Please note that the version number
…as Read(Checkbox) **- Specifies whether to mark retrieved messages as read. By default, this check box
Activities
Located in
- Objects
/Activities/Append%20Range/">Append Range</a> <a href="/bin/view/Activities/Excel%20Activities/Activities/Excel%20Append%20Range/">Excel Append Range</a> <a href="/bin/view/Activities/Excel
…%20Activities/Activities/Read%20CSV%20File/">Read CSV File</a> <a href="/bin/view/Activities/CSV
« previous page
Page
1
2
3
RSS feed for search on [excel-read-range]