Search: excel-select-range
Last modified by admin on 2022/04/24 04:58
Refine your search
Select a category and activate filters on the current results
Location
- 14Activities
- 1akaBot Studio
Creator
- 12Giang Tran
- 2VuNH54
- 1admin
Last modification date
Creation date
Uploaded by
- 12Giang Tran
- 3VuNH54
Upload date
[2] How to use akaBot Studio
Located in
- Rendered document content
is a solution for application integration, business processes automation. It provides a wide range of activities
…automation projects. The activities are grouped into different categories such as: Excel, XML, ControlFlow
…. The activities are grouped in different categories such as: Flow chart, Control Flow, Primitives, Core, Excel
- Raw document content
a wide range of activities to model almost of the business processes within one organization – from
…into different categories such as: Excel, XML, ControlFlow, Primitives, Care, HTTP... |4|Designer|Display you
…]] The activities are grouped in different categories such as: Flow chart, Control Flow, Primitives, Core, Excel
Excel Insert Or Delete Columns
Located in
- Rendered document content
Input Change Mode (Dropdown List) - Selects whether the activity adds or removes columns. ・Add: Add
…to organize and structure your code better. E.g: [038325762] Excel Insert Or Delete Columns Options
- Title
Excel Insert Or Delete Columns
- Location
Excel Activities
…Excel Insert Or Delete Columns
- Raw document content
) **- Selects whether the activity adds or removes columns. **・Add**: Add columns to the document. **・Delete
…and structure your code better. E.g: [038325762] Excel Insert Or Delete Columns **Options** * **CopyOrigin
Excel Read Column
Located in
- Rendered document content
the name of the activity to organize and structure your code better. E.g: [482156710] Excel Read Column Options Preserve Format (Boolean) - Selecting this check box keeps the formatting of the column that you
- Title
Excel Read Column
- Location
Excel Activities
…Excel Read Column
- Raw document content
your code better. E.g: [482156710] Excel Read Column **Options** * **Preserve Format (Boolean) **- Selecting this check box keeps the formatting of the column that you want to read. By default, the check box
Read Column
Located in
- Rendered document content
) In the body of activity Workbook Path (String)* - The path of the Excel file you want to read. E.g: “C
…, this is filled in with "A1". E.g: "A1" Workbook Path (String)* - The path of the Excel file you want to read. E.g
…] Read Column Options Preserve Format (Boolean) - Selecting this check box keeps the formatting
- Location
Excel Activities
- Raw document content
]] (* for mandatory) == **In the body of activity** == * **Workbook Path (String)*** - The path of the Excel file
…" * **Workbook Path (String)*** - The path of the Excel file you want to read. E.g: “C:\FolderName
…] Read Column **Options** * **Preserve Format (Boolean) **- Selecting this check box keeps
Excel Read Row
Located in
- Rendered document content
of an Excel row beginning from the cell specified in the StartingCell field: and stores it in an lEnumerable
…can edit the name of the activity to organize and structure your code better. E.g: Excel Read Row Options Preserve Format (Boolean) - Selecting this check box keeps the formatting of the row that you
- Title
Excel Read Row
- Location
Excel Activities
…Excel Read Row
- Raw document content
the values of an Excel row beginning from the cell specified in the StartingCell field: and stores
…. You can edit the name of the activity to organize and structure your code better. E.g: Excel Read Row **Options** * **Preserve Format (Boolean) **- Selecting this check box keeps the formatting of the row
Excel Application Scope
Located in
- Rendered document content
the macro level for the current Excel file. By default, EnableAll is selected. The drop-down contains three
…Excel Macro settings Read Only (Checkbox): Opens the specified workbook in Read-Only mode. Selecting
…RCA.Activities.Excel.ExcelApplicationScope Description This activity allows to open an Excel
- Title
Excel Application Scope
- Location
Excel Activities
…Excel Application Scope
- Raw document content
)** - Specifies the macro level for the current Excel file. By default, EnableAll is selected. The drop-down
…. Selecting this check box enables you to perform data extraction operations in an Excel file which is locked
…)**- When selected, the Excel file is opened in the foreground while performing actions on it. When
Write Cell
Located in
- 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
…content - The value or formula that you want to be written to a cell or range. Only string variables
- Location
Excel Activities
- 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
…to be written to a cell or range. Only string variables, generic variables and strings are supported. E.g
Excel Insert Image
Located in
- Rendered document content
to specified Excel Sheets. This only can be used in Excel Application Scope Activity. (* is mandatory
…\sky.png” Sheet name (String) - The sheet that you want to display. E.g: “ThisIsSheetName” Range (String) - The range you want to add image to. E.g: “K1:L1” Properties Input Image path (String)* - Input the full
- Title
Excel Insert Image
- Location
Excel Activities
…Excel Insert Image
- Raw document content
" %) ((( RCA.Activities.Excel.ExcelInsertImage == **Description** == This activity allows you to add images to specified Excel Sheets. This only can be used in Excel Application Scope Activity. (% class="wikigeneratedid" id="H
…) **- The sheet that you want to display. E.g: “ThisIsSheetName” * **Range (String) **- The range you want to add
Append Range
Located in
- Rendered document content
. E.g: “append excel range”
…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
- Title
Append Range
- Location
Excel Activities
…Append Range
- Raw document content
. E.g: “append excel range” ))) {{velocity}} #if ($xcontext.action != 'export') (% class="akb-toc
…variable to the end of a specified Excel spreadsheet. If the sheet does not exist, a new one is created
…) == **In the body of activity** == * **Workbook Path ** - The full path of the Excel spreadsheet that you want
Excel Write Cell
Located in
- Rendered document content
- The Excel cell or range that you want to write to. If the range isn't specified, the whole spreadsheet
…: “Hello world” or “=B1+C2” Properties Input Cell (String)* - The Excel cell or range that you want
…into a specified spreadsheet cell or a range. If the sheet does not exist, a new one is created with the name
- Title
Excel Write Cell
- Location
Excel Activities
…Excel Write Cell
- Raw document content
: “ClientName” * **Cell** - The Excel cell or range that you want to write to. If the range isn't specified
…)*** - The Excel cell or range that you want to write to. If the range isn't specified, the whole spreadsheet
…spreadsheet cell or a range. If the sheet does not exist, a new one is created with the name specified
next page »
Page
1
2
RSS feed for search on [excel-select-range]