Search: excel-select-range

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

Results 1 - 10 of 23 next page » Page 1 2 3

[1] Getting Started with akaBot Center

Last modified by admin on 2023/07/04 10:21
Rendered document content
accept text value Int32 This field only accept integers number. Int32 range is from - 2,147,483,648
reflected Date and Time. It could be manually inputted selected from a calendar. Input searching This field allows user to search by inputting text value as well as select items from a list. Drop down list A list
Raw document content
|**Int32**|This field only accept integers number. Int32 range is from - 2,147,483,648 to 2,147,483,647
reflected Date and Time. It could be manually inputted selected from a calendar. |**Input searching**|This field allows user to search by inputting text value as well as select items from a list. |**Drop down

Customize Dashboards

Last modified by admin on 2023/12/11 17:19
Rendered document content
types of charts ranging from the most basic ones. Tableau Chart Catalog: A compilation of 100 basic to advanced types of charts, including a wide range of creative charts to serve various purposes. Duplicating
, 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
/profile/josh.weyburne/viz/CookBook/VizCookbook]]: A compilation of 52 different types of charts ranging
=no]]: A compilation of 100 basic to advanced types of charts, including a wide range of creative charts to serve
in different formats: as a PDF file, as an image file, as a CSV file, as an Excel file, or as a PowerPoint file

[1] About Data Service

Last modified by admin on 2023/12/21 22:15

Select File

Last modified by DatPT on 2023/04/12 17:41
Rendered document content
RCA.Activities.Core.SelectFile Description This activity opens a dialog, allows you to select a file and returns full path of the selected file. Properties Input Filter (String) – Used to specify the type of file you want to select. This filter should contain a description of the filter
Title
Select File
Location
Select File
Raw document content
" %) ((( RCA.Activities.Core.SelectFile == **Description** == This activity opens a dialog, allows you to select a file and returns full path of the selected file. [[image:image-20220505093334-1.jpeg]] == **Properties** == **Input** * **Filter (String) **– Used to specify the type of file you want to select. This filter should contain

Excel Set Range Color

Last modified by Giang Tran on 2022/05/13 06:48
Rendered document content
of a specified cell or cell range using a Color variable. Can only be used within the Excel Application Scope
that contains the cell you want to color. E.g: “Name of the sheet” Range (String)* - The range of data
. E.g: Set Range Color
Title
Excel Set Range Color
Location
Excel Set Range Color
Excel Activities
Raw document content
" %) ((( RCA.Activities.Excel.ExcelSetRangeColor == **Description** == This activity allows changing color of a specified cell or cell range using a Color variable. Can only be used within the Excel Application Scope activity. [[image:image
)* **- The name of the sheet that contains the cell you want to color. E.g: “Name of the sheet” * **Range

Read Row

Last modified by Giang Tran on 2022/05/13 06:53
Rendered document content
) In the body of activity Workbook Path (String)* - The path of the Excel file you want to read. E.g: “C
in with "A1". E.g: "A1" Workbook Path (String)* - The path of the Excel file you want to read. E.g: “C
] Read Row Options Preserve Format (Boolean) - Selecting this check box keeps the formatting of the row
Location
Excel Activities
Raw document content
]] (*for mandatory) == **In the body of activity** == * **Workbook Path (String)*** - The path of the Excel
". E.g: "A1" * **Workbook Path (String)*** - The path of the Excel file you want to read. E.g: “C
. E.g: [841596479] Read Row **Options** * **Preserve Format (Boolean) **- Selecting this check box

Export Chart

Last modified by Giang Tran on 2022/05/13 06:52
Rendered document content
RCA.Activities.Excel.ExcelExportChart Description This activity allows you to export charts or graphs from a specified Excel file as images. (* for mandatory) Properties Input Image Format (DropDownList)* - Select the file type that you want to save the exported chart/graph as. It contains 3 types
Location
Excel Activities
Raw document content
Excel file as images. (% class="wikigeneratedid" id="H" %) [[image:image-20220505134428-1.jpeg]] (* for mandatory) == **Properties** == **Input** * **Image Format (DropDownList)* **- Select the file

Excel Copy Paste Range

Last modified by Giang Tran on 2022/05/13 04:28
Rendered document content
range. You can select between Value, Formula, Number Format, Cell Format and All.
RCA.Activities.Excel.ExcelCopyPasteRange Description This activity allows to copy a range
, this is filled in with "Sheet1." Only String variables and strings are supported. E.g: “Sheet name” Source Range
Title
Excel Copy Paste Range
Location
Excel Copy Paste Range
Excel Activities
Raw document content
)** - A dropdown specifying what additional data to copy for the specified range. You can select between Value
" %) ((( RCA.Activities.Excel.ExcelCopyPasteRange == **Description** == This activity allows to copy a range or sheet (including values, formulas
: “Sheet name” * **Source Range (String)*** - The range of the data you want to copy. This field supports

Excel Delete Range

Last modified by Giang Tran on 2022/05/13 04:31
Rendered document content
RCA.Activities.Excel.ExcelDeleteRange Description This activity allows deleting a specified range in an Excel workbook. Can also be used to shift an entire row or column by using the ShiftCells
variables and strings are supported. E.g: “Employee Data” Range (String)* - The range you want to delete
Title
Excel Delete Range
Location
Excel Delete Range
Excel Activities
Raw document content
" %) ((( RCA.Activities.Excel.ExcelDeleteRange == **Description** == This activity allows deleting a specified range in an Excel workbook
Data” * **Range (String)* **- The range you want to delete. This field supports only strings
Range **Options** * **ShiftCells (Checkbox) **- If you check it, cell formatting is shifted

Excel Insert Or Delete Rows

Last modified by Giang Tran on 2022/05/13 06:19
Rendered document content
or removal begins. By default, this is filled in with 1. E.g: 2 Input Change Mode (Dropdown List) - Selects
edit the name of the activity to organize and structure your code better. E.g: [038325762] Excel Insert
Title
Excel Insert Or Delete Rows
Location
Excel Activities
Excel Insert Or Delete Rows
Raw document content
, this is filled in with 1. E.g: 2 **Input** * **Change Mode (Dropdown List) **- Selects whether
. E.g: [038325762] Excel Insert Or Delete Rows **Options** * **CopyOrigin (Dropdown List
next page » Page 1 2 3
RSS feed for search on [excel-select-range]
Created by admin on 2022/04/17 14:38