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
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
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
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
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
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
Export Chart
Located in
- Rendered document content
or graphs from a specified Excel file as images. (* for mandatory) Properties Input Image Format (DropDownList)* - Select the file type that you want to save the exported chart/graph as. It contains 3 types: Png, Bmp and Jpg. Name Contains (String)* - The name of the chart. E.g: “Chart sale” Path to Save
- Location
Excel Activities
- Raw document content
Excel file as images. (% class="wikigeneratedid" id="H" %) [[image:image-20220505134428-1.jpeg
…type that you want to save the exported chart/graph as. It contains 3 types: Png, Bmp and Jpg. * **Name Contains (String)*** - The name of the chart. E.g: “Chart sale” * **Path to Save (String
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 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 Insert Or Delete Rows
Located in
- Rendered document content
in the workbook where the change must be made. E.g: "Sheet1" Properties Destination Number of rows (Int32
…the document. Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g
…edit the name of the activity to organize and structure your code better. E.g: [038325762] Excel Insert
- Title
Excel Insert Or Delete Rows
- Location
Excel Activities
…Excel Insert Or Delete Rows
- Raw document content
name (String)*** - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1
…the document. * **Sheet name (String)*** - The name of the sheet in the workbook where the change must be made
…. E.g: [038325762] Excel Insert Or Delete Rows **Options** * **CopyOrigin (Dropdown List
next page »
Page
1
2
3
RSS feed for search on [excel-save-workbook]