How to put console output data in Excel (.xlsx) sheet. | Selenium Forum
H
Harsh Posted on 19/02/2020

How to put console output data in Excel (.xlsx) sheet.

Scenario: Open grocery shop webpage like Big Basket >> Search Product name as Hair Shampoo >> Put all the suggested PRODUCT NAMEs with PRICE in excel sheet.

Kindly help.

Note: I have written script till printing all product names in console (using findElements), but not able to print respective Price and upload in excel sheet.


A
Ashish Thakur Replied on 20/02/2020

This is easy. You need to write your oen custom code to read the data from the page and then make use of setCellData() method to put data inside the sheet.