编程语言:Java
如何使用XSSFWorkbook,在同一个XSSFWorkbook中创建多个XSSFSheet,并附加数据?
XSSFWorkbook.createSheet不是就可以创建一个XSSFSheet么,你create两个就行了吧
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();
}
}