Search: excel-save-workbook

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

Results 1 - 10 of 12 next page » Page 1 2

Excel Save As Workbook

Last modified by VuNH54 on 2023/04/20 09:45
Rendered document content
code better. E.g: Save as Workbook Options File Format (DropDown list box) - You can choose different
RCA.Activities.Excel.ExcelSaveAsWorkbook Description The activity allows you to save changes as a new file. This only can be used in Excel Application Scope Activity. (* for mandatory) In the body
Title
Excel Save As Workbook
Location
Excel Save As Workbook
Excel Activities
Raw document content
of the activity to organize and structure your code better. E.g: Save as Workbook **Options** * **File Format
" %) ((( RCA.Activities.Excel.ExcelSaveAsWorkbook == **Description** == The activity allows you to save changes as a new file. This only can be used in Excel Application Scope Activity. [[image:image-20220505135028-1.jpeg]] (* for mandatory

Excel Application Scope

Last modified by VuNH54 on 2023/04/19 16:56
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

Append Range

Last modified by VuNH54 on 2023/04/19 16:55
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

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

Write Cell

Last modified by VuNH54 on 2023/04/20 10:53
Rendered document content
. (* for mandatory) In the body of activity Workbook Path - The path of the Excel file you want to use. E.g: “C
to write to. String supported only. E.g: “A20” Properties Input Workbook Path (String)* - The path of the Excel file you want to use. E.g: “C:\FolderName\ClientList.xlsx” Sheet name (String)* - The sheet you
Location
Excel Activities
Raw document content
: “A20” == **Properties** == **Input** * **Workbook Path (String)*** - The path of the Excel file you
-1.jpeg]] (* for mandatory) == **In the body of activity** == * **Workbook Path** - The path of the Excel file you want to use. E.g: “C:\FolderName\ClientList.xlsx” * **Sheet name** - The sheet you want

Write Range

Last modified by VuNH54 on 2023/04/20 10:55
Rendered document content
) In the body of activity Workbook Path - The path of the Excel file you want to write to. E.g: “C:\FolderName
Workbook Path (String)* - The path of the Excel file you want to write to. E.g: “C:\FolderName
Location
Excel Activities
Raw document content
-20220505135914-1.jpeg]] (* for mandatory) == **In the body of activity** == * **Workbook Path** - The path of the Excel file you want to write to. E.g: “C:\FolderName\ClientList.xlsx” * **Sheet name** - The name
, as a DataTable variable. Only DataTable variables are supported. == **Properties** == **Input** * **Workbook

Excel Write Cell

Last modified by VuNH54 on 2023/04/20 10:39
Rendered document content
specified in the Sheet Name property. If a value exists, it is overwritten. Changes are immediately saved. Can only be used in the Excel Application Scope activities. (* is mandatory) In the body
 - The Excel cell or range that you want to write to. If the range isn't specified, the whole spreadsheet
Title
Excel Write Cell
Location
Excel Activities
Excel Write Cell
Raw document content
in the Sheet Name property. If a value exists, it is overwritten. Changes are immediately saved. Can only be used in the Excel Application Scope activities. [[image:image-20220505113619-1.jpeg]] (* is mandatory
: “ClientName” * **Cell** - The Excel cell or range that you want to write to. If the range isn't specified

[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

Excel Write Range

Last modified by VuNH54 on 2023/04/20 10:42
Rendered document content
range are overwritten. Changes are immediately saved. Can only be used in the Excel Application Scope
of the activity to organize and structure your code better. E.g: Write Range Excel Options Add Headers (Checkbox
Title
Excel Write Range
Location
Excel Activities
Excel Write Range
Raw document content
are immediately saved. Can only be used in the Excel Application Scope activities. [[image:image-20220505114134-2
Range Excel **Options** * **Add Headers (Checkbox) **- When selected, column headers are also written

Customize Dashboards

Last modified by admin on 2023/12/11 17:19
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
next page » Page 1 2
RSS feed for search on [excel-save-workbook]
Created by admin on 2022/04/17 14:38