Questions tagged [excel]
Spreadsheet and data analysis software from Microsoft. Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations.
54
questions
1
vote
0
answers
30
views
Test Complete Unable to load URL from Excel
Working on Test Complete Keyword driven framework, which is now migrated from Win7 to Win10. All the environment URLs configuration and actions are in Excel sheet.
Issue: During execution once the ...
2
votes
3
answers
800
views
How to pass excel column values into different test methods of a class in Java Selenium
I have an excel which contains 4 columns with N rows. Let us say Col1, Col2, Col3, Col4 are the headers.
Now I have a java class and there are 3 methods inside it.
public class test(){
@Test(...
- 21
0
votes
4
answers
5k
views
Selenium, Java, POI: How to read numeric values from Excel file?
I have a table in the Excel file like this:
I would like to read the product ID and I have the code below:
public class ReadDataFromExcel extends Page {
public static void main(String[] args) {
...
- 317
0
votes
1
answer
206
views
Quality Checks on Excel / Automation
I am tasked to complete a quality check on excel.
Background - We receive several excel files from different vendors daily. Before putting on the BI tool i need to make sure the naming convention is ...
- 11
0
votes
0
answers
151
views
How to write/insert (Embed) the image object into the excel in Selenium WebDriver (POI Jar ) using Java Programming language?
I want to insert (Embed) the image object into the excel file using poi jar. In Excel, we can able to do manually shown in the below screenshot. Similarly, I want to insert an image object through the ...
0
votes
0
answers
106
views
Creation of Test Cases for Financial Reporting
I have been tasked with creating some test cases related to financial reporting using Microsoft Excel.
I have a specific Microsoft Excel template which I have to fill in to create a good file. As in ...
- 111
0
votes
2
answers
3k
views
How to browse Excel file in JMeter?
Use case :
I need to import orders from Excel file. I need to browse a Excel file.
0
votes
1
answer
1k
views
How to fetch data from UI and passing those data as input for selenium script?
Scenario: I have to read input from UI and based on the input i have to run my selenium script.
Earlier i prepared a jar file for the same and was inserting values for the script from excel and ...
- 1
0
votes
2
answers
337
views
How do you store test data into nosql document database for quick read?
I am currently migrating our currently test data that is stored in excel files to a database. Because the type of data in the test results are going to grow we decided to go with nosql instead of sql.
...
- 130
0
votes
3
answers
1k
views
How to create test cases in order to test columns in an excel file?
I have to test an excel file which generated by the system. This file has around 40 columns in it. Do I have to create test cases for each column separately in order to test?
File ...
- 1,197
0
votes
2
answers
545
views
POM Model -Fetching mobile number from excel sheet like 9.5512395512E9
Working on Page Object Model by using Data driven Framework, fetching data from Excel sheet.When executing the test script the mobile number displays like 9.5512395512E9.
In excel sheet Original ...
- 1
1
vote
1
answer
3k
views
How to get only one row from excel which has multiple rows data? [closed]
Actually, I have written code for reading data from an excel file.
But, I want to read the first row and if required then read the second row which is not happening in my code.
I got all rows data ...
- 9
1
vote
1
answer
617
views
When submitting a form by fetching values from excel file it is showing Internal Server Error
When submitting a form by fetching values from excel file it is showing Internal Server Error but when I put static values in code and run it successfully submits the form without any error.
Here is ...
5
votes
9
answers
92k
views
Cannot get a STRING value from a NUMERIC cell. How can I resolve this issue in selenium webdriver using POI?
I am trying to read data from an excel sheet and write on my application.But shows an error while trying to pass a numeric value using string. Please suggest me how can I resolve the issue. Please see ...
- 69
-1
votes
1
answer
60
views
How to write a java programme to find unique patterns by removing duplicates for API urls?
How to write a java program to find unique patterns for API URLs?
Note: I have a file which contains 10000 API URLs with duplicates
api.csv:
http://abc.com/XMLFeed?clientkey=abtc&type=Products&...
- 567
0
votes
1
answer
916
views
Import Testresults to HP ALM with Excel AddIn
My question is, as mentioned in the headline, is it possible to import testresult from Excel into HP ALM?
Explanation:
My current task is to import all Testcases/results from Word/Excel to HP ALM. ...
- 1
3
votes
1
answer
6k
views
How to use .xlsx Excel files as Data Source for Coded UI test?
I want to use ".xlsx" format Excel file as Data Source in my hand coding Coded UI test. The best information I get is found in MSDN: Creating a Data-Driven Coded UI Test, which has useful information ...
- 523
3
votes
2
answers
996
views
Unable to open an .xlsx file with script in Selenium WebDriver - getting InvalidFormatException
I have a script that requires an excel spreadsheet to be downloaded from a website and opened, ending in an assertion that a certain value exists or not on the spreadsheet.
Getting the following ...
- 153
2
votes
4
answers
1k
views
How to use java to access excel with selenium webdriver for data for tests
How to access excel files from selenium webdriver using Java ?
I am new to selenium Webdriver, I have a scenario where I have to provide different sets of values to the different test case.
Let, us ...
1
vote
2
answers
1k
views
Zephyr to Test Rail migration - Is it possible?
We are currently looking at Testrail as an alternative to using the Zephyr plugin within JIRA as Testrail looks to give us better test case and reporting management than Zephyr does.
Currently faced ...
- 423
0
votes
1
answer
499
views
Display error while generating excel report using TestNG
I am trying to generate excel file for displaying TestNG report into excel sheet.
For that I created simple program for creating excel sheet and display static data, but it's displaying error
- 526
0
votes
1
answer
95
views
Update value in column using Apache POI
I'm writing to an existing xlsx file using Apache POI. The code updates the value in two columns, and depending on the input it may update the value for more than 1 row as well.
As you can see, after ...
- 189
2
votes
1
answer
154
views
Data Driven Framework Limitation
I am currently using a data driven framework for my automation testings with Excel.
When I have more than 255 characters, in my Excel cell my tests fail.
Are there any other alternatives with Excel ...
-2
votes
1
answer
4k
views
Is it possible to restrict images from loading using selenium web-driver? [closed]
I'm using excel selenium to scrape some information from pages with lots of images. Is it possible to make the browser don't load the images of the page? So it could be more faster.
- 1
2
votes
3
answers
1k
views
Selenium - How to copy entire excel column without using iterator
I'm new to selenium and I'm having following query.
Query: Am working on a project where I need to copy 4000 values from an excel in a single go and I need to paste that in the list box of ...
- 29
0
votes
1
answer
757
views
Is there any default defect template available, so that we can fill the sheet and upload to QC directly with all defects by the End of the day
We are forced to use HL ALM QC to raise defects. Currently we were using Rally to raise defects for Agile projects. But now on, we need to use HP QC, to raise the defects. For rally, i have created my ...
0
votes
1
answer
6k
views
Cannot get a text value from a numeric cell
Cannot get a text value from a numeric cell while reading numeric data from an xlsx file in apache poi excel read, the following is the code snippet to read data from excel I've mix of columns ...
- 327
3
votes
2
answers
8k
views
exporting test cases from TFS MTM to excel
My company has recently migrated to TFS and I'm using Microsoft Test Professional 2015 (MTM) for my test cases.
I have created my test plan with requirement based suites to log my test cases against, ...
- 31
2
votes
1
answer
1k
views
appending data after reading from excel file in selenium web driver
I have written a script which reads data from excel file and I use sendKeys method to input that data to textbox. Now I want to append/concatenate data after reading from excel and than resultant ...
- 327
2
votes
2
answers
747
views
Element is currently not visible" random text fields
I am getting this error "Element is currently not visible" when I try to input into textbox which is visible I've created a script to signup and I am getting this error randomly sometimes on "password"...
- 327
0
votes
1
answer
2k
views
how to use excel data with selenium webdriver? [closed]
i am on Beginning stage in SELENIUM. Now, i am trying functional testing on selenium web-driver.
As driving EXCEL data is very essential on functional testing, i am struggling a lot in this are.
...
- 183
1
vote
1
answer
1k
views
Alternative to MTM and excel for tracking manual test plans
We use to execute tens of manual tests plans sessions for identifying the build to be marked as release candidate and we mainly use Microsoft Test Manager and Excel. Both of them are fine but have ...
- 775
1
vote
6
answers
11k
views
Test suite, Test plan, Test cases for Android application
I have been asked to learn about Test Plan, Test Suite, Black Box Testing, Test Cases. Can anyone guide me in which order should I start learning?
And also what are the necessary test cases for ...
- 63
5
votes
3
answers
2k
views
How to fetch data from Excel to Rational Function Tester (RFT) automation tool?
I'm new to automation testing and also to RFT tool. I tried record and playback by hard-coded values. Now I want to make my scripts dynamic. Hence I use Excel as an external file to fetch data.
How ...
- 51
5
votes
4
answers
23k
views
Importing Test cases from Excel to TFS
I need to import test cases from Excel to TFS 2013. For this I have already gone through the link SQA and VSTS, but my issue is not getting resolved from these links. I can't use 'Test Case Migrator ...
- 4,580
1
vote
1
answer
10k
views
Selenium framework using C# and excel
I am new to automation (Selenium ). I am working as manual tester and recently got a task related to selenium automation.
I have basic knowledge of selenium and very good knowledge of C#. I can ...
- 151
1
vote
1
answer
83
views
Excel worksheets: summarize a bunch of sheets using indirect [closed]
Current scenario
I'm a data tester, and I test insurance contracts, and each policy has many "roles", "features", "history items" etc.
A standard SQL query with all data joined will return 20-30 rows ...
- 81
2
votes
1
answer
3k
views
Excel VBA: convert R1C1 notation to A1 notation
issue
I'm a "data tester" and I test websites by writing SQL queries then using Excel to process the data and validate data during test execution
Sometimes we want to use R1C1 nontation in our VBA (e....
- 81
2
votes
2
answers
4k
views
Testing pdf/excel content with C#
Our site has a good number of reports that are using SSRS,Crystal and Excel. We are using C# with Selenium WebDriver. I have been searching for the best practices and best ways and tools to test the ...
- 375
0
votes
1
answer
1k
views
Setting Date & Time in java
I am working on report generation. For generation I need date&time[time stamp] telling when the report is generated. For this purpose I have created a method which returns formatted date time ...
- 483
1
vote
0
answers
4k
views
Function to write 2 D Array from java into Excel [closed]
I am writing a function which accepts array data as input,and according to the size of array I am filling to excel sheet. Also let me know is there any method get column size of array as array.leght ...
- 483
0
votes
1
answer
741
views
Adding a threshold amount to an Excel formula for validation
I'm using Excel to highlight differences in two outputs that should be the same. My problem is that even if they're different by a value of 0.001 (which is technically correct), I want to add a ...
- 2,488
0
votes
2
answers
497
views
Verify value range of data in an Excel sheet [closed]
An excel sheet having rows and columns, each cell accept 1 to 6 numeric values. How to check 1000 columns? what are the technique following for this?
- 41
1
vote
2
answers
2k
views
Auto Increment Test Case Number in Excel when New Test Case is Added
I am stuck with one issue which needs your help. Because of some bad requirement i am supposed to write my test cases in excel. Now Each Test case has a Serial Number. Because the test cases are more ...
- 157
2
votes
3
answers
502
views
Ideas to implement offline smoke test for downloaded excel files
I run automated smoke tests for my web application, but until now, these tests are not covering offline excel spreadsheets that are downloaded by the user.
I'm starting a study to find possible ...
- 123
1
vote
1
answer
1k
views
Adding VBA Reference in QC Post Processing Script
I have a VBA script which i want to run in the post processing section of the QC 11 Excel Reports generator (using the UI, not the API). This script uses the Dictionary object in the Microsoft....
- 123
18
votes
12
answers
104k
views
Looking for an excellent example of using a spreadsheet for test case management
It is an unfortunate reality of our industry that many testers are stuck using a spreadsheet to manage their test cases.
I wanted to ask (in a community wiki), what are some good techniques and ...
2
votes
2
answers
2k
views
JUnit Framework - Selenium Webdriver - Excel Input Output - Apache POI
I would like to know, do we use Apache POI when interacting with Excel Files for Selenium Webdriver (under JUnit framework) or is there any better approach?
Let me know if further clarity is ...
- 369
2
votes
1
answer
7k
views
Excel Add In for Quality Center won't run in 64 bit excel - is there a workaround?
Our company recently upgraded everyone to Office 2010, the 64 bit version. This broke the functionality of the HP Excel ADD IN for Quality Center that I had been using. I prefer to write my test cases ...
- 482
3
votes
1
answer
1k
views
How to test an Excel macro that selects, groups, and counts data using SQL query?
This is the first time I encountered such a problem.
There is an Excel table with a macro that selects data from the database using SQL query according to specific criteria. Data is grouped in ...
- 163