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.2
      • Release Notes - Assure v25.1.1
      • 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 for Web and Desktop
          • 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
        • Get Current Day, Date, 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
      • Data Table
        • Write to Data Table
    • 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
      • Copy Excel Workbook
      • Get Row Data
      • Get Row and Column
      • Sheet Name
      • Verify excel Empty
      • verify the column value in excel
      • checks the column exists
    • 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
    • Grid
      • Get Column Data
      • Sort Table
      • Verify Value in Table
      • Verify Column Header
      • Verify Table Sort
    • Word
      • Read PDF
    • Custom Action
      • Creation of Custom Action
      • Edit Custom Action
Powered by GitBook
LogoLogo
On this page

Was this helpful?

  1. Actions
  2. Excel

Sheet Name

PreviousGet Row and ColumnNextVerify excel Empty

Last updated 21 days ago

Was this helpful?

This is a pre-built action in Avo Assure and comes under @Excel element. This action will allow user to retrieve the Excel file name, enabling them to identify the file and begin performing actions on it efficiently.

Syntax

Input: <excel path>

Argument
Description

excel path

Path of excel sheet

Output: <Dynamic Variable>(Optional)

Example 1

Use the Sheet Name action to obtain the file name. In below example, Project Report is the name of the file to be retrieved