Search: excel-save-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
- 27Activities
- 1akaBot Studio
Last author
- 12Giang Tran
- 12VuNH54
- 2Nga Nguyen
- 2admin
Last modification date
Creation date
Object type
Uploaded by
- 24Giang Tran
- 1VuNH54
Upload date
[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
[2] How to use akaBot Studio
Located in
- Rendered document content
automation projects. The activities are grouped into different categories such as: Excel, XML, ControlFlow
…and automatically save new value when focusing out. 6 Workflow Outline Display the project hierarchy of current
…: The Home panel allows you to perform some below actions: New, Save, Start, Debug, Stop, Open Logs, Publish
- Raw document content
into different categories such as: Excel, XML, ControlFlow, Primitives, Care, HTTP... |4|Designer|Display you
…activities, enable you to change the value of properties and automatically save new value when focusing out
…]] The Home panel allows you to perform some below actions: New, Save, Start, Debug, Stop, Open Logs, Publish
Activities
Located in
- 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
Append Range
Located in
- 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
Excel Activities
Located in
- 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
Excel Application Scope
Located in
- Rendered document content
workbook and provides a scope for Excel Activities. (* for mandatory) In the body of the activity Workbook Path (String) - The path of the Excel file you want to read. E.g: “C:\FolderName\Contacts.xlsx
…(String) - The password required for editing password protected Excel workbooks, if necessary. Only String
- Title
Excel Application Scope
- Location
Excel Activities
…Excel Application Scope
- Raw document content
" %) ((( RCA.Activities.Excel.ExcelApplicationScope == **Description** == This activity allows to open an Excel workbook and provides a scope
…of the activity** == * **Workbook Path (String)** - The path of the Excel file you want to read. E.g: “C
…protected Excel workbooks, if necessary. Only String variables and strings are supported. * **Workbook Path
Excel Close Workbook
Located in
- Rendered document content
Workbook. This only can be used in Excel Application Scope Activity. (* for mandatory) Properties
…of the activity to organize and structure your code better. E.g: Close Workbook Use Workbook Workbook (WorkbookApplication)* - The workbook that you want to close. It can be an output from Excel Application Scope or any
- Title
Excel Close Workbook
- Location
Excel Close Workbook
…Excel Activities
- Raw document content
" %) ((( RCA.Activities.Excel.ExcelCloseWorkbook == **Description** == The activity allows you to close an open Workbook. This only can be used in Excel Application Scope Activity. [[image:image-20220505135216-1.jpeg]] (* for mandatory
…can edit the name of the activity to organize and structure your code better. E.g: Close Workbook
Excel Delete Range
Located in
- Rendered document content
RCA.Activities.Excel.ExcelDeleteRange Description This activity allows deleting a specified range in an Excel workbook. Can also be used to shift an entire row or column by using the ShiftCells and ShiftOption property fields. (* for mandatory) Properties Input Sheet Name (String) - The name
- Title
Excel Delete Range
- Location
Excel Activities
…Excel Delete Range
- Raw document content
(% class="akb-page-with-toc" %) ((( (% class="akb-page-content" %) ((( RCA.Activities.Excel.ExcelDeleteRange == **Description** == This activity allows deleting a specified range in an Excel workbook. Can also be used to shift an entire row or column by using the ShiftCells and ShiftOption property
Excel Get Workbook Sheet
Located in
- Rendered document content
RCA.Activities.Excel.ExcelGetWorkbookSheet Description This activity allows you to look for a sheet based on its index and returns its name as a String variable. be used in Excel Application Scope
…code better. E.g: Get Workbook Sheet Output Sheet (String) - List of string that contains sheet names
- Title
Excel Get Workbook Sheet
- Location
Excel Get Workbook Sheet
…Excel Activities
- Raw document content
and returns its name as a String variable. be used in Excel Application Scope Activity. [[image:image
…. You can edit the name of the activity to organize and structure your code better. E.g: Get Workbook
Excel Get Workbook Sheets
Located in
- Rendered document content
RCA.Activities.Excel.ExcelGetWorkbookSheets Description This activity allows you to look for a sheet based on its index and returns its name as a String variable. This only can be used in Excel
…. E.g: Get Workbook Sheets Table of Content Output Sheet (List< String >) - List of string
- Title
Excel Get Workbook Sheets
- Location
Excel Get Workbook Sheets
…Excel Activities
- Raw document content
and returns its name as a String variable. This only can be used in Excel Application Scope Activity
…and structure your code better. E.g: Get Workbook Sheets ))) (% class="akb-toc" %) ((( (% class="akb-toc-title
next page »
Page
1
2
3
RSS feed for search on [excel-save-workbook]