lz所使用的工具包是poi
maven依赖:
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>3.8</version>
<exclusions>
<exclusion>
<artifactId>commons-codec</artifactId>
<groupId>commons-codec</groupId>
</exclusion>
</exclusions>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>3.8</version>
</dependency>
范例代码
public static void main(String[] args) throws ParseException {
//创建一个HSSF,对应一个excel
HSSFWorkbook workbook = new HSSFWorkbook()
//在webbook中添加一个sheet,对应Excel文件中的sheet
HSSFSheet sheet = workbook.createSheet("学生表")
//在sheet中添加表头第0行,注意老版本poi对Excel的行数列数有限制short
HSSFRow row = sheet.createRow((int) 0)
//创建单元格,并设置值表头 设置表头居中
HSSFCellStyle style = workbook.createCellStyle()
style.setAlignment(HSSFCellStyle.ALIGN_CENTER)
HSSFCell cell = row.createCell(0)
cell.setCellValue("学号")
cell.setCellStyle(style)
cell = row.createCell(1)
cell.setCellValue("姓名")
cell.setCellStyle(style)
cell = row.createCell(2)
cell.setCellValue("年龄")
cell.setCellStyle(style)
cell = row.createCell(3)
cell.setCellValue("生日")
cell.setCellStyle(style)
//写入实体数据
List list = DemoDaoImpl.getStudent()
for (int i = 0
{
row = sheet.createRow((int) i + 1)
Student stu = (Student) list.get(i)
//创建单元格,并设置值
row.createCell(0).setCellValue((double) stu.getId())
row.createCell(1).setCellValue(stu.getName())
row.createCell(2).setCellValue((double) stu.getAge())
cell = row.createCell(3)
cell.setCellValue(new SimpleDateFormat("yyyy-MM-dd").format(stu
.getBirth()))
}
//将文件存到指定位置
try
{
FileOutputStream fout = new FileOutputStream("D:/students.xls")
workbook.write(fout)
fout.close()
}
catch (Exception e)
{
e.printStackTrace()
}
}
运行结果
![运行结果](https://img-blog.csdn.net/20170714113630528?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvaW10aGVtb3N0c2h1YWlpbjYyNg==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast)