Guide on efficiently writing several data entries to Excel using looping in Jxl

Question

Guide on efficiently writing several data entries to Excel using looping in Jxl

I am facing an issue with my code where it is only writing the first value to Excel and not the rest. My goal is to read data from a webpage and write it to an Excel sheet. The current set of code I have works fine, but I need help figuring out how to run this in a loop as I have multiple values to write that are being retrieved from a table.

If anyone could assist with sorting this out, it would be greatly appreciated.

String m1 = (driver.findElement(By.xpath(".//*[@id='dhfdshjfdsfdsf']")).getText());
   System.out.println(m1);
    WritableWorkbook wb = Workbook.createWorkbook(new File("D:\\output_2.xls"));
    writableSheet ws = wb.createSheet("customsheet",1);
    {
    Label label = new Label(0,0,m1);
    ws.addCell(label);
    }
    wb.write();
    wb.close();

java excel selenium-webdriver jxl

Answer 1

Answer №1

I made some improvements to your code so that it can handle multiple values efficiently. Take a look at the updated code below.

WritableWorkbook workbook = Workbook.createWorkbook(new File("D:\\output_2.xls"));
    WritableSheet sheet = workbook.createSheet("customsheet", 1);
    int rowSize = sheet.getRows();
    int column = 0;
    
    // If there are 20 values in m1, it will update up to 20 rows
    for (int i = rowSize; i < rowSize + 20; i++) {
        String value = driver.findElement(By.xpath(".//*[@id='dhfdshjfdsfdsf']")).getText();
        System.out.println(value);
        Label label = new Label(column, i, value);
        sheet.addCell(label);
    }
    workbook.write();
    workbook.close();

Answer 2

I made some improvements to your code so that it can handle multiple values efficiently. Take a look at the updated code below.

WritableWorkbook workbook = Workbook.createWorkbook(new File("D:\\output_2.xls"));
    WritableSheet sheet = workbook.createSheet("customsheet", 1);
    int rowSize = sheet.getRows();
    int column = 0;
    
    // If there are 20 values in m1, it will update up to 20 rows
    for (int i = rowSize; i < rowSize + 20; i++) {
        String value = driver.findElement(By.xpath(".//*[@id='dhfdshjfdsfdsf']")).getText();
        System.out.println(value);
        Label label = new Label(column, i, value);
        sheet.addCell(label);
    }
    workbook.write();
    workbook.close();

Guide on efficiently writing several data entries to Excel using looping in Jxl

Answer №1

Similar questions

Having trouble retrieving options from a Select element with Selenium

Executing a maven project using Jenkins on an Ubuntu system

Is it possible to conceal the chrome browser when using Selenium with C#?

When utilizing Visual Basic 6 with Selenium, an error may occur stating "Class not registered 80040154."

Having trouble running classes using Maven test with the Testng.xml file in the terminal, however, it runs smoothly in Eclipse

Is it possible to have Protractor utilize the IEDriverServer.exe that was updated by webdriver-update in the node_modules folder?

Setting up the communication ports between the Selenium Server and browsers: A step-by-step guide

How can Gson be used to parse multiple data types within a single array?

Steps for accessing the alert window after launching the browser using Selenium

Spring Boot is having trouble identifying the JavaScript files

Data file located at "resources/env1/data.json" is causing an error in the implementation of TestStep on line 5 in the scenarios/jsonformfiller.feature file

How can Selenium be used to identify an Internet Explorer browser extension?

Is there a way to delay script execution in Selenium web driver until the screen has been resized?

Spring Jackson - Field "response" is not recognized and cannot be ignored within the context of the program

Comparing Java's iText library with Node's Puppeteer for converting HTML to PDF documents

Utilizing Webdriver in C# to loop through elements and add their names to a screenshot array

Error: Reflection cannot be used to define a class

Selenium - enlarging an element fails, but shrinking it is successful

Error encountered during execution of For-Each loop using VBA and Selenium?

Guide to randomizing a collection of URLs and implementing it with the Webdriver