javascript,将页面中的内容(文字和图片)导出到excel中的方法:
Javascript代码
![复制代码](http://www.javaeye.com/images/icon_copy.gif)
<script>
var idTmr = "";
function copy(tabid){
var oControlRange = document.body.createControlRange();
oControlRange.add(tabid,0);
oControlRange.select();
document.execCommand("Copy");
}
function toExcel(tabid){
copy(tabid);
try{
var xls = new ActiveXObject( "Excel.Application" );
}catch(e){
alert( "Excel没有安装或浏览器设置不正确.请启用所有Active控件和插件");
return false;
}
xls.visible = true;
var xlBook = xls.Workbooks.Add;
var xlsheet = xlBook.Worksheets(1);
xlBook.Worksheets(1).Activate;
for(var i=0;i<tabid.rows(0).cells.length;i++){
xlsheet.Columns(i+1).ColumnWidth=15;
}
xlsheet.Paste;
xls=null;
idTmr = window.setInterval("Cleanup();",1);
}
function Cleanup() {
window.clearInterval(idTmr);
CollectGarbage();
}
</script>
<input type="button" value="导入excel" οnclick="toExcel(t1)"> <!--把table的ID传过去就好了-->
<table id="t1">
<tr>
<td align="center">我的table</td>
</tr>
<tr>
<td><img src="javalogo.jpg" width="100" height="100" alt=""/></td>
</tr>
</table>
var idTmr = "";
function copy(tabid){
var oControlRange = document.body.createControlRange();
oControlRange.add(tabid,0);
oControlRange.select();
document.execCommand("Copy");
}
function toExcel(tabid){
copy(tabid);
try{
var xls = new ActiveXObject( "Excel.Application" );
}catch(e){
alert( "Excel没有安装或浏览器设置不正确.请启用所有Active控件和插件");
return false;
}
xls.visible = true;
var xlBook = xls.Workbooks.Add;
var xlsheet = xlBook.Worksheets(1);
xlBook.Worksheets(1).Activate;
for(var i=0;i<tabid.rows(0).cells.length;i++){
xlsheet.Columns(i+1).ColumnWidth=15;
}
xlsheet.Paste;
xls=null;
idTmr = window.setInterval("Cleanup();",1);
}
function Cleanup() {
window.clearInterval(idTmr);
CollectGarbage();
}
</script>
<input type="button" value="导入excel" οnclick="toExcel(t1)"> <!--把table的ID传过去就好了-->
<table id="t1">
<tr>
<td align="center">我的table</td>
</tr>
<tr>
<td><img src="javalogo.jpg" width="100" height="100" alt=""/></td>
</tr>
</table>
预览图如下:
导出效果图如下: