作者:邹杂品_433 | 来源:互联网 | 2023-05-17 17:30
转自:http://www.zhenhua.org/article.asp?id=568
- <table id = "PrintA" width="100%" border="1" cellspacing="0" cellpadding="0" bgcolor = "#61FF13">
- <TR style="text-align : center;">
- <TD>单元格ATD>
- <TD>单元格ATD>
- <TD>单元格ATD>
- <TD>单元格ATD>
- TR>
- <TR>
- <TD colSpan=4 style="text-align : center;"><font color="BLUE" face="Verdana">单元格合并行AFONT>TD>
- TR>
- TABLE>
- <table id = "PrintB" width="100%" border="1" cellspacing="0" cellpadding="0">
- <TR style="text-align : center;">
- <TD>单元格BTD>
- <TD>单元格BTD>
- <TD>单元格BTD>
- <TD>单元格BTD>
- TR>
- <TR>
- <TD colSpan=4 style="text-align : center;">单元格合并行BTD>
- TR>
- TABLE>
- <br/>
- <input type="button" onclick="Javascript:AllAreaWord();" value="导出页面指定区域内容到Word">
- <input type="button" onclick="Javascript:AllAreaExcel();" value="导出页面指定区域内容到Excel">
- <input type="button" onclick="Javascript:CellAreaExcel();" value="导出表单单元格内容到Excel">
- <SCRIPT LANGUAGE="Javascript">
- //指定页面区域内容导入Excel
- function AllAreaExcel()
- {
- var oXL = new ActiveXObject("Excel.Application");
- var oWB = oXL.Workbooks.Add();
- var oSheet = oWB.ActiveSheet;
- var sel=document.body.createTextRange();
- sel.moveToElementText(PrintA);
- sel.select();
- sel.execCommand("Copy");
- oSheet.Paste();
- oXL.Visible = true;
- }
- //指定页面区域“单元格”内容导入Excel
- function CellAreaExcel()
- {
- var oXL = new ActiveXObject("Excel.Application");
- var oWB = oXL.Workbooks.Add();
- var oSheet = oWB.ActiveSheet;
- var Lenr = PrintA.rows.length;
- for (i=0;i<Lenr;i++)
- {
- var Lenc = PrintA.rows(i).cells.length;
- for (j=0;j<Lenc;j++)
- {
- oSheet.Cells(i+1,j+1).value = PrintA.rows(i).cells(j).innerText;
- }
- }
- oXL.Visible = true;
- }
- //指定页面区域内容导入Word
- function AllAreaWord()
- {
- var oWD = new ActiveXObject("Word.Application");
- var oDC = oWD.Documents.Add("",0,1);
- var oRange =oDC.Range(0,1);
- var sel = document.body.createTextRange();
- sel.moveToElementText(PrintA);
- sel.select();
- sel.execCommand("Copy");
- oRange.Paste();
- oWD.Application.Visible = true;
- //window.close();
- }
- SCRIPT>