Search: excel-save-workbook

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

Results 1 - 10 of 25 next page » Page 1 2 3

[2] About Activities Packages

Last modified by DatPT on 2023/04/12 16:57
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

Last modified by Giang Tran on 2022/05/13 06:50
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

Last modified by Giang Tran on 2022/05/13 06:53
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

Last modified by Giang Tran on 2022/05/13 06:53
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

Last modified by Giang Tran on 2022/05/13 06:52
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

Last modified by Giang Tran on 2022/05/13 04:31
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

Last modified by Giang Tran on 2022/05/13 04:32
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

Last modified by Giang Tran on 2022/05/13 04:27
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

Last modified by Giang Tran on 2022/05/13 06:19
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

Excel LookUp Range

Last modified by Giang Tran on 2022/05/13 06:22
Rendered document content
) In the body of activity Sheet name (String)* - The name of the sheet in the workbook where you want to search
of the sheet in the workbook where the change must be made. E.g: "Sheet1" Value (String) - The value that you
] Excel Lookup Range Option Look in (Dropdown List) - Select type of value to look up into range
Title
Excel LookUp Range
Location
Excel Activities
Excel LookUp Range
Raw document content
in the workbook where you want to search. E.g: "Sheet1" * **Range (String)*** - The range where you want
in the workbook where the change must be made. E.g: "Sheet1" * **Value (String)** - The value that you want
. E.g: [759682936] Excel Lookup Range **Option** * **Look in (Dropdown List) **- Select type
next page » Page 1 2 3
RSS feed for search on [excel-save-workbook]
Created by admin on 2022/04/17 14:38