Skip to main content
Share Your Experience: Take the 2024 Developer Survey
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...
Sachintha's user avatar
  • 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....
Sagar007's user avatar
  • 1,340
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....
Jeevan Bhushetty's user avatar
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 ...
Teri's user avatar
  • 21
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-...
Kate Paulk's user avatar
  • 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 ...
Niels van Reijmersdal's user avatar
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 ...
Tufty's user avatar
  • 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....
hxin's user avatar
  • 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....
Amjad Ahmad's user avatar
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 ...
Alexey R.'s user avatar
  • 11.6k
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 ...
Kate Paulk's user avatar
  • 31.5k
1 vote

Selenium, Java, POI: How to read numeric values from Excel file?

Copy the value to a TEXT cell and get the value , in below code let say you have 5 columns so i am creating 6th column as TEXT and copy the value to this new cell and then retrieve the value. ...
PDHide's user avatar
  • 11.1k
1 vote

Quality Checks on Excel / Automation

I used to have a similar job; pulling down reports from different vendors in Excel and doing a pseudo-ETL. Excel Macros were great and I had one macro for each vendor. Still, I saved countless hours ...
kirbycope's user avatar
  • 4,090
1 vote

How to browse Excel file in JMeter?

As the attached image shows that user needs to browse the excel sheet.I was also faced the same situation. So, Assuming that request for the same has been recorded. Follow below instructions: Use ...
Himanil Gupta's user avatar
1 vote

How to fetch data from UI and passing those data as input for selenium script?

First of all you have to understand that UI stands for just an User Interface. So this is some way that allows a user to interact with your application (so, when you were interacting with your tests ...
Alexey R.'s user avatar
  • 11.6k
1 vote

How to create test cases in order to test columns in an excel file?

It would be better if you write scenarios for each column at least one. The reason beyond is the export file contains the banking pieces of information so there must be some condition and rules to ...
Anand Natarajan's user avatar
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.
Prasanna venkatesh's user avatar
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[...
A.A.A's user avatar
  • 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 ...
Amias's user avatar
  • 1,202
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())) { ...
Vel Guru's user avatar
  • 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 ...
55s25's user avatar
  • 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 ...
saurabhguptacse's user avatar
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 ...
wmarchewka's user avatar
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.
kanayikkaran's user avatar
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.
Paul Muir's user avatar
  • 3,282
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[][...
Narendra Chandratre's user avatar
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 ...
IAmMilinPatel's user avatar
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 ...
Chetan chadha's user avatar
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.
Azmi YÜKSEL's user avatar
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).
JustARandomGuy's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible