導出excel表格簡單方法

瀵煎嚭excel琛ㄦ牸,鍙互涓嶅鍏ヤ換浣曞寘锛岀洿鎺ョ敓浜xcel

濡備唬鐮侊細html椤甸潰灏變竴涓畝鍗曠殑javascript鑴氭湰锛

鈥婞code>鈥媤indow.location = "<%=request.getContextPath()%>/servlet/TestServlet";鈥婞/code>鈥嬫潵璺寵漿鍒皊ervlet銆

servlet涓缃甴eader ,鐩存帴鎷艱瀛楃涓瞭able琛ㄦ牸锛屽苟涓斿彲浠ヨ祴鏍峰紡鎵撳嵃鍒闆墠鍙扮洿鎺ュ鍑烘兂瑕乪xcel琛ㄦ牸锛屼笉闇€瑕佸鍏ュ悇绉峧ar鍖咃紝绠€鍗曟柟渚?鍙互璁劇疆绠€鍗曟牱寮忋€傚鍑鴻〃鏍煎鍥撅細

瀵煎嚭excel琛ㄦ牸绠€鍗曟柟娉 - wangyue.123.com - moonstak

public void doGet(HttpServletRequest request, HttpServletResponse response)    throws ServletException, IOException {        response.setHeader("Content-type", "application/vnd.ms-excel; charset=gbk");       response.setHeader("Content-Disposition", "attachment; filename=export.xls"); //鑾峰彇鎵撳嵃娴   PrintWriter out = response.getWriter();  // 鎷艱table琛ㄦ牸   String str = "<table border='1'>";   str+= "<tr><th style='width:400px;' bgcolor='#999999'>浼氬憳鍚嶇О</th><th bgcolor='#999999'>鎿嶄綔鏃ユ湡</th><th bgcolor='#999999'>绫誨瀷</th>";     str+= "<th bgcolor='#999999'>閲戦</th><th bgcolor='#999999'>鏀粯鏂瑰紡</th><th bgcolor='#999999'>鍒版鐘舵€?lt;/th>";       str+= "<th bgcolor='#999999'>鎿嶄綔鍛?lt;/th></tr></table>";   out.print(str);   out.flush();   out.close();  }       

if($key1 == 'order_sn')                 {  //sn涓€鑸槸寰堝浣嶆暟瀛                     $data .= '<td style=\'mso-number-format:"\@";\'>' .$item. '</td>';                 }                 else                 {                     $data .= '<td>'.$item.'</td>';                 }