<dependency>
     <groupId>org.apache.poi</groupId>
     <artifactId>poi-ooxml</artifactId>
     <version>3.17</version>
 </dependency>

public String exportExcel(String startTime,String endTime,HttpServletResponse response) throws IOException {
        List<store_order> list = emptySpecialStoreService.selectOrderbyTime(startTime, endTime);
    String fileName = "orderInfo"; //設置導出excel文件名稱
    HSSFWorkbook workbook = new HSSFWorkbook(); //創(chuàng)建Excel工作薄對象
    HSSFSheet sheet = workbook.createSheet();  //創(chuàng)建工作表對象
    sheet.setColumnWidth(12,5000);   //設置表的最后一列第12列的寬度//設置表頭字體樣式
    HSSFFont font = workbook.createFont();
    font.setFontName("宋體");
    font.setFontHeightInPoints((short)10); //設置字號
    font.setBold(true);  //設置加粗
    
    //HSSFCellStyle cellStyle = workbook.createCellStyle(); //設置列字體，這里暫不設置
    
    HSSFRow row0 = sheet.createRow(0); //創(chuàng)建第一行，第一行為每一列的標題
    
    String[] cellTitle={"訂單號","用戶賬號","商品名稱","優(yōu)惠前價格","優(yōu)惠后價格","商品類型","KT幣數(shù)量","收件人姓名","收件人地址","收件人手機號","商品來源","訂單狀態(tài)","創(chuàng)建時間"};
    for(int i=0;i<cellTitle.length;i++) {
       HSSFCell cell = row0.createCell(i);  //依次設置列標題
       cell.setCellValue(cellTitle[i]);
    }
    //表格中數(shù)據(jù)總共12列，循環(huán)新建一行，然后把對象中的值依次寫入到這一行中的每一列
    for(int i=0;i<list.size();i++) {
      HSSFRow row = sheet.createRow(i+1);  //創(chuàng)建新的一行
      store_order order = list.get(i);
      
      HSSFCell cell0 = row.createCell(0); //依次為當前行的每一列添加數(shù)據(jù)
      cell0.setCellValue(order.getStore_order_id());
      
      HSSFCell cell1 = row.createCell(1); 
      cell1.setCellValue(order.getUsercode());
      
      HSSFCell cell2 = row.createCell(2); 
      cell2.setCellValue(order.getProduct_name());
      
      HSSFCell cell3 = row.createCell(3); 
      cell3.setCellValue(order.getPrice_before());
      
      HSSFCell cell4 = row.createCell(4); 
      cell4.setCellValue(order.getPrice_after());
      
      HSSFCell cell5 = row.createCell(5); 
      cell5.setCellValue(order.getProduct_type());
      
      HSSFCell cell6 = row.createCell(6); 
      cell6.setCellValue(order.getAmountKT());
      
      HSSFCell cell7 = row.createCell(7); 
      cell7.setCellValue(order.getPeople_name());
      
      HSSFCell cell8 = row.createCell(8); 
      cell8.setCellValue(order.getPeople_address());
      
      HSSFCell cell9 = row.createCell(9); 
      cell9.setCellValue(order.getPeople_mobile());
      
      HSSFCell cell10 = row.createCell(10); 
      cell10.setCellValue(order.getProduct_source());
      
      HSSFCell cell11 = row.createCell(11);
      cell11.setCellValue(order.getProduct_status());

      HSSFCell cell12 = row.createCell(12); 
      cell12.setCellValue(order.getCreate_time());
    }
     
    OutputStream os = response.getOutputStream();
    response.reset(); //重置輸出流
    //設置輸出頭文件
    response.setHeader("Content-disposition", "attachment; filename=" + new String(fileName.getBytes("GB2312"), "8859_1") + ".xls"); //.xls是excel文件的后綴
    //定義輸出頭類型
    response.setContentType("application/msexcel");
    workbook.write(os);
    os.close();
    
    System.out.println("導出完成=============");
    return "導出成功！";
  }