Search: upload-file-update-existing

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

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

Excel Save As Workbook

Last modified by VuNH54 on 2023/04/20 09:45
Rendered document content
as a new file. This only can be used in Excel Application Scope Activity. (* for mandatory) In the body of activity File Path (String)* - Input the full path of the file or click “…” button to choose an existed
or click “…” button to choose an existed file that you want to write over it. This field accepts only
Raw document content
to choose an existed file that you want to write over it. This field accepts only strings and String
)*** - Input the full path of the file or click “…” button to choose an existed file that you want to write
" %) ((( RCA.Activities.Excel.ExcelSaveAsWorkbook == **Description** == The activity allows you to save changes as a new file. This only can

[3] akaBot Studio 2.0.5.4

Last modified by VuNH54 on 2023/04/12 16:29
Rendered document content
the PC. Change the Word application scope so that it does not close word files that are not specified
of GenerateDataTable Wizards in the Core category. Updated Updated specification for Timeout MS property of Execute
Raw document content
. * Change the Word application scope so that it does not close word files that are not specified as targets
of GenerateDataTable Wizards in the Core category. == **Updated** == * Updated specification for Timeout MS property

Word Application Scope

Last modified by VuNH54 on 2023/04/21 11:08
Rendered document content
are supported. If the specified file does not exist, a new document file is created. E.g: “D:/input.docx” Do - Drop activity would be processed in that Word file. Properties Input File Path (String) – The path
does not exist, a new document file is created. Misc Public (Checkbox) - If you check it, the data
Raw document content
and Strings are supported. If the specified file does not exist, a new document file is created. E.g: “D:/input.docx” * **Do** - Drop activity would be processed in that Word file. == **Properties** == **Input
and Strings are supported. If the specified file does not exist, a new document file is created. **Misc

[1] Release Notes

Located in
Last modified by VuNH54 on 2023/09/08 14:41
Rendered document content
-package Add Delete Column: Adds blank columns or removes existing columns from a specified sheet. Add Delete Rows: Adds empty rows or removes existing rows from a specified sheet. Add New Sheets: Creates a new sheet inside a specified Google spreadsheet Append Row: Appends a row to an existing spreadsheet
Raw document content
or removes existing columns from a specified sheet. * Add Delete Rows: Adds empty rows or removes existing
spreadsheet * Append Row: Appends a row to an existing spreadsheet. * Auto Fill Range: Fulfills the auto-fill
to the source file. * Delete Range: Uses the Microsoft Graph Clear range (when **Shift** is //None//) or Delete

Excel Application Scope

Last modified by VuNH54 on 2023/04/19 16:56
Rendered document content
are supported. Use Existing Workbook Existing Workbook (WorkbookApplication) - Use the data from an Excel file
Workbook Path (String) - The path of the Excel file you want to read. E.g: “C:\FolderName\Contacts.xlsx” “Do” - The activities you want to execute within the application. Properties File Edit password
Raw document content
of the activity** == * **Workbook Path (String)** - The path of the Excel file you want to read. E.g: “C
. == **Properties** == **File** * **Edit password (String)** - The password required for editing password
(String)*** - The path of the Excel file you want to read. E.g: “C:\FolderName\Contacts.xlsx” * **Password

Set Transaction Status

Last modified by VuNH54 on 2023/04/20 17:14
Rendered document content
about the specific TransactionItem whose status is to be updated. Output (Dictionnary<String, InArgument>) - A collection of additional information about the specific transaction item whose status is updated. Status
(QueueItem) - The items you want to update status Misc Public (Checkbox) - Check if you want to publicize
Raw document content
>)** - A collection of analytics information about the specific TransactionItem whose status is to be updated
transaction item whose status is updated. * **Status (DropDownlist)** - The status that is to be set to the transaction item. Successful | Fail * **Transaction Item (QueueItem) **- The items you want to update status

Execute Non Query

Last modified by VuNH54 on 2023/04/19 15:39
Rendered document content
statement on a database. For UPDATE, INSERT, and DELETE statements, the return value is the number of rows
: “Server=myServerAddress;Database=myDataBase;UserId=myUsername;Password=myPassword;” Existing DbConnection
. For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command
Raw document content
. For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command
=myUsername;Password=myPassword;” * **Existing DbConnection (DatabaseConnection)**- An already opened database
** * **Affected Records (Int32) **- The result of the execution of the SQL command. For UPDATE, INSERT, and DELETE

Write Cell

Last modified by VuNH54 on 2023/04/20 10:53
Rendered document content
into a specified spreadsheet cell or a range. If the sheet does not exist, a new one is created. (* for mandatory) In the body of activity Workbook Path - The path of the Excel file you want to use. E.g: “C
of the Excel file you want to use. E.g: “C:\FolderName\ClientList.xlsx” Sheet name (String)* - The sheet you
Raw document content
spreadsheet cell or a range. If the sheet does not exist, a new one is created. [[image:image-20220505135743
of the Excel file you want to use. E.g: “C:\FolderName\ClientList.xlsx” * **Sheet name** - The sheet you want
: “A20” == **Properties** == **Input** * **Workbook Path (String)*** - The path of the Excel file you

Append Range

Last modified by VuNH54 on 2023/04/19 16:55
Rendered document content
stored in a DataTable variable to the end of a specified Excel spreadsheet. If the sheet does not exist
of activity Workbook Path - The full path of the Excel spreadsheet that you want to use. If the Excel file
want to use. If the Excel file to be used is located in the project folder, its relative path can
Raw document content
variable to the end of a specified Excel spreadsheet. If the sheet does not exist, a new one is created
to use. If the Excel file to be used is located in the project folder, its relative path can be used
(String)*** - The full path of the Excel spreadsheet that you want to use. If the Excel file to be used

Replace Picture

Last modified by VuNH54 on 2023/04/21 11:27
Rendered document content
with picture - The file path of image to insert in the document. Misc Public (Checkbox) - Check if you want
not exist Alt text is null
Raw document content
with picture **- The file path of image to insert in the document. **Misc** * **Public (Checkbox)** - Check
as follows: *** Alt text does not exist *** Alt text is null
next page » Page 1 2
RSS feed for search on [upload-file-update-existing]
Created by admin on 2022/04/17 14:38