Search: element-exists-1

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

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

sessions of this same user. They do not exist after this user logs off and back on. ・Local Computer

was successful or not. [[image:image-20220505151253-1.png]] (* for Mandatory) == **Properties** == **Input

. They are not visible to other logon sessions of this same user. They do not exist after this user logs off and back

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

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

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

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

RCA.Activities.Excel.AppendRange Description This activity allows you to add the information stored in a DataTable variable to the end of a specified Excel spreadsheet. If the sheet does not exist, a new one is created with the name indicated in the Sheetname field. (* for mandatory) In the body

variable to the end of a specified Excel spreadsheet. If the sheet does not exist, a new one is created with the name indicated in the Sheetname field. [[image:image-20220505140101-1.jpeg]] (* for mandatory

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

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

-20220506105340-1.png]] (* for Mandatory) == **In the body of activity** == * **Configure Connection **- Set

/Database/Activities/Database%20Connect/WebHome/image-20230419153435-1.png?rev=1.1||alt="image-20230419153435-1.png"]] * **Edit Query** - SQL command to be executed. This field must be completed according