Avo Assure
Avo Assure - User Guide v25
Avo Assure - User Guide v25Avo Assure - User Guide v24.1
Avo Assure - User Guide v25
Avo Assure - User Guide v25Avo Assure - User Guide v24.1
  • Getting Started with Avo Assure
    • Commence Avo Journey
    • Support & Learning Sphere
  • Introduction to Avo Assure
    • Release Notes
      • Release Notes - Assure v25.1.0
      • Release Notes - Assure v24.2.5
      • Release Notes - Assure v24.2.4
      • Release Notes - Assure v24.2.3
      • Release Notes - Assure v24.2.2
      • Release Notes - Assure v24.2.1
      • Release Notes - Assure v24.2.0
        • ​Folder Structure
        • Element Repository
        • Tools in Element Repository
        • Information Panel
        • End to End Enhanced
        • Creating Test case
        • Test case Creation
        • Authoring a Test case
        • Recovery Steps
        • Re-usability
        • Assign a Test case
        • Execution Profile
        • Self Healing
        • Reports
        • Integrations
    • Glossary
      • Icons Library
    • Supported Technologies
    • Avo Assure Client
      • Download Avo Assure Client
      • Install Avo Assure Client
      • Uninstall Avo Assure Client
      • Update Avo Assure Client
      • Features of Avo Assure Client
        • Top pane
          • Console Logs
          • Configuration
          • Logger Level
        • Action Pane
  • Avo Assure Architecture
  • Avo Assure Installation Requirements
    • System Requirement
      • Server Requirements for Avo Assure Installation
      • Client Side Requirement
    • Browser Requirement
      • Windows
      • Mobile
      • MacOS
  • Administration
    • Authentication Configuration
      • LDAP Configuration
      • SAML Configuration
    • User Management
      • Create User
      • Manage User
      • Delete User
      • Users Roles
    • Feature Management
      • LLM Model
      • AI Template
    • Email Server Configuration
    • Agent
      • Install and Configure Agent
      • Manage Agent
      • Work with Avo Agent
    • Avo Assure Grid
      • Create Grid
      • Work with Grid
    • Session Management
    • Privileges
    • Manage Projects
      • Create Project
      • Manage Project
    • Locked Test case
    • License Details
  • Working with the Avo Assure Platform
    • Getting Assure Ready for Automation
      • Accessing Assure Instance
      • Prerequisite to work with Avo Assure Client
      • Prerequisite to work with Avo Assure Agent
      • Prerequisite to work with Avo Genius
        • Install Avo Genius Extension Manually
        • Install Avo Genius from Store
        • Install Avo Genius from Avo Assure Platform
    • Explore Landing Page of Avo Assure
    • Projects in Avo Assure
      • Create Projects
      • Manage Projects
    • Create and Execute Tests with Design Studio
      • Working with Element Repository Section
        • Create Element Repository
          • Create elements manually
          • Capture elements using capture window
            • Web
            • SAP
            • Desktop
            • Mainframe
            • Web Services
            • OEBS
        • Manage Element Repository
          • Operations in Element Repository
          • Operations on element(s)
          • Map, Compare & Replace elements
          • Reorder Element & Element Properties in Repository
        • Import & Export Element Repository
        • Features in Element Repository
          • Search Element, Folder or Element Repositories
          • Element Count
          • Element Identifier Order
          • View Screenshot
          • Delete
          • Information Panel
          • Expand & collapse
        • Self Heal Setting
      • Working with Test Case Section
        • Create Test Case
        • E2E Flow (End-to-End Flow)
        • Create Test Step Group
          • Add new test steps group
            • Add from repository
            • Add Manually
          • Add test steps group from Reusable Library
          • Record test step group using Avo Genius
        • Debug Test Case
        • Reusable Library
          • Ways to Create Reusable Library
          • Using Reusable library in Test Cases
          • Removing Reusable library from Test Case
          • Detaching Reusable library from Test Case
        • Recovery Steps
          • Ways to create Recovery Steps
        • Import & Export Test Case
          • Features in Test Case Section
            • Search Folder, Test Cases, Reusable Library or Recovery Steps
            • Assign Test Case
            • Tag Test Case
            • Skip Test Steps
            • Copy & Paste
            • Delete
            • Rename Test Cases and Test Step Groups
            • Expand & collapse
            • Information Panel
      • Recording a Test Case with Avo Genius
        • Ways to invoke and use Avo Genius
        • Recording Web & SAP test cases/test step group
      • Working with Execution Section
        • Create Execution List
          • Functional Test
          • Accessibility Test
        • Execute Execution List
          • Run Execution List using Execute option
            • Execute on Client
            • Execute on Grid
          • Schedule Execution List Runs
          • Run Execution List using Cloud Test option
          • Run Execution List using DevOps option
        • Features in Execution List Section
          • Search Folder and Execution List
          • Reorder Test Cases in Execution List
          • Edit Execution List Configuration
          • Delete
          • Rename Execution List
          • Expand & collapse
          • Information Panel
    • Working with Reports section
      • Ways to navigate to Report
      • Read a Report
      • Downloading Report
      • Log a bug from View Report
        • JIRA
        • Azure DevOps
      • Features in Report Section
        • Search Folder and Execution List in Report section
        • Expand and collapse Test Case
        • View Screenshot
        • Total Test Cases Count
  • Avo Intelligence (Gen AI)
    • Generate AI Test case by Uploading Requirements Document
  • Utilities
    • Encryption
    • Data Table
    • Data Parametrization
      • Through Excel Sheet
      • Through Data Table
  • Dashboard
    • Ways to navigate to Dashboard
    • Features of Dashboard
    • Ways to add widget
      • Default
      • Custom
  • Integrations in Avo Assure
    • Jira
      • Pre-requisites
      • Configuring Jira in Avo Assure
      • Loggin an Issue
    • Azure DevOps
      • Pre-requisites
      • API Token generation in Azure DevOps
      • Configuring Azure DevOps in Avo Assure
      • Logging an Issue
    • Zephyr
      • Prerequisites
      • Configuring Zephyr in Avo Assure
    • Zephyr Scale
      • Prerequisites
      • Configuring Zephyr Scale in Avo Assure
      • View Reports in Zephyr Scale
    • Browser Stack
      • Prerequisites for Browser Stack
      • Normal Execution on Browser Stack
      • Parallel execution on Browser Stack
    • Bitbucket
      • Prerequisites
      • Configuring Bitbucket in Avo Assure
      • Bitbucket commit/Push
      • Bitbucket restore
      • Edit Bitbucket configuration fields
    • CI/CD Harness
      • Prerequisites
      • Copy DevOps Integration URL and DevOps Request Body in Avo Assure
      • Configuring CI/CD Harness in Avo Assure
    • CI/CD Azure DevOps
      • Prerequisites
      • Navigate to Code Snippet
      • Configuring CI/CD Azure DevOps in Avo Assure
  • Actions
    • Generic
      • String Operations
        • String Generation
        • Trim
        • Convert to Upper case
        • Convert to Lower case
        • Get String Length
        • Get Sub String
        • Left
        • Mid
        • Right
        • Concatenate
        • Find
        • Replace
        • Split
        • Type Cast
        • Compare Values
        • Compare Values
        • String action - Find
      • Interrupt Operations
        • Pause Execution
        • Wait
        • Stop Execution
      • Date Operations
        • Get Current Day
        • Get Current Date
        • Get Current Time
        • Change Date Format
        • Date Addition
        • Month Addition
        • Year Addition
        • Date Difference
        • Compare Date
      • Database Operations
        • Get Data
        • Verify Data
        • Export Data
        • Run Query
        • Get Data Securely
        • Verify Secure Data
        • Export Data Securely
        • Run Query Securely
      • Mathematical Operations
        • Evaluate
      • File and Folder Operations
        • Beautify
        • Compare Files
        • Compare Inputs
        • Normalize PDF
        • Get File Content
        • Get Line Number
        • Replace Content
        • Verify Content
        • Verify File Images
        • Get Image Similarity Percentage
        • Compare Content
        • Clear File Content
        • Write to File
        • Cell by Cell Compare
        • Selective Cell by Cell Compare
        • Find Image in PDF
        • Compare PDFs
        • Save File
        • Create Folder
        • Verify Folder Exists
        • Rename Folder
        • Delete Folder
        • Create File
        • Verify File Exists
        • Rename File
        • Delete File
        • Move File/Folder
        • Copy File/Folder
        • Find File Path
        • Get PDF Page Count
        • Execute File
      • Variable Operations
        • Create Dynamic Variable
        • Delete Dynamic Variable
        • Create Constant Variable
        • Modify Variable Value
        • Copy Value
        • Display Variable Value
        • Get index count
        • Delete Constant Variable
      • Loops and Condition Operations
        • If
        • Else
        • Else-If
        • EndIf
        • For
        • End-For
        • Get Param
        • Start Loop
        • End Loop
      • Skip Operations
        • Jump Steps By
        • Jump To 'TestSteps'
      • XML and Json Operations
        • Get Block Count
        • Get Block Value
        • Get Tag Value
        • Compare JSON Content
        • Get XML Block Data
      • Other Operations
        • Verify Objects
        • Save To Clipboard
        • Get from Clipboard
        • Send Function Keys
        • Null Check
        • Get Key Status
        • Send Secure Function Keys
    • Excel
      • Set Path for File
      • Clear Excel File Path
      • Get Total Column Count
      • Get Total Row Count
      • Read cell From File
      • Write to Cell in File
      • Clear Cell in File
      • Delete Row in File
      • Excel Workbook
      • Get row data
      • Copy of Get row data
      • Get Row and Column
      • Sheet Name
      • Verify excel Empty
      • Verify Column Value in Excel
      • Check the column exist
    • Web
      • Browser
        • Open Browser
        • Navigate to URL
        • Maximize Browser
        • Get Browser Name
        • Get Current URL
        • VerifyCurrentURL
        • Get Page Title
        • VerifyPageTitle
        • VerifyTextExist
        • Navigate Back
        • Navigate to Page with Authentication
        • Refresh Browser
        • Switch to different Window
        • Open New Tab
        • Send Keystrokes
        • Save File
        • Bring Browser to Foreground
        • Clear the Cache
        • Close all Sub Windows
        • Close Browser
      • Browser Popup
        • Accept Popup
        • Dismiss Popup
        • Get Popup Text
        • Verify Popup Text
      • Button
        • Perform Click
        • Simulate Press Action
        • Double Click
        • Upload FIle
        • Get Button Name
        • Verify Button Name
      • Checkbox
        • Select Checkbox
        • Unselect Checkbox
        • Get Object Status
      • Radio Button
        • Get Object Status
        • Select Radio Button
      • Textbox
        • Clear Text From Cell
        • Click on Object
        • Get Text From Object
        • Get Textbox Length
        • Simulate Press Action
        • Send Keystrokes Securely
        • Send Keystrokes Values
        • Set Secure Text
        • Set Text
        • verify Text
        • verify Textbox Length
        • Send Secure Function Keys
        • Double Click
      • Link
        • Click
        • Press element
        • Upload a File
        • Verify Link Text
        • getLinkText
        • doubleClick
      • Element
        • Click On Element
        • Double Click
        • Get Text of Element
        • Upload File
        • Verify Element Text
      • Dropdown
        • Get all Value from List
        • Get List Count
        • Get Selected Value from Dropdown
        • Get Value by Index
        • Select Based on Absolute Value
        • Select Value by Index
        • Select Value by Text
        • Verify All Values
        • Verify Count
        • Verify Selected Value
        • Verify Values Exists
        • Selectby value
      • List
        • Deselect All Values from List
        • Get Multiple Values by Indexes
        • Select all Values From List
        • Select Multiple Value by Indexes
      • Image
        • Click on Image
        • Double Click on Object
        • Simulate Press Action
        • Get Image similarity Percentage
        • Upload File to Application
        • verifyWebImages
      • Table
        • Get Tool Tip text from Cell
        • Get Cell Value
        • Get Column Number by Text
        • Get Total Column Count
        • Get Total Row Count
        • Get Row Number by Text
        • Get Object Status
        • Simulate Mouse Click
        • Select Based on Absolute Value
        • Select Value by Index
        • Select Value by Text
        • VerifyCellToolTip
        • Verify Cell Value
        • Verify Text Exist
        • Set Text
        • Send Keystroke Value
        • Set Secure Text
        • Clear Text From Cell
        • Get Text from Object
        • Get Textbox Length
        • VerifyText
        • VerifyTextboxLength
        • Double Click Tab Cell
        • Send Function Keys Securely
        • Selectby value
      • Table Cell
        • Click on Element
        • Double Click on Object
        • Simulate Press Action
      • Common Web Operations
        • DropFile
        • VerifyAttribute
        • VerifyDoesNotExists
        • VerifyEnabled
        • VerifyToolTipText
        • VerifyVisible
        • Verify Exists
        • Wait for Element to be Visible
        • VerifyDisabled
        • Verify Hidden
        • Drag Object
        • Drop Object
        • Get Object Attribute Value
        • Get Element Tag Value
        • Get Tool Tip Text
        • Hover Mouse on Object
        • Right Click on Object
        • Send Function Keys as Inputs
        • Set Focus on Object
        • Simulate Tab Keypress
        • Drop File On the Object
        • verifyAttribute
      • Custom
        • Click on Element
        • Double Click on Object
        • Get Text of Element
        • Get Specific Object
        • Get Object Status
        • Get Text From Object
        • Right Click on Object
        • Select Radio Button
        • Select Value by Index
        • Select Value by Text
        • Set Focus on Object
        • Set Text
        • Set Secure Text
        • Unselect Checkbox
        • Select Checkbox
        • verifyDoesNotExists
        • verifyElementText
        • verifyExists
        • Get Tool Tip Text
        • verifyToolTipText
        • Hover Mouse on Object
        • Send Function keys as Inputs
        • Send Keystroke Values
        • Simulate Tab Keypress
        • verifyVisible
        • Wait for Element to be Visible
        • Get Object Count on Web Page
        • Send Keystrokes Securely
        • Get all Values from List
        • verifyAllValues
        • Scroll Vertically
        • Send FunctionKeys Securely
        • Click on Object
        • Delete Text
        • Get Text field Length
        • verifyText
        • Get Button Name
        • verifyButtonName
        • Get Link Text
        • verifyLinkText
        • verifyWebImages
        • Get Image similarity Percentage
        • Upload a File
        • Drop File On the Object
        • Get List Count
        • Get Value by Index
        • verifyCount
        • verifySelectedValue
        • verifyValuesExists
        • Get row data
    • API
      • Web Service List
        • Set end point URL
        • Set Methods
        • Set operation
        • Set header
        • Set header template
        • Set whole body
        • Execute request
        • Get header
    • SAP
      • Operations
        • Launch Application
        • Server Connect
        • Start Transaction
        • Toolbar Button
        • Select Menu
        • Get Page Title
        • Get Pop Up Text
        • Get Status Bar Message
        • Get Dialog Window Name
        • Double Click Status Bar
        • Restore Window
        • Minimize Window
        • Maximize Window
        • Close Window
        • Close Application
      • Common Operations
        • Set Focus
        • Mouse Hover
        • Click
        • Double Click
        • Verify Hidden
        • Verify Enabled
        • Verify Disabled
        • Verify Exists
      • Textbox Operations
        • Clear Text
        • Set Text
        • Set Secure Text
        • Get Text
        • Verify Text
        • Get Textbox Length
        • Verify Textbox Length
        • Get Input Help
      • Button Operations
        • Get Button Name
        • Verify Button Name
      • RadioButton Operations
        • Select Radio Button
        • Get Status
      • Checkbox Operations
        • Get Status
        • Select Checkbox
        • Unselect Checkbox
      • Dropdown Operations
        • Get Count
        • Verify Count
        • Get Value by Index
        • Get Key By Index
        • Get All Key Value Pairs
        • Select Value by Text
        • Select Value by Index
        • Select Key By Text
        • Get Selected Value
        • Verify Selected Value
        • Verify All Values
        • Verify Values Exist
      • Table Operations
        • Scroll Up
        • Scroll Down
        • Scroll Left
        • Get Column Count
        • Get Row by Text
        • Get Column by Text
        • Get Table Cell Value
        • Get Cell Status
        • Get Icon Name
        • Get Input Help
        • Select Row
        • Unselect Row
        • Select Column
        • Unselect Column
        • Verify Cell Value
        • Verify Text Exists
      • Scroll Operations
        • Scroll Up
        • Scroll Down
        • Scroll Left
        • Scroll Right
      • Tree Control Operations
        • Select Tree Element
        • Get Tree Node Text
        • Get Tree Node Count
        • Get Column Value of Selected Tree Node
        • Collapse Tree
        • Verify Tree Path
        • Select Tree Node
      • GridView Control Operations
        • Get Grid Row Count
        • Get Grid Column Count
        • Get All Column Headers
        • Get Column Numbers by Headers
        • Get Row Column Num by Text
        • Get Cell Text
        • Scroll to Row Number
        • Select Rows
        • Select All Rows
        • Unselect all Selections
        • Select Columns
        • Unselect Columns
        • Click Cell
        • Double Click Cell
        • Set Text in Cell
        • Press Toolbar Button
      • Calendar Operations
        • Select Date
        • Select Week
        • Select Month
        • Select Date Range
      • Tabs
        • Select Tab
    • Desktop
      • Window
        • Launch Application
        • Select Window
        • Get Page Title
        • Maximize Window
        • Minimize Window
        • Select Menu
        • Close Sub Window
        • Close application
      • Button
        • Click
        • Double Click
        • Get button name
      • Checkbox
        • Select checkbox
        • Unselect checkbox
        • Get element status
      • Radio Button
        • Select radio button
        • Get Element Status
      • Dropdown
        • Get count
        • Select value by index
        • Select value by text
        • Get selected value
        • Verify selected value
        • Get value by index
        • Verify count
        • Verify value exists
        • Get all value
        • Verify all value
      • List
        • Get multiple Value By Index
        • Select multiple list values by text
        • Select multiple Value By Indexes
        • Select all list values
        • Deselect all list values
      • Tab
        • Select tab by Index
        • Select tab by text
        • Get tab name
        • Verify selected tab
      • Date Time Picker
        • Get date
        • Set date
      • Table
        • Get Colum Number by Text
        • Get Row Number by Text
        • Get Row Count
        • Get Column Count
        • Get cell value
        • Verify cell value
        • Click cell
        • Double click cell
        • Select Row
      • IRIS
        • Common IRIS Keywords
          • Click IRIS
          • Double Click IRIS
          • Get Text IRIS
          • Right Click IRIS
          • Verify Exists IRIS
          • Verify Text IRIS
          • Mouse Hover IRIS
          • Drag IRIS
          • Drop IRIS
        • Table
          • Right Click Cell IRIS
          • Mouse Hover Cell IRIS
          • Get Row Count IRIS
          • Get Column Count IRIS
          • Get Cell Value IRIS
          • Verify Cell Value IRIS
          • Click Cell IRIS
          • Double Click Cell IRIS
          • Set Cell Value IRIS
        • Scroll
          • Scroll Up IRIS
          • Scroll Down IRIS
          • Scroll Left IRIS
          • Scroll Right IRIS
        • Textbox
          • Set Text IRIS
          • Set Secure Text IRIS
          • Clear Text IRIS
        • Checkbox/Radio Button
          • Get Status of IRIS
    • Mainframe
      • Close mainframe
      • Connect Session
      • Disconnect session
      • Get text
      • Launch mainframe
      • Set Text
      • Verify Text Exists
      • Log off from Mainframe
      • Login to Mainframe
      • Secure Log in to Mainframe
    • Custom Action
      • Creation of Custom Action
      • Edit Custom Action
    • Grid
      • Get Column Data
      • Sort Table
      • Verify Value in Table
      • Verify Column Header
      • Verify Table Sort
Powered by GitBook
LogoLogo
On this page

Was this helpful?

  1. Actions
  2. Excel

Get Row and Column

PreviousCopy of Get row dataNextSheet Name

Last updated 1 day ago

Was this helpful?

This is a pre-built action in Avo Assure and comes under @Excel element. This action allows the user to retrieve the row or column containing a specified value from an Excel sheet, making it easier to locate and work with specific data within the file.

Syntax

Input: <text>

Argument
Description

text

requited text

Output: <Dynamic Variable>(Optional)

Example 1

The Get Row and Column action retrieves the row and column location of a specific value in a Excel sheet. For example, when searching for Employee ID (EMP102), the action returns the row number as 29 and the column name as Employee ID