如何创建多个sheet?

编程语言:Java
如何使用XSSFWorkbook,在同一个XSSFWorkbook中创建多个XSSFSheet,并附加数据?

XSSFWorkbook.createSheet不是就可以创建一个XSSFSheet么,你create两个就行了吧

img

public static void main(String[] args)   {
        XSSFWorkbook workbook = new XSSFWorkbook();

         XSSFSheet sheet1 = workbook.createSheet("Sheet1");
         XSSFSheet sheet2 = workbook.createSheet("Sheet2");
        XSSFRow row1 = sheet1.createRow(0);
        row1.createCell(0).setCellValue("Data1");
        XSSFRow row2 = sheet2.createRow(0);
        row2.createCell(0).setCellValue("Data2");
        FileOutputStream outputStream;
        try {
            outputStream = new FileOutputStream("D:\\test\\workbook.xlsx");
            workbook.write(outputStream);
            outputStream.close();
        } catch (FileNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (IOException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }

    }