java利用poi创建excel文件并写入数据

//定义表头 String[] title={"序号","姓名","年龄"}; //创建excel工作簿 HSSFWorkbook workbook=new HSSFWorkbook(); //创建工作表sheet HSSFSheet sheet=workbook.createSheet(); //创建第一行 HSSFRow row=sheet.createRow(0); HSSFCell cell=null; //插入第一行数据的表头 for(int i=0;i<title.length;i++){ cell=row.createCell(i); cell.setCellValue(title[i]); } //写入数据 for (int i=1;i<=10;i++){ HSSFRow nrow=sheet.createRow(i); HSSFCell ncell=nrow.createCell(0); ncell.setCellValue(""+i); ncell=nrow.createCell(1); ncell.setCellValue("user"+i); ncell=nrow.createCell(2); ncell.setCellValue("24"); } //创建excel文件 File file=new File("f://poi.xlsx"); try { file.createNewFile(); //将excel写入 FileOutputStream stream= FileUtils.openOutputStream(file); workbook.write(stream); stream.close(); } catch (IOException e) { e.printStackTrace();

}

在maven仓库中导入jar包

<dependency> <groupId>org.apache.poi</groupId> <artifactId>poi-ooxml</artifactId> <version>3.9</version> </dependency> <dependency> <groupId>commons-io</groupId> <artifactId>commons-io</artifactId> <version>2.3</version> </dependency>