Search: excel-read-range

Activities

Located in

Last modified by admin on 2022/07/01 15:42

Rendered document content: LookUp Range Excel Read Cell Excel Read Range Excel Remove Duplicates Range Excel Save As Workbook Excel
…
Write Cell Excel Write Range Execute Macro Export Chart Read Column Read Range Read Row Write Cell Write
…
Append Range Excel Append Range Excel Application Scope Excel Close Workbook Excel Copy Paste
Location: Excel Activities
Raw document content: /]] * [[Excel Read Range>>url:https://docs.akabot.com/bin/view/Activities/Excel%20Activities/Activities/Excel
…
%20Column/]] * [[Read Range>>url:https://docs.akabot.com/bin/view/Activities/Excel%20Activities/Activities
…
/Excel%20Activities/Activities/Append%20Range/]] * [[Excel Append Range>>url:https://docs.akabot.com/bin

Located in

Last modified by admin on 2022/05/18 09:52

Rendered document content: The Excel Activities offers deep integration with Microsoft Excel and ships with a number of activities that automate the tasks you perform in Excel. These activities enable the robots to: Read information from a cell, columns, rows or ranges, and write to other spreadsheets or workbooks. Execute macros
Title: Excel Activities
Location: Excel Activities
Raw document content: The Excel Activities offers deep integration with Microsoft Excel and ships with a number of activities that automate the tasks you perform in Excel. These activities enable the robots to: * ((( Read information from a cell, columns, rows or ranges, and write to other spreadsheets or workbooks. ))) * Execute

Located in

Last modified by admin on 2023/05/21 23:26

Rendered document content: What's New [Added] Added Excel Set Range Format activity: This activity allows user to format cells and ranges according to a specific format. [Added] Screen Status Check Activity: This activity
…
and automate Excel tasks using Visual Basic for Applications. Insert VBA Activity: This activity allows you
Raw document content: ** == * [Added] Added Excel Set Range Format activity: This activity allows user to format cells and ranges
…
for working with VBA code within your automation workflows, empowering you to customize and automate Excel
…
new VBA code into a workbook or a specific module. It helps you extend the functionality of your Excel

Located in

Last modified by admin on 2023/12/11 17:19

Rendered document content: . For detailed instructions on how to proceed next, we recommend reading Tableau’s guides for creating dashboards
…
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
Raw document content: recommend reading Tableau’s guides for creating dashboards, found below. (% style="font-family:Arial
…
/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

Located in

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

Located in

Last modified by admin on 2024/04/22 16:12

Objects: /Activities/Append%20Range/">Append Range</a> <a href="/bin/view/Activities/Excel%20Activities/Activities/Excel%20Append%20Range/">Excel Append Range</a> <a href="/bin/view/Activities/Excel
…
%20Activities/Activities/Read%20CSV%20File/">Read CSV File</a> <a href="/bin/view/Activities/CSV

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
…
Workbook Path (String)* - The path of the Excel file you want to read. E.g: “C:\FolderName\SaleReport.xlsx” Sheet name (String)* - The sheet you want to read. E.g: "Sheet1" Range - Range of the data. If it isn’t
Title: Read Range
Location: Read Range
…
Excel Activities
Raw document content: " %) ((( RCA.Activities.Excel.ReadRange == **Description** == This activity allows you to read the Excel range and store in a DataTable variable. If the range isn’t specified, the whole spreadsheet starting from that cell is read
…
) == **In the body of activity** == * **Workbook Path (String)*** - The path of the Excel file you want to read

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
…
RCA.Activities.Excel.ReadRow Description Reads the values from a row beginning with the cell
Title: Read Row
Location: Excel Activities
…
Read Row
Raw document content: ". E.g: "A1" * **Workbook Path (String)*** - The path of the Excel file you want to read. E.g: “C
…
" %) ((( RCA.Activities.Excel.ReadRow == **Description** == Reads the values from a row beginning with the cell specified
…
]] (*for mandatory) == **In the body of activity** == * **Workbook Path (String)*** - The path of the Excel

Located in

Last modified by Giang Tran on 2022/05/13 04:28

Rendered document content: 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 (String)* - The range of the data you want to copy. This field supports only strings and String variables
Title: Excel Copy Paste Range
Location: Excel Copy Paste Range
…
Excel Activities
Raw document content: " %) ((( 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 only strings and String variables. E.g: “Source range” **Misc** * **Public (Checkbox) **- Check