Search: select-file

Last modified by admin on 2022/04/24 04:58

Results 1 - 7 of 7 Page 1

Export Chart

Last modified by Giang Tran on 2022/05/13 06:52
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
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 Application Scope

Last modified by VuNH54 on 2023/04/19 16:56
Rendered document content
the macro level for the current Excel file. By default, EnableAll is selected. The drop-down contains three
Workbook Path (String) - The path of the Excel file you want to read. E.g: “C:\FolderName\Contacts.xlsx” “Do” - The activities you want to execute within the application. Properties File Edit password
Raw document content
)** - Specifies the macro level for the current Excel file. By default, EnableAll is selected. The drop-down
. Selecting this check box enables you to perform data extraction operations in an Excel file which is locked
)**- When selected, the Excel file is opened in the foreground while performing actions on it. When

[1] Release Notes

Last modified by Nga Nguyen on 2022/05/13 03:20
Rendered document content
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
message when user does not select value in [Copy Items]. [ExcelCopySheet] Screen hangs when typing
Raw document content
when excel file is set password protected sheet. * [ExportChart]Export chart missing when name file
than 200 characters. * [ExcelApplicationScope] A loop opens Excel file in the background. Even though
Password. * [ExcelCopyPasteRange] Modify message when user does not select value in [Copy Items

Read Range

Last modified by Giang Tran on 2022/05/13 06:53
Rendered document content
Workbook Path (String)* - The path of the Excel file you want to read. E.g: “C:\FolderName\SaleReport.xlsx
) - The path of the Excel file you want to read. E.g: “C:\FolderName\SaleReport.xlsx” Sheet name (String
Options Add Headers - If you select this, the column headers from the specified spreadsheet range
Raw document content
) == **In the body of activity** == * **Workbook Path (String)*** - The path of the Excel file you want to read
file you want to read. E.g: “C:\FolderName\SaleReport.xlsx” * **Sheet name (String)**- The sheet you
. E.g: Read Range **Options** * **Add Headers **- If you select this, the column headers from

Write Range

Last modified by VuNH54 on 2023/04/20 10:55
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
Workbook Path (String)* - The path of the Excel file you want to write to. E.g: “C:\FolderName
) - If you select this, the column headers from the specified spreadsheet range are also extracted
Raw document content
of the Excel file you want to write to. E.g: “C:\FolderName\ClientList.xlsx” * **Sheet name** - The name
Path (String)*** - The path of the Excel file you want to write to. E.g: “C:\FolderName\ClientList.xlsx
Headers (Checkbox)** - If you select this, the column headers from the specified spreadsheet range

Read Column

Last modified by VuNH54 on 2023/04/20 10:48
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
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

Read Row

Last modified by Giang Tran on 2022/05/13 06:53
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
Raw document content
file you want to read. E.g: “C:\FolderName\SaleReport.xlsx” * **Sheet name (String)*** - The sheet
". 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
Page 1
RSS feed for search on [select-file]
Created by admin on 2022/04/17 14:38