Search: excel-select-range

[1] Getting Started with akaBot Center

Located in

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

Located in

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

Located in

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

Located in

Last modified by admin on 2024/01/11 18:39

Rendered document content: . The numbers at the top are totals that have accumulated during your selected date range. Below these numbers
…
This statistic shows the total number of documents uploaded to akaBot Vision in the date range. 2. Successfully
…
includes documents that were imported before the specified time frame the user set at the "Date Range
Raw document content: accumulated during your selected date range. Below these numbers, the time series represent the quantities
…
, the values on the x-axis represent time ranges as defined by a selected granularity. [[image:1704973235630
…
to akaBot Vision in the date range. == **2. Successfully Processed** == This statistic shows the total

Located in

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

Located in

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

Located in

Last modified by Giang Tran on 2022/05/13 06:53

Rendered document content: RCA.Activities.Excel.ReadRange Description This activity allows you to read the Excel range
…
Options Add Headers - If you select this, the column headers from the specified spreadsheet range
…
(DataTable) - Stores the data extracted from the specified Excel range in a data table variable. Only data
Title: Read Range
Location: Excel Activities
…
Read Range
Raw document content: " %) ((( RCA.Activities.Excel.ReadRange == **Description** == This activity allows you to read the Excel range and store
…
. E.g: Read Range **Options** * **Add Headers **- If you select this, the column headers from the specified spreadsheet range are also extracted. By default, this check box is selected (set to True

Located in

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

Located in

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

Located in

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