Search: excel-close-workbook
Last modified by admin on 2022/04/24 04:58
Refine your search
Select a category and activate filters on the current results
Location
- 26Activities
- 2akaBot Studio
- 1Data Service
Last author
- 11Giang Tran
- 11VuNH54
- 5admin
- 2Nga Nguyen
Creator
- 25Giang Tran
- 4admin
Last modification date
Creation date
Object type
- 1Activities
- 1Live Table
- 1UI Extension
Uploaded by
- 21Giang Tran
- 1VuNH54
- 1admin
Upload date
Read Range
Located in
- 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
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
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
- 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
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
- 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
Located in
- 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
Located in
- 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
Execute Macro
Located in
- Rendered document content
RCA.Activities.Excel.ExecuteMacro Description This activity allows you to execute the macro within a workbook. The Workbook file needs to be a Macro-Enabled Workbook. Changes are immediately saved. Can only be used in the Excel Application Scope activity. (* for mandatory) Properties Common
- Location
Excel Activities
- Raw document content
" %) ((( RCA.Activities.Excel.ExecuteMacro == **Description** == This activity allows you to execute the macro within a workbook. The Workbook file needs to be a Macro-Enabled Workbook. Changes are immediately saved. Can only be used in the Excel Application Scope activity. [[image:image-20220505134614-1.jpeg]] (* for mandatory
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
…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
Located in
- 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
« previous page
next page »
Page
1
2
3
RSS feed for search on [excel-close-workbook]