如何使用selenium java创建新的工作表并在现有的excel中写入一些数据。

Question

我尝试了下面的代码。

但它会覆盖现有的工作表。

File f= new File(System.getProperty("user.dir")+"\\src\\test\\resources\\Exceldata.xls");   

    HSSFWorkbook workbook = new HSSFWorkbook();         
    HSSFSheet worksheet= workbook.createSheet("Sheet4");        
    HSSFRow row = worksheet.createRow(1);
    HSSFCell cell= row.createCell(1);
    cell.setCellValue("admin");     

enter code here


    workbook.write(f);
    workbook.close();

Answer 1

用FileInputStream代替XSSFWorkbook的文件和对象我希望这个函数能对你有所帮助。

public static void write(){
       try
       {
           FileInputStream myxls = new FileInputStream(System.getProperty("user.dir")+"\\src\\test\\resources\\Exceldata.xls"  );
           HSSFWorkbook studentsSheet = new HSSFWorkbook(myxls);
           workbook = new XSSFWorkbook(myxls );
           workbook.createSheet(sheetname);
           HSSFSheet worksheet = studentsSheet.getSheetAt(0);
           a=worksheet.getLastRowNum();
           System.out.println(a);
           Row row = worksheet.createRow(++a);
           row.createCell(1).setCellValue("");
           myxls.close();
           FileOutputStream output_file =new FileOutputStream(new File(System.getProperty("user.dir")+"\\src\\test\\resources\\Exceldata.xls"));  
           //write changes
           workbook.write(output_file );

           studentsSheet.write(output_file);
           output_file.close();
           System.out.println(" is successfully written");
       }

尝试从main方法调用此函数，

public static void main(String args[])
   {
       write();
   }

Append Data in existing Excel file using apache poi in java和How to add new sheets to existing excel workbook using apache POI?可能存在重复

Answer 2

我终于找到了解决方案。我使用了poi jar 4.0，在其中我无法成功地写入数据。然后，我将jar版本降级到3.14，我可以完美地工作