Home
/
Opkey Help
/
/
25.7 Excel Keywords

25.7 Excel Keywords

Excel_VerifyCellValue

Excel_VerifyColumnCount

Excel_VerifyRowCount

Excel_ClearCellValue

Excel_ClearColumn

Excel_ClearRows

Excel_Close

Excel_CloseAll

Excel_CompareCellValue

Excel_CompareColumns

Excel_CompareRows

Excel_CompareSheet

Excel_CopyAndPasteCellValue

Excel_CreateFile

Excel_DeleteRow

Excel_DuplicateSheet

Excel_GetCellValue

Excel_GetColumnCount

Excel_GetColumnValue

Excel_GetRowCount

Excel_GetRowValue

Excel_InsertBlankRows

Excel_Open

Excel_RenameSheet

Excel_SetBackGroundColor

Excel_SetCellTextColor

Excel_SetRowValue

Excel_SetColumnValue

Excel_UtilityPressKeys

Excel_SetCellValue

‍

Article

25. Opkey Keyword Documentation
table of contents
1. A Quick Opkey Walkthrough
1. A Quick Opkey Walkthrough
1.1 Automate your first test case in less than 5 minutes
1.2 Quick Start Screencast
10. Working with Coded Function Library
10.1 Prerequisites of Coded Function Library
10.2 Getting started with Coded Function Library
10.3 Using Coded Function Library – Common Scenarios
10.4 Sharing data from one Coded FL to another Coded FL
11. Model Based Testing with Opkey
11.1 Working with Model
12. Working with Suites
12.1 Working with Java Exporter
12.2 Scheduling a Suite
12.22 Procure to Pay -Part 2
12.23 Procure to Pay -Part 3
12.24 Procure to Pay – Part 4
12.26 Order to Cash -Part 2
13. Using Global Variables
13. Using Global Variables
14. Working with Service Repository (Testing web services)
14.1 Adding Soap Service
14.2 Adding Rest Service
14.3 Authentication of Web Services
14.4 Executing Web services
14.5 Salesforce API Impact Analysis
15. Execution & Result
15.1 Execution
15.10 Execution Result Reports
15.11 Live Test Execution on Remote Machine
15.12 Execution Result Dashboard
15.2 Execution on OpKey Cloud
15.3 Execution on BrowserStack
15.4 Grid Execution and Session Queuing
15.5 Grid Execution on BrowserStack
15.6 Scheduler
15.7 Execution on Sauce Labs
15.8 Execution of Mobile Test Script on pCloudy
15.9 Execution Result
16. Opkey Execution Agent
16.1 Configuration
16.2 Opkey Plugin Licenses
16.3 Opkey Execution Agent Update
16.4 Opkey MobiCast
17. User Profile and Admin Console
17.1 Profile
17.1 Profile
17.2 Admin Console
18. Working with BDD (Gherkin Stories)
18.1 Gherkin Syntax
18.2 Using BDD (Gherkin Stories)
19. Tools Menu
19.1 Global Variables
19.10 Grid Execution
19.11 Attachment Management
19.12 Queued Sessions
19.13 Queued Replicas
19.14 Scheduler
19.15 Auto Data Generation
19.16 API Settings – Salesforce
19.17 Token Management
19.2 Mobile Management
19.3 Keyword Management
19.4 SMTP Settings
19.5 pCloudy Dashboard
19.6 External Tool Integration
19.7 Cloud Dashboard
19.8 BrowserStack Dashboard
19.9 Sauce Labs DashBoard
2. Installing supporting components
2.1 Installing JRE (version 1.8 or above)
2.2 Downloading and installing OCC on Windows machine
2.3 Downloading and installing OCC on Mac machine
2.4 Downloading & Installing Opkey Execution Agent
2.5 Installing Opkey Smart Recorder
2.6 Installation Logs
2.7 Installing Opkey Hub
2.8 Installing Opkey Plugins
20. Working with Jenkins in Opkey Web
20.1 Installing & configuring Jenkins in Opkey Web
20.2 Executing Suite with Jenkins
21. Working with Bamboo in Opkey Web
22. External Tool Integration with Opkey Web
22.1 Working with Azure DevOps Overview
22.10 Zephyr Integration
22.11 Working with ALM Octane
22.2 Configuring & using Jira in Opkey Web
22.3.1 Working With TFS Local Server
22.3.2 Working with TFS Cloud Server
22.4 Working with qTest Manager
22.5 Working with VSTS Build
22.6 Working with VSTS Test
22.7 Working with ALM
22.8 Using ALM specific Opkey Keywords
22.9 Using MS Azure Pipeline in Opkey
23. Working with Sparkin
24. Commonly Used Features
25. Opkey Keyword Documentation
25.1 System Keywords
25.10 Salesforce Keyword
Contact us