Hot answers tagged

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 ...
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

Verify value range of data in an Excel sheet

To check that cells in excel sheet contain values between 1 and 6 do the following, Select all the cells that you want to check. the header of excel click in Conditional Formatting. In the drop down ...
3 votes

Testing pdf/excel content with C#

I think I can point you in the right direction for MS Word, at least. You can use the Office Interop Assemblies in C#. Here is an example from .Net Pearls: using System; using Microsoft.Office....
  • 4,030
3 votes
Accepted

Setting Date & Time in java

Your filename is illegal, colon : is not allowed in files names. 2015.02.10_12:18:41_report.xlsx Also see: https://stackoverflow.com/questions/1976007/what-characters-are-forbidden-in-windows-and-...
2 votes
Accepted

Excel VBA: convert R1C1 notation to A1 notation

solution use the Excel Address function
2 votes

Testing pdf/excel content with C#

Webdriver is a browser manipulation API only and as such the ability to read office or PDF files is out of scope of its capabilities, but the office interop libraries will allow you to read data from ...
  • 271
2 votes

Selenium framework using C# and excel

Just use an Excel library to load data from Excel files and use that data in your Asserts? C# and Excel: https://stackoverflow.com/questions/657131/how-to-read-data-of-an-excel-file-using-c C# and ...
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-...
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....
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

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 ...
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-...
  • 30.8k
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?

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,290
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....
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.4k
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 ...
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.
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,212
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).
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,212
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[][...
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 ...
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 ...
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.
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 ...
1 vote

Importing Test cases from Excel to TFS

After waiting long for this question, I am answering it myself. I too searched a lot but didn't get any way for importing test cases from Excel to TFS in right format. One has to use Test Case ...
  • 4,550
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