All Questions
320 questions
1
vote
0
answers
162
views
I am not able to fetch data from encrypted excel file. While fetching in java selenium, its throwing OLAP error
I used poi jars from version 3 to 5 to fetch data from encrypted excel file but not able to fetch data, while running java selenium read excel program its throwing OLAP error. The excel file is .xlsx.
...
- 11
0
votes
1
answer
297
views
Need to save the excel file for every run with the current timestamp
I am using the below code to convert the json file to excel using aspose. I am able to convert the json file but i need to save the converted file for every run with the current timestamp and i need ...
- 1
0
votes
0
answers
108
views
Iterate through unique values in excel sheet with java
I have an Excel sheet like this:
code
vehicles
101
vehicle01
101
vehicle02
102
vehicle04
102
vehicle04
102
vehicle05
103
vehicle06
...
...
What I need to do is to take every vehicle of a code and ...
- 445
0
votes
1
answer
2k
views
Copying one sheet to another workbook along with style using apache poi
I am trying to copy a sheet from one workbook into another along with the styles (Cell color and merge)
I am using the below code, it is copying but it is filling the already colored cells with black ...
- 25
0
votes
2
answers
2k
views
I want to write data into excel(.xlsx file) using Apache poi
I want to write data into excel(.xlsx file) using Apache poi. but getting some error while writing a data. I have followed this video " How to read/write data from Excel file using Apache POI API ...
0
votes
1
answer
116
views
Not getting any data from fileinput stream
Currently exploring apache poi and what seems to be the error?
I didn't get any value from my filesheets.
Tried to prompt out the value from line 51 and I didn't get any.
This is what I'm doing: I ...
- 53
1
vote
1
answer
734
views
How can I store a screenshot from an object to a string and save the image into an excel worksheet in selenium WebDriver?
I have a simple selenium WebDriver program that reads the excel file data and performs login functionality.
I require to take a screenshot whenever the test case fails and save it into the excel ...
- 11
0
votes
2
answers
354
views
If cell in specific row contains "x", how to do I retrieve the specific column name where x is present using Java
Sample excel sheet (I am using a much larger excel sheet):
Column0
Column1
Column2
Column3
Column4
Column5
row0
red
x
x
x
row1
orange
x
x
row2
yellow
x
x
x
row3
green
x
x
x
row4
blue
x
x
row5
...
- 1
1
vote
0
answers
352
views
How can I run my feature file multiple time based on the data i have on the excel
I want to run the same scenario multiple times based on the number of rows in the excel sheet without repeat the row number in the feature file as shown below
I just want to initiate the first-row ...
- 41
-1
votes
1
answer
309
views
how to read and validate blank lines from selenium excel
here in my code I am trying to read only the data from column "A" . Here in the screen shot I have attached how the sample data looks like. I am having an issue while reading the contents as ...
- 21
0
votes
0
answers
42
views
Write error Collection into an excel file in Selenium Java
I am using Selenium Java for automating my project.
In this I have used an ArrayList where we are adding all the errors we face during automation. My code looks something like below:
List<String>...
1
vote
0
answers
775
views
How can I compare console output with excel sheet data using selenium webdriver?
I have retrieved the elements of a table to the console window and I would like to compare the output with data present in an excel sheet. Can anyone please help me with this?
// To locate table.
...
0
votes
2
answers
97
views
Unable to accept two dimensional String Array returned from a method
First of All :-) , I am not that proficient in java.
So in below code I am trying to print a two dimensional string returned from method. But unable to do it. Getting type mismatch error. can any one ...
- 39
0
votes
1
answer
547
views
Package should contain a content type part [M1.13]
I am trying to execute a selenium program in which I need to download an excel file and read it . I am getting "Package should contain a content type part [M1.13]" as error .can anyone help?
