不知道我的代码出了什么问题(Apache POI)

Question

package apachePOIFrameWork.ObjectRepository;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
public class excelDataDrivenProcess {
    XSSFWorkbook mWorkbook;
    XSSFSheet mDataSheet;
    XSSFRow mRowPointer;
    XSSFCell mColPointer;
    FileInputStream mFis;
    FileOutputStream mFos;
    String mLocation;
    public excelDataDrivenProcess(String workBook){
        mLocation = workBook;
    }
    private void openFile(){
        try {
            mFis = new FileInputStream(mLocation);
            mWorkbook = new XSSFWorkbook(mFis);
        }catch (IOException ioe){
            ioe.printStackTrace();
            System.out.println("File Not Found");
        }
    }
    private void saveFile(){
        try {
            mFos = new FileOutputStream(mLocation);
            mWorkbook.write(mFos);
            mFos.close();
        }catch (IOException ioe){
            ioe.printStackTrace();
            System.out.println("Cannot Write");
        }
    }
    public void showDataAt(String sheetName, int rowNum, int colNum){
        openFile();
        mDataSheet = mWorkbook.getSheet(sheetName);
        mRowPointer = mDataSheet.getRow(rowNum);
        mColPointer = mRowPointer.getCell(colNum);
        System.out.println(mColPointer.getStringCellValue());
    }
    public void setDataAt(String value, String sheetName, int rowNum, int colNum){
        openFile();
        mDataSheet = mWorkbook.getSheet(sheetName);
        mRowPointer = mDataSheet.createRow(rowNum);
        mColPointer = mRowPointer.createCell(colNum);
        mColPointer.setCellValue(value);
        saveFile();
        System.out.println("Your Value: " + value + " is set to your desired Location");
    }
}
package apachePOIFrameWork.testCases;
import apachePOIFrameWork.ObjectRepository.excelDataDrivenProcess;
import org.testng.annotations.Test;
public class valuePrinter {
    @Test
    public void valueExtractor(){
        excelDataDrivenProcess eddp = new excelDataDrivenProcess("C:\SeleniumWorks\excelDataCollector.xlsx");
        eddp.showDataAt("Sheet1", 0, 0);
        eddp.showDataAt("Sheet1", 0, 1);
        eddp.setDataAt("abc", "Sheet1", 1, 0);
        eddp.setDataAt("xyz", "Sheet1", 1, 1);
        /*When I open excel file only xyz is printed on location (1,1) whereas abc is never saved in the file*/
    }
}

使用TestNG框架和Apache POI -程序运行成功，但当我打开excel工作表时，只有最后一个值(在这种情况下'xyz')保存在文件中。我不明白'abc'值在(1,0)位置发生了什么

Answer 1

问题出在:

 mRowPointer = mDataSheet.createRow(rowNum);

每次重新创建整个行，与前面的值重叠。您可以使用如下命令:

 mRowPointer = mDataSheet.getRow(rowNum);
 if(mRowPointer==null)
    mRowPointer = mDataSheet.createRow(rowNum);