maven导入依赖包
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>3.17</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>3.17</version>
</dependency>
创建文件
HSSFWorkbook wb = new HSSFWorkbook();
创建表格
HSSFSheet sheet = wb.createSheet("sheet0");
创建行并输入值
HSSFRow row = sheet.createRow(行数,从0开始);
创建单元格并输入值
HSSFCell cell = row.createCell(列数,从0开始);
cell.setCellValue("");
创建新行
row = sheet.createRow(行数);
输出Excel文件
try {
FileOutputStream fout = new FileOutputStream("存放的路径" + ".xls");
wb.write(fout);
fout.close();
} catch (Exception e) {
e.printStackTrace();
}