Java 针对excel数据的写入操作
package example;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.ArrayList;
public class WriteExcel {
public static void write(ArrayList<Double> list) {
XSSFWorkbook workbook = new XSSFWorkbook();
XSSFSheet sheet = workbook.createSheet("用户表一");
XSSFRow row = sheet.createRow(0);
XSSFRow row1 = sheet.createRow(0);
for (int i = 0; i < list.size(); i++) {
row1.createCell(i).setCellValue(list.get(i));
}
try {
FileOutputStream fos = new FileOutputStream("1.xls");
workbook.write(fos);
System.out.println("写入成功");
fos.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}
参考链接