Search: excel-save-workbook

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

Results 11 - 20 of 35 « previous page next page » Page 1 2 3 4

Append Range

Last modified by VuNH54 on 2023/04/19 16:55
Rendered document content
of activity Workbook Path - The full path of the Excel spreadsheet that you want to use. If the Excel file
variables. Properties Input Workbook Path (String)* - The full path of the Excel spreadsheet that you
stored in a DataTable variable to the end of a specified Excel spreadsheet. If the sheet does not exist
Location
Excel Activities
Raw document content
) == **In the body of activity** == * **Workbook Path ** - The full path of the Excel spreadsheet that you want to use. If the Excel file to be used is located in the project folder, its relative path can be used
variable to the end of a specified Excel spreadsheet. If the sheet does not exist, a new one is created

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
RCA.Activities.Excel.ReadRange Description This activity allows you to read the Excel range
specified, the whole spreadsheet will be read. E.g: "A1:B2" Properties Input Workbook Path (String
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

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

[1] Release Notes

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

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
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 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
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

Write Cell

Last modified by VuNH54 on 2023/04/20 10:53
Rendered document content
. (* for mandatory) In the body of activity Workbook Path - The path of the Excel file you want to use. E.g: “C
to write to. String supported only. E.g: “A20” Properties Input Workbook Path (String)* - The path 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
: “A20” == **Properties** == **Input** * **Workbook Path (String)*** - The path of the Excel file you
-1.jpeg]] (* for mandatory) == **In the body of activity** == * **Workbook Path** - The path of the Excel file you want to use. E.g: “C:\FolderName\ClientList.xlsx” * **Sheet name** - The sheet you want

Excel Remove Duplicates Range

Last modified by Giang Tran on 2022/05/13 06:24
Rendered document content
)* - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" Range (String
of the sheet in the workbook where the change must be made. E.g: "Sheet1" Misc Public (Boolean) - Check
to organize and structure your code better. E.g: [464936660] Excel Remove Duplicates Range
Title
Excel Remove Duplicates Range
Location
Excel Activities
Excel Remove Duplicates Range
Raw document content
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
. E.g: [464936660] Excel Remove Duplicates Range ))) {{velocity}} #if ($xcontext.action != 'export

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
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
, as a DataTable variable. Only DataTable variables are supported. == **Properties** == **Input** * **Workbook

[01] akaBot Studio 2.2.0.2

Last modified by admin on 2023/05/21 23:26
Rendered document content
to execute a specific VBA macro or function within your Excel workbook. It provides a way to call and run VBA
What's New [Added] Added Excel Set Range Format activity: This activity allows user to format
and automate Excel tasks using Visual Basic for Applications. Insert VBA Activity: This activity allows you
Raw document content
new VBA code into a workbook or a specific module. It helps you extend the functionality of your Excel
a specific VBA macro or function within your Excel workbook. It provides a way to call and run VBA code
** == * [Added] Added Excel Set Range Format activity: This activity allows user to format cells and ranges
RSS feed for search on [excel-save-workbook]
Created by admin on 2022/04/17 14:38