JavaScript实现 EXCEL 导出 图片功能！？图片不再TABLE里,怎么实现？
<DivHeight="206"Id="divImg"Left="367"TabOrder="4"Text="Div0"Top="141"Width="223"><Con...
<Div Height="206" Id="divImg" Left="367" TabOrder="4" Text="Div0" Top="141" Width="223">
<Contents>
<Image Border="Flat" Column="FILE_DATA" Cursor="HAND" FillType="STRETCH" Height="184" Id="imgPhoto" ImageID="img_bg2" OnClick="fn_img_OnClick" Static="FALSE" Style="input_box01" TabOrder="1" Top="19" Width="223"></Image>
</Contents>
</Div>
上述是画面里图片 问题是现在图片在DIV里 想导出为EXCEL 但不知道怎么做？
以前做的都是吧TABLE里头的图片加到EXCEL 但是 不再TABLE就不知道了。下面是图片在TABLE里时 导出EXCEL的方法！
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=euc-kr">
<script>
var idTmr = "";
function copy(imgPhoto){
var oControlRange = document.body.createControlRange();
oControlRange.add(imgPhoto,0);
oControlRange.select();
document.execCommand("copy");
}
function toExcel(imgPhoto){
copy(imgPhoto);
try{
var xls = new ActiveXObject( "Excel.Application" );
}catch(e){
alert( "1");
return false;
}
xls.visible = true;
var xlBook = xls.Workbooks.Add;
var xlsheet = xlBook.Worksheets(1);
xlBook.Worksheets(1).Activate;
for(var i=0;i<imgPhoto.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>
<title>Credit Card Charge Form</title>
</head>
<body>
<input type="button" value="Excel" onclick="toExcel(imgPhoto)">
<table id="t1">
<tr>
<td><img src="D:\Seat_Assignment\seat\page_decks.gif" width="442" height="25" />
</td>
</tr>
</table>
</body>
</html> 展开
<Contents>
<Image Border="Flat" Column="FILE_DATA" Cursor="HAND" FillType="STRETCH" Height="184" Id="imgPhoto" ImageID="img_bg2" OnClick="fn_img_OnClick" Static="FALSE" Style="input_box01" TabOrder="1" Top="19" Width="223"></Image>
</Contents>
</Div>
上述是画面里图片 问题是现在图片在DIV里 想导出为EXCEL 但不知道怎么做？
以前做的都是吧TABLE里头的图片加到EXCEL 但是 不再TABLE就不知道了。下面是图片在TABLE里时 导出EXCEL的方法！
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=euc-kr">
<script>
var idTmr = "";
function copy(imgPhoto){
var oControlRange = document.body.createControlRange();
oControlRange.add(imgPhoto,0);
oControlRange.select();
document.execCommand("copy");
}
function toExcel(imgPhoto){
copy(imgPhoto);
try{
var xls = new ActiveXObject( "Excel.Application" );
}catch(e){
alert( "1");
return false;
}
xls.visible = true;
var xlBook = xls.Workbooks.Add;
var xlsheet = xlBook.Worksheets(1);
xlBook.Worksheets(1).Activate;
for(var i=0;i<imgPhoto.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>
<title>Credit Card Charge Form</title>
</head>
<body>
<input type="button" value="Excel" onclick="toExcel(imgPhoto)">
<table id="t1">
<tr>
<td><img src="D:\Seat_Assignment\seat\page_decks.gif" width="442" height="25" />
</td>
</tr>
</table>
</body>
</html> 展开
1个回答
展开全部
只要网页能显示图片，就能导出到EXCEL
<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" onclick="toExcel(t1)"> <!--把table的ID传过去就好了-->
<table id="t1">
你的table
</table>
//在IE浏览器里工具-》internet选项-》安全-》自定义级别-》把你禁用的都打开
请参考
<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" onclick="toExcel(t1)"> <!--把table的ID传过去就好了-->
<table id="t1">
你的table
</table>
//在IE浏览器里工具-》internet选项-》安全-》自定义级别-》把你禁用的都打开
请参考
本回答被提问者采纳
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
