<object classid="clsid:0002E510-0000-0000-C000-000000000046" id="Spreadsheet1" codebase="Office下找msowc.cab放到网站目录" width="576" height="288">
<param name="HTMLURL" value="Http://www.csdn.net/">
<param name="DataType" value="HTMLURL">
<param name="AutoFit" value="0">
<param name="DisplayColHeaders" value="-1">
<param name="DisplayGridlines" value="-1">
<param name="DisplayHorizontalScrollBar" value="-1">
<param name="DisplayRowHeaders" value="-1">
<param name="DisplayTitleBar" value="-1">
<param name="DisplayToolbar" value="-1">
<param name="DisplayVerticalScrollBar" value="-1">
<param name="EnableAutoCalculate" value="-1">
<param name="EnableEvents" value="-1">
<param name="MoveAfterReturn" value="-1">
<param name="MoveAfterReturnDirection" value="0">
<param name="RightToLeft" value="0">
<param name="ViewableRange" value="1:65536">
</object>
<param name="HTMLURL" value="Http://www.csdn.net/">
<param name="DataType" value="HTMLURL">
<param name="AutoFit" value="0">
<param name="DisplayColHeaders" value="-1">
<param name="DisplayGridlines" value="-1">
<param name="DisplayHorizontalScrollBar" value="-1">
<param name="DisplayRowHeaders" value="-1">
<param name="DisplayTitleBar" value="-1">
<param name="DisplayToolbar" value="-1">
<param name="DisplayVerticalScrollBar" value="-1">
<param name="EnableAutoCalculate" value="-1">
<param name="EnableEvents" value="-1">
<param name="MoveAfterReturn" value="-1">
<param name="MoveAfterReturnDirection" value="0">
<param name="RightToLeft" value="0">
<param name="ViewableRange" value="1:65536">
</object>
我加了个函数
<script language="javascript">
function fit()
{
Spreadsheet1.HTMLData = dg_shoppingCart.innerHTML;
}
</script>
和一个按钮
<input type=button value='for excel' onClick="javascript:fit();">
最后是一个table
dg_shoppingCart
可是点按钮内容都添不进去
并且这样也只能filling一个table.我网页有多个table,想每个都按顺序导进excel中
<div id="Excel">
<object classid="clsid:0002E510-0000-0000-C000-000000000046" id="Spreadsheet1" width="576" height="288">
<param name="HTMLURL" value="1.htm">
<param name="DataType" value="HTMLURL">
<param name="AutoFit" value="0">
<param name="DisplayColHeaders" value="-1">
<param name="DisplayGridlines" value="-1">
<param name="DisplayHorizontalScrollBar" value="-1">
<param name="DisplayRowHeaders" value="-1">
<param name="DisplayTitleBar" value="-1">
<param name="DisplayToolbar" value="-1">
<param name="DisplayVerticalScrollBar" value="-1">
<param name="EnableAutoCalculate" value="-1">
<param name="EnableEvents" value="-1">
<param name="MoveAfterReturn" value="-1">
<param name="MoveAfterReturnDirection" value="0">
<param name="RightToLeft" value="0">
<param name="ViewableRange" value="1:65536">
</object>
</div>
<br>
<input type=button onclick="ImportExcel()">
<script>
function ImportExcel()
{
var strURL="2.htm";
Excel.innerHTML="<object classid='clsid:0002E510-0000-0000-C000-000000000046' id='Spreadsheet1' width='576' height='288'><param name='HTMLURL' value='"+strURL+"'><param name='DataType' value='HTMLURL'><param name='AutoFit' value='0'><param name='DisplayColHeaders' value='-1'><param name='DisplayGridlines' value='-1'><param name='DisplayHorizontalScrollBar' value='-1'><param name='DisplayRowHeaders' value='-1'><param name='DisplayTitleBar' value='-1'><param name='DisplayToolbar' value='-1'><param name='DisplayVerticalScrollBar' value='-1'><param name='EnableAutoCalculate' value='-1'><param name='EnableEvents' value='-1'><param name='MoveAfterReturn' value='-1'><param name='MoveAfterReturnDirection' value='0'><param name='RightToLeft' value='0'><param name='ViewableRange' value='1:65536'></object>";
}
</script>
1.htm
<table border="1" width="100%">
<tr>
<td width="33%">1</td>
<td width="33%">1</td>
<td width="34%">1</td>
</tr>
<tr>
<td width="33%">1</td>
<td width="33%">1</td>
<td width="34%">1</td>
</tr>
</table>
2.htm
<table border="1" width="100%">
<tr>
<td width="33%">2</td>
<td width="33%">2</td>
<td width="34%">2</td>
</tr>
<tr>
<td width="33%">2</td>
<td width="33%">2</td>
<td width="34%">2</td>
</tr>
</table>
3.htm
<table border="1" width="100%">
<tr>
<td width="33%">1</td>
<td width="33%">1</td>
<td width="34%">1</td>
</tr>
<tr>
<td width="33%">1</td>
<td width="33%">1</td>
<td width="34%">1</td>
</tr>
</table>
<br>
<table border="1" width="100%">
<tr>
<td width="33%">2</td>
<td width="33%">2</td>
<td width="34%">2</td>
</tr>
<tr>
<td width="33%">2</td>
<td width="33%">2</td>
<td width="34%">2</td>
</tr>
</table>不知行不行,这三个htm文件用脚本在服务器动态生成.
两个表还是不行,只是导入第一个table