Search: excel-get-workbook-sheets

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

Results 41 - 47 of 47 « previous page Page 1 2 3 4 5

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:\FolderName\SaleReport.xlsx” Sheet name (String)* - The sheet you want to read. E.g: "Sheet1" Starting Cell
, this is filled in with "A1". E.g: "A1" Workbook Path (String)* - The path of the Excel file you want to read. E.g
Location
Excel Activities
Raw document content
]] (* for mandatory) == **In the body of activity** == * **Workbook Path (String)*** - The path of the Excel file you want to read. E.g: “C:\FolderName\SaleReport.xlsx” * **Sheet name (String)*** - The sheet you want
" * **Workbook Path (String)*** - The path of the Excel file you want to read. E.g: “C:\FolderName

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
RCA.Activities.Excel.ReadRange Description This activity allows you to read the Excel range
Location
Excel Activities
Raw document content
) == **In the body of activity** == * **Workbook Path (String)*** - The path of the Excel file you want to read
: "A1:B2" == **Properties** == **Input** * **Workbook Path (String) **- The path of the Excel
" %) ((( RCA.Activities.Excel.ReadRange == **Description** == This activity allows you to read the Excel range and store

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:\FolderName\SaleReport.xlsx” Sheet name (String)* - The sheet you want to read. E.g: "Sheet1" Starting Cell
in with "A1". E.g: "A1" Workbook Path (String)* - The path of the Excel file you want to read. E.g: “C
Location
Excel Activities
Raw document content
]] (*for mandatory) == **In the body of activity** == * **Workbook Path (String)*** - The path of the Excel 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

Release Notes

Last modified by Nga Nguyen on 2022/05/13 04:21
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

Select File

Last modified by DatPT on 2023/04/12 17:41
Rendered document content
them with a semicolon (“;”). Use Asterisk to get all files. The default value is: All files E.g: Image files (.bmp, .jpg)|.bmp;.jpg| .Excel files (.xlsx)|.xlsx Misc Public (Checkbox) - If you
Raw document content
multiple file types, separate them with a semicolon (“;”). Use Asterisk to get all files. The default value is: All files E.g: Image files (.bmp, .jpg)|.bmp;.jpg| .Excel files (.xlsx)|.xlsx **Misc

Write Cell

Last modified by VuNH54 on 2023/04/20 10:53
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
of the Excel file you want to use. E.g: “C:\FolderName\ClientList.xlsx” Sheet name (String)* - The sheet you
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
: “A20” == **Properties** == **Input** * **Workbook Path (String)*** - The path of the Excel file you
spreadsheet cell or a range. If the sheet does not exist, a new one is created. [[image:image-20220505135743

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\ClientList.xlsx” Sheet name - The name of the sheet in which the range that you want to write to is. By default
Workbook Path (String)* - The path of the Excel file you want to write to. E.g: “C:\FolderName
Location
Excel Activities
Raw document content
-20220505135914-1.jpeg]] (* for mandatory) == **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, this is filled in with "Sheet1." E.g
RSS feed for search on [excel-get-workbook-sheets]
Created by admin on 2022/04/17 14:38