java数组写入excel_java如何使用Java将数组数据写入Excel堆栈内存溢出

我有一个字符串数组&＃xff0c;需要将其插入Excel工作表

我尝试使用下面的代码片段&＃xff0c;但是只有第一个值正在插入&＃xff0c;而其余的则在控制台中为空。

String[] excelData &＃61; {"first", "second", "third", "fourth", "fifth"};

int rowStart &＃61; 1;

for (int count &＃61; 0; count <&＃61; excelData.length; count&＃43;&＃43;) {

writeExcel(fileName, excelData[count], rowStart, 0);

rowStart&＃43;&＃43;;

}

更新

添加了writeExcel代码。

public void writeExcel(String excelFile, String userNumber, int rows, int cols) {

try{

//Create an object of File class to open xlsx file

File file &＃61; new File(excelFile);

//Create an object of FileInputStream class to read excel file

FileInputStream inputStream &＃61; new FileInputStream(file);

Workbook requestsFile &＃61; null;

//Find the file extension by splitting file name in substring and getting only extension name

String fileExtensionName &＃61; excelFile.substring(excelFile.indexOf("."));

//Check condition if the file is xlsx file

if(fileExtensionName.equals(".xlsx")){

//If it is xlsx file then create object of XSSFWorkbook class

requestsFile &＃61; new XSSFWorkbook(inputStream);

} else if(fileExtensionName.equals(".xls")){

//If it is xls file then create object of XSSFWorkbook class

requestsFile &＃61; new HSSFWorkbook(inputStream);

} else {

System.out.println("File format is invalid");

}

//Read excel sheet by sheet name

Sheet sheet &＃61; requestsFile.getSheetAt(0);

Cell val1 &＃61; sheet.getRow(rows).getCell(cols);

val1.setCellValue(userNumber);

//Close input stream

inputStream.close();

//Create an object of FileOutputStream class to create write data in excel file

FileOutputStream outputStream &＃61; new FileOutputStream(file);

//write data in the excel file

requestsFile.write(outputStream);

//close output stream

outputStream.close();

} catch(Exception e){

System.out.println(e.getMessage());

}

}