Search: excel-get-workbook-sheets

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

Results 1 - 10 of 47 next page » Page 1 2 3 4 5

[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

[1] About Data Service

Last modified by admin on 2023/12/21 22:15
Rendered document content
reporting Description: Processes for monthly financial reporting get data from multiple systems like
Attachment content
" DisplayName="[097579691] Get Agent Asset" sap:VirtualizedContainerService.HintSize="313.6,22.4" sap2010
" DisplayName="[097579691] Get Agent Asset" sap:VirtualizedContainerService.HintSize="313.6,22.4" sap2010
Attachment name
GetAssetValue-0.0.0.9.1.nupkg
Raw document content
reporting get data from multiple systems like bookings, invoices, billings, and payments. Problem: Both

[1] Release Notes

Located in
Last modified by VuNH54 on 2023/09/08 14:41
Rendered document content
of worksheets (Sheets) from a specified workbook (Workbook). Read Cell: Reads the value of an Excel cell
the same sheet. Copy Sheet: Copies a sheet from a specified workbook and pastes it to another specified
a range of cell data (Range) from a specified workbook (Workbook) worksheet (SheetName). Delete Sheet
Raw document content
a specified workbook (**Workbook**) worksheet (**SheetName**). * Delete Sheet: Deletes the specified sheet
. * Get Cell Color: Extracts the background color of a cell and saves it as a Color variable * Get sheets: Uses the Microsoft Graph Get worksheet API to retrieve and return an array of worksheets (**Sheets

[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

[1] Release Notes

Last modified by admin on 2023/09/22 18:39
Rendered document content
RCA.Activities.Office365 v1.0.0 1. Sharepoint List Activity: Activity Description Get List
to a SharePoint List. Delete List Items Retrieve a single SharePoint list item from the specified list. Get List Info Uses the Microsoft Graph Get list API to get information about the specified SharePoint List
Raw document content
|=Description |Get List Items|Retrieve SharePoint List Items from the specified list. |Add List Item|((( Add
the specified list. |Get List Info|Uses the Microsoft Graph Get list API to get information about the specified SharePoint List. |For Each List|Uses the Microsoft Graph Get lists and Get list APIs to perform an activity

Activities

Last modified by admin on 2022/07/01 15:42
Rendered document content
Append Range Excel Append Range Excel Application Scope Excel Close Workbook Excel Copy Paste Range Excel Copy Sheet Excel Delete Range Excel Get Workbook Sheet Excel Get Workbook Sheets Excel
Save Workbook Excel Select Range Excel Select Sheet Excel Set Border Excel Set Range Color Excel
Location
Excel Activities
Raw document content
/]] * [[Excel Get Workbook Sheet>>url:https://docs.akabot.com/bin/view/Activities/Excel%20Activities/Activities/Excel%20Get%20Workbook%20Sheet/]] * [[Excel Get Workbook Sheets>>url:https://docs.akabot.com/bin/view
/]] * [[Excel Close Workbook>>url:https://docs.akabot.com/bin/view/Activities/Excel%20Activities/Activities

Activities

Located in
Last modified by admin on 2024/04/22 16:12
Objects
="akb-card-title">Getting Started</div> <div class="akb-card-body"> <div class="akb-link
/%5B3%5D%20Assets/Activities/Get%20Agent%20Assets/">Get Agent Assets</a> <a href="/bin/view/Activities/%5B3%5D%20Assets/Activities/Get%20Agent%20Credential/">Get Agent Credential</a> <a href

Append Range

Last modified by VuNH54 on 2023/04/19 16:55
Rendered document content
stored in a DataTable variable to the end of a specified Excel spreadsheet. If the sheet does not exist
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
Location
Excel Activities
Raw document content
variable to the end of a specified Excel spreadsheet. If the sheet does not exist, a new one is created
) == **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

Customize Dashboards

Last modified by admin on 2023/12/11 17:19
Rendered document content
to access Tableau UI. Step 2: Right-click on the sheet you want to duplicate, then click Duplicate. Step 3: Click on Publish to save the duplicated sheet to the list of views in akaBot Insights
, as a CSV file, as an Excel file, or as a PowerPoint file. Step 1: To export a view, click on the Download
Raw document content
to access Tableau UI. (% style="font-family:Arial,Helvetica,sans-serif" %)Step 2: Right-click on the sheet
="font-family:Arial,Helvetica,sans-serif" %)Step 3: Click on **Publish** to save the duplicated sheet
in different formats: as a PDF file, as an image file, as a CSV file, as an Excel file, or as a PowerPoint file

Excel Activities

Located in
Last modified by admin on 2022/05/18 09:52
Rendered document content
The Excel Activities offers deep integration with Microsoft Excel and ships with a number of activities that automate the tasks you perform in Excel. These activities enable the robots to: Read information from a cell, columns, rows or ranges, and write to other spreadsheets or workbooks. Execute macros
Title
Excel Activities
Location
Excel Activities
Raw document content
The Excel Activities offers deep integration with Microsoft Excel and ships with a number of activities that automate the tasks you perform in Excel. These activities enable the robots to: * ((( Read information from a cell, columns, rows or ranges, and write to other spreadsheets or workbooks. ))) * Execute
next page » Page 1 2 3 4 5
RSS feed for search on [excel-get-workbook-sheets]
Created by admin on 2022/04/17 14:38