SSM的Excel的导入导出（POI）

  org.apache.poi
  poi
  3.9



  org.apache.poi
  poi-ooxml
  3.9



  joda-time
  joda-time
  2.10.1

//创建一个工作簿
Workbook workbook=new HSSFWorkbook();
//创建一个工作表
Sheet sheet=workbook.createSheet("药品售卖信息清单");
//创建一个行
Row row1=sheet.createRow(0);
//创建一个单元格
Cell cell1=row1.createCell(0);
cell1.setCellValue("编号");
Cell cell2=row1.createCell(1);
cell2.setCellValue("购买者");
Cell cell3=row1.createCell(2);
cell3.setCellValue("药名");
Cell cell4=row1.createCell(3);
cell4.setCellValue("药类");
Cell cell5=row1.createCell(4);
cell5.setCellValue("价格");
Cell cell6=row1.createCell(5);
cell6.setCellValue("数量");
Cell cell7=row1.createCell(6);
cell7.setCellValue("小计");
Cell cell8=row1.createCell(7);
cell8.setCellValue("售卖日期");
List list=service.findAccount();
Iterator iterator=list.iterator();
int num=1;
while (iterator.hasNext()){
    Orders orders=iterator.next();
    Row row=sheet.createRow(num);
    Cell cell11=row.createCell(0);
    cell11.setCellValue(num);
    Cell cell12=row.createCell(1);
    cell12.setCellValue(orders.getName());
    Cell cell13=row.createCell(2);
    cell13.setCellValue(orders.getDname());
    Cell cell14=row.createCell(3);
    cell14.setCellValue(orders.getDsort());
    Cell cell15=row.createCell(4);
    cell15.setCellValue(orders.getDprice());
    Cell cell16=row.createCell(5);
    cell16.setCellValue(orders.getAnumber());
    Cell cell17=row.createCell(6);
    cell17.setCellValue(orders.getDprice()*orders.getAnumber());
    Cell cell18=row.createCell(7);
    cell18.setCellValue(orders.getAdate());
    num++;
}
//生成一张表
FileOutputStream fileOutputStream=new FileOutputStream("D:\"+"药品售卖信息清单.xls");
//数据写入
workbook.write(fileOutputStream);
//关闭流
fileOutputStream.close();