Search: element-exists-1

RCA.Activities.Gsuite Version 2.2.1.0 This release brings more new activities: 1.  Sheets sub-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

[1] Release Notes

[1] Release Notes

: === **1.  Sheets sub-package** === (% class="box" %) ((( * Add Delete Column: Adds blank columns 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

project. 2. Open a Project To open an existed workflow project, you can follow below actions: Step 1

allows you to easily access to specific functionalities as below: # Panel Description 1 File Display

Description 1 New Create a new workflow project. Refer to section: 2.2.1 Create a new workflow project

process. [[image:image-20220506161325-1.png]] === **akaBot Studio User Interface** === akaBot Studio

: |=#|=Panel|=Description |1|File|Display the functionalities which you can use to operate on the file. |2|Home

panel allows you to perform some below actions: |=#|=Tab|=Description |**1**|**New**|Create a new

affected by the command. For all other types of statements, the return value is -1. (* for Mandatory

: “Server=myServerAddress;Database=myDataBase;UserId=myUsername;Password=myPassword;” Existing DbConnection

. For all other types of statements, the return value is -1.

. For all other types of statements, the return value is -1. [[image:image-20220506105309-1.png

/Database%20Connect/WebHome/image-20230419153435-1.png?rev=1.1||alt="image-20230419153435-1.png"]] * **Edit

=myUsername;Password=myPassword;” * **Existing DbConnection (DatabaseConnection)**- An already opened database

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

be used in Excel Application Scope Activity. [[image:image-20220505135028-1.jpeg]] (* for mandatory

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

are supported. If the specified file does not exist, a new document file is created. E.g: “D:/input.docx” Do

does not exist, a new document file is created. Misc Public (Checkbox) - If you check it, the data

will be closed once the activity is finished. [[image:image-20220506112026-1.png]] **In the body of activity

and Strings are supported. If the specified file does not exist, a new document file is created. E.g: “D

and Strings are supported. If the specified file does not exist, a new document file is created. **Misc

RCA.Activities.Core.InsertDataTable Description This activity allows you to insert a compatible DataTable variable in an existing Table. Returns the number of rows affected. If the constraints

=myServerAddress;Database=myDataBase;UserId=myUsername;Password=myPassword;” Existing DbConnection

in an existing Table. Returns the number of rows affected. If the constraints on the table aren't met, the activity will fail and all the written rows will be saved. [[image:image-20220506105511-1.png

/Database%20Connect/WebHome/image-20230419153435-1.png?rev=1.1||alt="image-20230419153435-1.png"]] * **Data

RCA.Activities.Excel.ExcelWriteCell Description This activity allows writing a value or formula into a specified spreadsheet cell or a range. If the sheet does not exist, a new one is created with the name specified in the Sheet Name property. If a value exists, it is overwritten. Changes are immediately saved

spreadsheet cell or a range. If the sheet does not exist, a new one is created with the name 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. [[image:image-20220505113619-1.jpeg]] (* is mandatory

are supported. Use Existing Workbook Existing Workbook (WorkbookApplication) - Use the data from an Excel file

for Excel Activities. [[image:image-20220505111836-1.jpeg]] (* for mandatory) == **In the body

WorkbookApplication variables are supported. **Use Existing Workbook** * **Existing Workbook (WorkbookApplication

not exist Alt text is null

-20230421111418-1.png]] (* is mandatory) == **In the body of activity** == * **Find picture with 'Alt Text

as follows: *** Alt text does not exist *** Alt text is null

RCA.Activities.Excel.WriteCell Description This activity allows you to write a value or formula 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

spreadsheet cell or a range. If the sheet does not exist, a new one is created. [[image:image-20220505135743-1.jpeg]] (* for mandatory) == **In the body of activity** == * **Workbook Path** - The path