Search: excel-save-as-workbook

Help

Raw document content

Manager doesn't import it. #set ($historyURL = $xwiki.getURL('Help.History.WebHome', 'save

…

': $xwiki.getURL('Help.History.WebHome', 'save', $escapetool.url({ 'title': $services.localization.render

…

'), 'form_token': $services.csrf.token, 'xredirect': $xwiki.getURL('Help.History.WebHome', 'save

Activities

Rendered document content

LookUp Range Excel Read Cell Excel Read Range Excel Remove Duplicates Range Excel Save As Workbook Excel Save Workbook Excel Select Range Excel Select Sheet Excel Set Border Excel Set Range Color Excel

…

Append Range Excel Append Range Excel Application Scope Excel Close Workbook Excel Copy Paste

Location

Excel Activities

Raw document content

/Excel%20Activities/Activities/Excel%20Remove%20Duplicates%20Range/]] * [[Excel Save As Workbook

…

/]] * [[Excel Save Workbook>>url:https://docs.akabot.com/bin/view/Activities/Excel%20Activities/Activities/Excel

…

/]] * [[Excel Close Workbook>>url:https://docs.akabot.com/bin/view/Activities/Excel%20Activities/Activities

Excel Activities

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

[01] akaBot Studio 2.2.0.2

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] Release Notes

Rendered document content

content API to convert a OneDrive or SharePoint file to a PDF and save it to a local location. Find Files

…

 and Results) that you can use as input variables in subsequent activities; almost all of the Excel and Files

Raw document content

a OneDrive or SharePoint file to a PDF and save it to a local location. |(% style="width:283px" %)Find Files

…

activities; almost all of the Excel and Files activities require this as an input variable. This activity

Customize Dashboards

Rendered document content

Dashboard. Step 3: Click on Publish to save the new view to the list of views in akaBot Insights

…

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

-serif" %)Step 3: Click on **Publish** to save the new view to the list of views in akaBot Insights

…

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

[1] About Data Service

[2] About Activities Packages

Rendered document content

browser or Excel. But if we want to automate process related to,  for example PDF or Email, new packages

…

3: Click the Save button. Step 4: Click the Yes button in the confirmation popup to restart akaBot

…

the Uninstall button Step 3: Click Save button. Step 4: Click the Yes button in the confirmation popup

Raw document content

a certain number of activities related to Window application, Web browser or Excel. But if we want

…

the **Save** button. **Step 4:** Click the **Yes** button in the **confirmation** popup to **restart

…

, then click the **Uninstall** button **Step 3: **Click** Save** button. **Step 4:** Click the **Yes** button

Execute Macro

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

Read Range

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