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
Last author
- 14Giang Tran
- 14VuNH54
- 4Nga Nguyen
- 3admin
- 1DatPT
- … 1 more
Creator
- 26Giang Tran
- 4Nga Nguyen
- 4admin
- 2VuNH54
- 1LongVA
Last modification date
Creation date
Object type
Uploaded by
- 27Giang Tran
- 4Nga Nguyen
- 3VuNH54
- 2LongVA
- 2admin
Upload date
[1] Getting Started with akaBot Center
Located in
- 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
Located in
- 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
[8] Dashboard
Located in
- 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
Select File
Located in
- 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
Located in
- 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 Range
Located in
- 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
Read Row
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
…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
Located in
- 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
Located in
- 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
Located in
- 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
next page »
Page
1
2
3
4
RSS feed for search on [excel-select-range]