6
votes
Importing Test cases from Excel to TFS
I had the same issue when migrating tests from a legacy tool to TFS. It was simply not possible, independent of any choices offered by Excel and TFS (really, I tried them all and wrote a 43 page ...
- 864
4
votes
Cannot get a STRING value from a NUMERIC cell. How can I resolve this issue in selenium webdriver using POI?
This may be helpful to you..
Open the Excel sheet and select all (Ctrl+a) then right click and click Format cells then in number tab change the category to Text and click Ok...
- 380
3
votes
Cannot get a STRING value from a NUMERIC cell. How can I resolve this issue in selenium webdriver using POI?
This exception is occurred when code try to read Numeric value as string. Apache POI will not convert from Numeric to String.
There are two solution :
1. First convert cell type to string and Read it....
- 1,330
2
votes
Test suite, Test plan, Test cases for Android application
Test Plan
Test Suite
Black-box Testing
Test Cases
Test Plan: In Test plan you can understand whole application, Flow on your android application and after create test plan & test cases.
Black-...
- 260
2
votes
Element is currently not visible" random text fields
I would suggest not to use Thread.sleep() method, instead you can use the implicit wait, add following line of code after driver is declared.
driver.manage().timeouts().implicitlyWait(30, TimeUnit....
- 1,516
2
votes
exporting test cases from TFS MTM to excel
The Team section on excel will allow you to connect to and export any TFS query you have access to. Queries will work against any TFS object that has a base type of Work Item.
Since a requirements-...
- 31.5k
2
votes
Is it possible to restrict images from loading using selenium web-driver?
Yes, that is possible for an example see this question: https://stackoverflow.com/questions/7157994/do-not-want-images-to-load-and-css-to-render-on-firefox-in-selenium-webdriver-te
I am wondering if ...
- 32.5k
2
votes
Accepted
Zephyr to Test Rail migration - Is it possible?
Having done some further investigation myself, it appears there are multiple ways to extract parts of the tests from Zephyr.
If you use the 'Search' function to locate a test and then choose to ...
- 423
2
votes
Accepted
How to use .xlsx Excel files as Data Source for Coded UI test?
Here is the Attributes:
Data Source Types and Attributes
Excel, ".xlsx" format
[DataSource("System.Data.Odbc", "Dsn=Excel Files;Driver={Microsoft Excel Driver (*.xls)};dbq=|DataDirectory|\\data....
- 523
2
votes
Cannot get a STRING value from a NUMERIC cell. How can I resolve this issue in selenium webdriver using POI?
You Can Check if cell is numeric or String through this code
if(MytempCell.getCellType() == Cell.CELL_TYPE_NUMERIC)
your code ...
else if(MytempCell.getCellType() == Cell....
- 21
2
votes
Importing Test cases from Excel to TFS
The above worked well, but it only works for brand new test cases. If you have test cases that already have a test ID, you have to copy and paste individual steps and results to each test case. I ...
- 21
2
votes
Selenium, Java, POI: How to read numeric values from Excel file?
The solution that POI API implies is to use DataFormatter class. Using data formatter you can convert cell value to a string independently of what cell type is.
Approximate code should look like (no ...
- 11.6k
1
vote
POM Model -Fetching mobile number from excel sheet like 9.5512395512E9
" ` "
. Add this special character present in the quotes. Since the mobile number field is an integer this error is throwing. If you add that special character then the cell will became as string.
- 1,173
1
vote
How to get only one row from excel which has multiple rows data?
If you would like to return only 1 specific row then you have to pass the row number as a parameter to the function and also stop using the first loop and your object[][] array will be of size object[...
- 96
1
vote
When submitting a form by fetching values from excel file it is showing Internal Server Error
You don't seem to be checking the values from your spreadsheet import or if you have successfully opened it , this would then result in you searching for null or unexpected values which will cause ...
- 1,202
1
vote
Import Testresults to HP ALM with Excel AddIn
Based on your question, the answer is to inform your superiors that their choices are for you or someone else to spend some huge amount of time manually entering the results (assuming you have been ...
- 31.5k
1
vote
Unable to open an .xlsx file with script in Selenium WebDriver - getting InvalidFormatException
Use file extension to handle WorkSheet Type
String inputFilename = new File(path).getName();
switch (inputFilename.substring(inputFilename.lastIndexOf(".") + 1,
inputFilename.length())) {
...
- 526
1
vote
How to use java to access excel with selenium webdriver for data for tests
Selenium is meant to communicate with web applications. To pick data from excel using java you need to have apache poi jars in your project. If it is a maven project, then the correct artifactId in ...
- 11
1
vote
How to use java to access excel with selenium webdriver for data for tests
There are lots of thing you need to understand and implement.
1st: are you going to use excel with extenion .xls or .xlsx. If any of them then use the Apache POI jar to read data from excel.
Apache ...
- 141
1
vote
Zephyr to Test Rail migration - Is it possible?
If You company bought ZAPI (Zephyr API) along with Zephyr, You always can write migration scripts for e.g. in python. In my recent jobs I test both Zephyr and Test Rail, and I must said that, Test ...
- 237
1
vote
Update value in column using Apache POI
Figured it out.
We were opening the FileOutputStream with append as true.
This has caused the file size to increase, as well as to write only the latest data.
- 189
1
vote
Data Driven Framework Limitation
Standard CSV shouldn't have such a limitation. Database, XML, JSON, plain text or hardcoded. The possibilities are limitless.
- 3,272
1
vote
Selenium - How to copy entire excel column without using iterator
@Mohan - Can you add why you particularly looking for without iterator?
Very simple solution without iterator
public Object[][] signUpPage1FieldValidationData() throws Exception{
Object[][...
- 2,766
1
vote
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
I haven't used HL ALM QC but, if it allows users to import bugs from spreadsheets or CSV file, then I'm sure it will also have an option to export existing bugs.
You can export one such bug report ...
- 8,956
1
vote
Cannot get a text value from a numeric cell
I hope this line of code helps you
public String xls2text(InputStream in )throws Exception{ HSSFWorkbook excelWb = new HSSFWorkbook(in);
StringBuffer result = new StringBuffer(8192);
int ...
- 111
1
vote
exporting test cases from TFS MTM to excel
You can use TFS API to develop application like that. It allows customize a lot of item in MTM and TFS which you can not do with MTM or TFS.
- 86
1
vote
Accepted
appending data after reading from excel file in selenium web driver
sendKeys(objExcel.getCellData("Fname",i) + "@example.com");
Hope I understood your question correctly (just wondering).
- 849
1
vote
Element is currently not visible" random text fields
There is several issues here.
An implicit wait would do far better than the Thread.sleep()
Using Xpath to search by id. Just use by.id() it will be far faster
The ids, to me, appear to be ...
- 3,272
1
vote
Accepted
Alternative to MTM and excel for tracking manual test plans
My favorite test management tool is Test Rail. This is a web based test management solution. I've found it to be easy to create and modify multiple test plans and tests. It also integrates with TFS ...
- 296
1
vote
Test suite, Test plan, Test cases for Android application
Honestly, today I believe that most businesses don't care for many papers, delivered value, go for it. Forget test cases, test plans. A mind map can help you much more.
Today most environments are ...
- 231
Only top scored, non community-wiki answers of a minimum length are eligible