天天看点

利用SpringBoot实现导出到excel的demo

public static void main(String[] args) throws Exception {

HSSFWorkbook hssfWorkbook = new HSSFWorkbook();
    HSSFSheet sheet = hssfWorkbook.createSheet("111");
    for (int i = 0; i < 10; i++) {
        HSSFRow row = sheet.createRow(i);
        row.createCell(i).setCellValue(i);
        for (int i1 = 0; i1 < 10; i1++) {
            row.createCell(i1).setCellValue(i1);
        }
    }
    FileOutputStream outputStream = new FileOutputStream("C:\\Users\\Administrator\\Desktop\\1.xls");
    hssfWorkbook.write(outputStream);
    hssfWorkbook.close();
    outputStream.close();
}