现在的位置: 首页 > 综合 > 正文

将页面表格导出到excel

2013年11月25日 ⁄ 综合 ⁄ 共 2360字 ⁄ 字号 评论关闭

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">

<script>

function f_SaveAsExcel( _sHtml , _sFileName ){
 var oWin=window.open("","","top=2000,left=2000");
 with(oWin) {
//  document.write( f_ShortHTML(_sHtml) );
  document.write( _sHtml);
  document.execCommand('Saveas',false , _sFileName );
  close();
 }
}
</script>
</HEAD>

<BODY>
<div id="content">
    <table align="center" width="100%" BORDER="1" CellSpacing="1" CellPadding="3" class="table" >
      <tr>
        <th scope="col">申请单号</th>
        <th scope="col">申请日期</th>
        <th scope="col">商品名称</th>
        <th scope="col">外汇币种</th>
        <th scope="col">外汇金额</th>
        <th scope="col">汇率</th>
        <th scope="col">状态</th>
      </tr>

      <tr>
        <td align="right"><a href="#" onclick="editApply('1');return false;">1</a></td>
        <td>2007-07-03</td>
        <td>eq</td>
        <td>美元</td>
        <td align="right">231.00</td>
        <td align="right">22.0000</td>
        <td>未复核</td>
      </tr>

      <tr>
        <td align="right"><a href="#" onclick="editApply('2');return false;">2</a></td>
        <td>2007-07-19</td>
        <td style="mso-number-format:0;" align="left">232321111111112333</td>
        <td>美元</td>
        <td align="right">&nbsp;</td>
        <td align="right">11.0000</td>
        <td>未复核</td>
      </tr>

      <tr>
        <td align="right"><a href="#" onclick="editApply('3');return false;">3</a></td>
        <td>2007-07-11</td>
        <td style='mso-number-format:"/@"'>323211111111111</td>
        <td>欧元</td>
        <td align="right">232.00</td>
        <td align="right">222.0000</td>
        <td>未复核</td>
      </tr>

      <tr>
        <td align="right"><a href="#" onclick="editApply('4');return false;">4</a></td>
        <td>2007-07-09</td>
        <td>ereeeee</td>
        <td>美元</td>
        <td align="right">1.00</td>
        <td align="right">6.0000</td>
        <td>未复核</td>
      </tr>

      <tr>
        <td align="right"><a href="#" onclick="editApply('7');return false;">7</a></td>
        <td>2007-07-09</td>
        <td>245gasdfd</td>
        <td>港币</td>
        <td align="right">111.00</td>
        <td align="right">44.0000</td>
        <td>未复核</td>
      </tr>
     
    </table>

</div>
<script>

</script>
<input name="" type="button" onClick="f_SaveAsExcel(document.all.content.innerHTML,'test.xls');" value="test">
</BODY>
</HTML>
 

抱歉!评论已关闭.