如何使用apache poi和selenium webdriver在excel文件中写入使用列表和迭代器获得的值

Question

我需要使用selenium webdriver使用list和Iterator存储一个从网页中获得的值列表，我想将这些值存储/写入网站的excel表单链接：https://www.zigwheels.com/used-car我获得了一个流行车型下的值列表，我需要使用apache poi将其存储在excel表单中

编码从这里开始：WebElement li=driver.findElement（by.xpath（“//SPAN[text()='品牌和模型']//parent::div//followingsibling::div//child::div[4]/ul”））；

    List<WebElement> alloptions=li.findElements(By.tagName("li"));   
    Iterator<WebElement> itr=alloptions.iterator();
    while(itr.hasNext()) {
        WebElement lii=itr.next();
        String list=lii.getText();
        System.out.println(list);

Answer 1

先创建文件，再创建工作表，然后创建行，然后在行中填充单元格：

public void CreateNew_Make_BeckupFile() throws IOException
    {
String filePath = "filepath.xls";
       
        File f = new File(filePath); 
        if (!(f.exists() && f.isFile())) 
        {
                
            Workbook workbook = new XSSFWorkbook(); // new HSSFWorkbook() for generating `.xls` file

            /*
             * CreationHelper helps us create instances of various things like DataFormat,
             * Hyperlink, RichTextString etc, in a format (HSSF, XSSF) independent way
             */
            CreationHelper createHelper = workbook.getCreationHelper();

            for (int p = 0; p < listaTimova.size(); p++) {
                // Create a Sheet
                // Sheet sheet = workbook.createSheet("Employee");
                SheetCreation (workbook, p);
            }
            // Write the output to a file
            FileOutputStream outputStream = new FileOutputStream(filePath);
            workbook.write(outputStream);
            // Closing the workbook
            workbook.close();
            outputStream.close();       
        } 

 public void SheetCreation (Workbook workbook, int teamNumber)
        {
            CreationHelper createHelper = workbook.getCreationHelper();
            
            Sheet sheet = workbook.createSheet("Sheet Name");
            
            // Create a Font for styling header cells
            Font headerFont = workbook.createFont();
            headerFont.setBold(true);
            headerFont.setFontHeightInPoints((short) 14);
            headerFont.setColor(IndexedColors.BLUE.getIndex());
    
            // Create a CellStyle with the font
            CellStyle headerCellStyle = workbook.createCellStyle();
            headerCellStyle.setFont(headerFont);
    
            // Create a Row
            Row headerRow = sheet.createRow(0);
    
            // Create cells
            for (int i = 0; i < columns.length; i++) {
                Cell cell = headerRow.createCell(i);
                cell.setCellValue(columns[i]);
                cell.setCellStyle(headerCellStyle);
            }
            
            headerFont.setColor(IndexedColors.BLACK.getIndex());
            headerCellStyle.setFont(headerFont);
    
            for (int u = 0; u < listaTimova.get(teamNumber).listaIgracaTima.size(); u++)
            {   
                Row headerRow2 = sheet.createRow(u + 1);
                **RowCreation(headerRow2, teamNumber, u, 0);**      
            }
            
            for(int i = 0; i < columns.length; i++) 
            {
                sheet.autoSizeColumn(i);
            }
        }
    
    
    **public void RowCreation(Row row, int teamNumber, int playerNumber, int cellNumber)** 
        {
            
            row.createCell(cellNumber, CellType.STRING).setCellValue("Any value for cell");
            row.createCell(cellNumber+1, CellType.STRING).setCellValue("next cell in row value...");
            }