2 回答

TA貢獻(xiàn)1877條經(jīng)驗 獲得超1個贊
Workbook workbook = new XSSFWorkbook();
Sheet sheet = workbook.createSheet();
Row headerRow = sheet.createRow(0);
headerRow.createCell(0).setCellValue("Setupid");
headerRow.createCell(1).setCellValue("Request");
int cellCount = 10;
for (int i = 1; i <= cellCount; i++) {
Row row = sheet.createRow(i);
row.createCell(0).setCellValue("cell " + i);
row.createCell(1).setCellValue("cell " + i);
}
File file = new File(System.getProperty("user.dir")
+ "/src/main/uat/testdata/FreeTestData.xlsx");
if(file.exists()) {
file.delete();
}
file.createNewFile();
FileOutputStream fos = new FileOutputStream(file);
workbook.write(fos);
fos.close();
workbook.close();

TA貢獻(xiàn)1803條經(jīng)驗 獲得超3個贊
我認(rèn)為你的 for 循環(huán)不正確
for(int i=1; i<=n; i++){
它應(yīng)該是
for(int i=1; i<=lastRow; i++){
添加回答
舉報