1
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
2
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
3
<html xmlns="http://www.w3.org/1999/xhtml">
4
<head>
5
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"/>
6
<title>WEB页面导出为EXCEL文档的方法</title>
7
</head>
8
<body>
9
<table id="tableExcel" width="100%" border="1" cellspacing="0" cellpadding="0">
10
<tr>
11
<td colspan="5" align="center">WEB页面导出为EXCEL文档的方法</td>
12
</tr>
13
<tr>
14
<td>列标题1</td>
15
<td>列标题2</td>
16
<td>列标题3</td>
17
<td>列标题4</td>
18
<td>列标题5</td>
19
</tr>
20
<tr>
21
<td>aaa</td>
22
<td>bbb</td>
23
<td>ccc</td>
24
<td>ddd</td>
25
<td>eee</td>
26
</tr>
27
<tr>
28
<td>AAA</td>
29
<td>BBB</td>
30
<td>CCC</td>
31
<td>DDD</td>
32
<td>EEE</td>
33
</tr>
34
<tr>
35
<td>FFF</td>
36
<td>GGG</td>
37
<td>HHH</td>
38
<td>III</td>
39
<td>JJJ</td>
40
</tr>
41
</table>
42
<input type="button" onclick="javascript:method1('tableExcel');" value="第一种方法导入到EXCEL">
43
<input type="button" onclick="javascript:method2('tableExcel');" value="第二种方法导入到EXCEL">
44
<input type="button" onclick="javascript:getXlsFromTbl('tableExcel',null);" value="第三种方法导入到EXCEL">
45
<SCRIPT LANGUAGE="javascript">
46
function method1(tableid) {//整个表格拷贝到EXCEL中
47
var curTbl = document.getElementById(tableid);
48
var oXL = new ActiveXObject("Excel.Application");
49
//创建AX对象excel
50
var oWB = oXL.Workbooks.Add();
51
//获取workbook对象
52
var oSheet = oWB.ActiveSheet;
53
//激活当前sheet
54
var sel = document.body.createTextRange();
55
sel.moveToElementText(curTbl);
56
//把表格中的内容移到TextRange中
57
sel.select();
58
//全选TextRange中内容
59
sel.execCommand("Copy");
60
//复制TextRange中内容
61
oSheet.Paste();
62
//粘贴到活动的EXCEL中
63
oXL.Visible = true;
64
//设置excel可见属性
65
}
66
function method2(tableid) //读取表格中每个单元到EXCEL中
67
{
68
var curTbl = document.getElementById(tableid);
69
var oXL = new ActiveXObject("Excel.Application");
70
//创建AX对象excel
71
var oWB = oXL.Workbooks.Add();
72
//获取workbook对象
73
var oSheet = oWB.ActiveSheet;
74
//激活当前sheet
75
var Lenr = curTbl.rows.length;
76
//取得表格行数
77
for (i = 0; i < Lenr; i++)
78
{
79
var Lenc = curTbl.rows(i).cells.length;
80
//取得每行的列数
81
for (j = 0; j < Lenc; j++)
82
{
83
oSheet.Cells(i + 1, j + 1).value = curTbl.rows(i).cells(j).innerText;
84
//赋值
85
}
86
}
87
oXL.Visible = true;
88
//设置excel可见属性
89
}
90
function getXlsFromTbl(inTblId, inWindow) {
91
try {
92
var allStr = "";
93
var curStr = "";
94
//alert("getXlsFromTbl");
95
if (inTblId != null && inTblId != "" && inTblId != "null") {
96
curStr = getTblData(inTblId, inWindow);
97
}
98
if (curStr != null) {
99
allStr += curStr;
100
}
101
else {
102
alert("你要导出的表不存在!");
103
return;
104
}
105
var fileName = getExcelFileName();
106
doFileExport(fileName, allStr);
107
}
108
catch(e) {
109
alert("导出发生异常:" + e.name + "->" + e.description + "!");
110
}
111
}
112
function getTblData(inTbl, inWindow) {
113
var rows = 0;
114
//alert("getTblData is " + inWindow);
115
var tblDocument = document;
116
if (!!inWindow && inWindow != "") {
117
if (!document.all(inWindow)) {
118
return null;
119
}
120
else {
121
tblDocument = eval(inWindow).document;
122
}
123
}
124
var curTbl = tblDocument.getElementById(inTbl);
125
var outStr = "";
126
if (curTbl != null) {
127
for (var j = 0; j < curTbl.rows.length; j++) {
128
//alert("j is " + j);
129
for (var i = 0; i < curTbl.rows[j].cells.length; i++) {
130
//alert("i is " + i);
131
if (i == 0 && rows > 0) {
132
outStr += " \t";
133
rows -= 1;
134
}
135
outStr += curTbl.rows[j].cells[i].innerText + "\t";
136
if (curTbl.rows[j].cells[i].colSpan > 1) {
137
for (var k = 0; k < curTbl.rows[j].cells[i].colSpan - 1; k++) {
138
outStr += " \t";
139
}
140
}
141
if (i == 0) {
142
if (rows == 0 && curTbl.rows[j].cells[i].rowSpan > 1) {
143
rows = curTbl.rows[j].cells[i].rowSpan - 1;
144
}
145
}
146
}
147
outStr += "\r\n";
148
}
149
}
150
else {
151
outStr = null;
152
alert(inTbl + "不存在!");
153
}
154
return outStr;
155
}
156
function getExcelFileName() {
157
var d = new Date();
158
var curYear = d.getYear();
159
var curMonth = "" + (d.getMonth() + 1);
160
var curDate = "" + d.getDate();
161
var curHour = "" + d.getHours();
162
var curMinute = "" + d.getMinutes();
163
var curSecond = "" + d.getSeconds();
164
if (curMonth.length == 1) {
165
curMonth = "0" + curMonth;
166
}
167
if (curDate.length == 1) {
168
curDate = "0" + curDate;
169
}
170
if (curHour.length == 1) {
171
curHour = "0" + curHour;
172
}
173
if (curMinute.length == 1) {
174
curMinute = "0" + curMinute;
175
}
176
if (curSecond.length == 1) {
177
curSecond = "0" + curSecond;
178
}
179
var fileName = "leo_zhang" + "_" + curYear + curMonth + curDate + "_"
180
+ curHour + curMinute + curSecond + ".csv";
181
//alert(fileName);
182
return fileName;
183
}
184
function doFileExport(inName, inStr) {
185
var xlsWin = null;
186
if (!!document.all("glbHideFrm")) {
187
xlsWin = glbHideFrm;
188
}
189
else {
190
var width = 6;
191
var height = 4;
192
var openPara = "left=" + (window.screen.width / 2 - width / 2)
193
+ ",top=" + (window.screen.height / 2 - height / 2)
194
+ ",scrollbars=no,width=" + width + ",height=" + height;
195
xlsWin = window.open("", "_blank", openPara);
196
}
197
xlsWin.document.write(inStr);
198
xlsWin.document.close();
199
xlsWin.document.execCommand('Saveas', true, inName);
200
xlsWin.close();
201
}
202
</SCRIPT>
203
</body>
204
</html>
![](/Images/OutliningIndicators/None.gif)
2
![](/Images/OutliningIndicators/None.gif)
3
![](/Images/OutliningIndicators/None.gif)
4
![](/Images/OutliningIndicators/None.gif)
5
![](/Images/OutliningIndicators/None.gif)
6
![](/Images/OutliningIndicators/None.gif)
7
![](/Images/OutliningIndicators/None.gif)
8
![](/Images/OutliningIndicators/None.gif)
9
![](/Images/OutliningIndicators/None.gif)
10
![](/Images/OutliningIndicators/None.gif)
11
![](/Images/OutliningIndicators/None.gif)
12
![](/Images/OutliningIndicators/None.gif)
13
![](/Images/OutliningIndicators/None.gif)
14
![](/Images/OutliningIndicators/None.gif)
15
![](/Images/OutliningIndicators/None.gif)
16
![](/Images/OutliningIndicators/None.gif)
17
![](/Images/OutliningIndicators/None.gif)
18
![](/Images/OutliningIndicators/None.gif)
19
![](/Images/OutliningIndicators/None.gif)
20
![](/Images/OutliningIndicators/None.gif)
21
![](/Images/OutliningIndicators/None.gif)
22
![](/Images/OutliningIndicators/None.gif)
23
![](/Images/OutliningIndicators/None.gif)
24
![](/Images/OutliningIndicators/None.gif)
25
![](/Images/OutliningIndicators/None.gif)
26
![](/Images/OutliningIndicators/None.gif)
27
![](/Images/OutliningIndicators/None.gif)
28
![](/Images/OutliningIndicators/None.gif)
29
![](/Images/OutliningIndicators/None.gif)
30
![](/Images/OutliningIndicators/None.gif)
31
![](/Images/OutliningIndicators/None.gif)
32
![](/Images/OutliningIndicators/None.gif)
33
![](/Images/OutliningIndicators/None.gif)
34
![](/Images/OutliningIndicators/None.gif)
35
![](/Images/OutliningIndicators/None.gif)
36
![](/Images/OutliningIndicators/None.gif)
37
![](/Images/OutliningIndicators/None.gif)
38
![](/Images/OutliningIndicators/None.gif)
39
![](/Images/OutliningIndicators/None.gif)
40
![](/Images/OutliningIndicators/None.gif)
41
![](/Images/OutliningIndicators/None.gif)
42
![](/Images/OutliningIndicators/None.gif)
43
![](/Images/OutliningIndicators/None.gif)
44
![](/Images/OutliningIndicators/None.gif)
45
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
46
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
47
![](/Images/OutliningIndicators/InBlock.gif)
48
![](/Images/OutliningIndicators/InBlock.gif)
49
![](/Images/OutliningIndicators/InBlock.gif)
50
![](/Images/OutliningIndicators/InBlock.gif)
51
![](/Images/OutliningIndicators/InBlock.gif)
52
![](/Images/OutliningIndicators/InBlock.gif)
53
![](/Images/OutliningIndicators/InBlock.gif)
54
![](/Images/OutliningIndicators/InBlock.gif)
55
![](/Images/OutliningIndicators/InBlock.gif)
56
![](/Images/OutliningIndicators/InBlock.gif)
57
![](/Images/OutliningIndicators/InBlock.gif)
58
![](/Images/OutliningIndicators/InBlock.gif)
59
![](/Images/OutliningIndicators/InBlock.gif)
60
![](/Images/OutliningIndicators/InBlock.gif)
61
![](/Images/OutliningIndicators/InBlock.gif)
62
![](/Images/OutliningIndicators/InBlock.gif)
63
![](/Images/OutliningIndicators/InBlock.gif)
64
![](/Images/OutliningIndicators/InBlock.gif)
65
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
66
![](/Images/OutliningIndicators/InBlock.gif)
67
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
68
![](/Images/OutliningIndicators/InBlock.gif)
69
![](/Images/OutliningIndicators/InBlock.gif)
70
![](/Images/OutliningIndicators/InBlock.gif)
71
![](/Images/OutliningIndicators/InBlock.gif)
72
![](/Images/OutliningIndicators/InBlock.gif)
73
![](/Images/OutliningIndicators/InBlock.gif)
74
![](/Images/OutliningIndicators/InBlock.gif)
75
![](/Images/OutliningIndicators/InBlock.gif)
76
![](/Images/OutliningIndicators/InBlock.gif)
77
![](/Images/OutliningIndicators/InBlock.gif)
78
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
79
![](/Images/OutliningIndicators/InBlock.gif)
80
![](/Images/OutliningIndicators/InBlock.gif)
81
![](/Images/OutliningIndicators/InBlock.gif)
82
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
83
![](/Images/OutliningIndicators/InBlock.gif)
84
![](/Images/OutliningIndicators/InBlock.gif)
85
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
86
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
87
![](/Images/OutliningIndicators/InBlock.gif)
88
![](/Images/OutliningIndicators/InBlock.gif)
89
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
90
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
91
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
92
![](/Images/OutliningIndicators/InBlock.gif)
93
![](/Images/OutliningIndicators/InBlock.gif)
94
![](/Images/OutliningIndicators/InBlock.gif)
95
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
96
![](/Images/OutliningIndicators/InBlock.gif)
97
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
98
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
99
![](/Images/OutliningIndicators/InBlock.gif)
100
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
101
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
102
![](/Images/OutliningIndicators/InBlock.gif)
103
![](/Images/OutliningIndicators/InBlock.gif)
104
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
105
![](/Images/OutliningIndicators/InBlock.gif)
106
![](/Images/OutliningIndicators/InBlock.gif)
107
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
108
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
109
![](/Images/OutliningIndicators/InBlock.gif)
110
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
111
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
112
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
113
![](/Images/OutliningIndicators/InBlock.gif)
114
![](/Images/OutliningIndicators/InBlock.gif)
115
![](/Images/OutliningIndicators/InBlock.gif)
116
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
117
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
118
![](/Images/OutliningIndicators/InBlock.gif)
119
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
120
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
121
![](/Images/OutliningIndicators/InBlock.gif)
122
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
123
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
124
![](/Images/OutliningIndicators/InBlock.gif)
125
![](/Images/OutliningIndicators/InBlock.gif)
126
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
127
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
128
![](/Images/OutliningIndicators/InBlock.gif)
129
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
130
![](/Images/OutliningIndicators/InBlock.gif)
131
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
132
![](/Images/OutliningIndicators/InBlock.gif)
133
![](/Images/OutliningIndicators/InBlock.gif)
134
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
135
![](/Images/OutliningIndicators/InBlock.gif)
136
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
137
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
138
![](/Images/OutliningIndicators/InBlock.gif)
139
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
140
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
141
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
142
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
143
![](/Images/OutliningIndicators/InBlock.gif)
144
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
145
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
146
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
147
![](/Images/OutliningIndicators/InBlock.gif)
148
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
149
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
150
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
151
![](/Images/OutliningIndicators/InBlock.gif)
152
![](/Images/OutliningIndicators/InBlock.gif)
153
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
154
![](/Images/OutliningIndicators/InBlock.gif)
155
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
156
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
157
![](/Images/OutliningIndicators/InBlock.gif)
158
![](/Images/OutliningIndicators/InBlock.gif)
159
![](/Images/OutliningIndicators/InBlock.gif)
160
![](/Images/OutliningIndicators/InBlock.gif)
161
![](/Images/OutliningIndicators/InBlock.gif)
162
![](/Images/OutliningIndicators/InBlock.gif)
163
![](/Images/OutliningIndicators/InBlock.gif)
164
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
165
![](/Images/OutliningIndicators/InBlock.gif)
166
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
167
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
168
![](/Images/OutliningIndicators/InBlock.gif)
169
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
170
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
171
![](/Images/OutliningIndicators/InBlock.gif)
172
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
173
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
174
![](/Images/OutliningIndicators/InBlock.gif)
175
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
176
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
177
![](/Images/OutliningIndicators/InBlock.gif)
178
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
179
![](/Images/OutliningIndicators/InBlock.gif)
180
![](/Images/OutliningIndicators/InBlock.gif)
181
![](/Images/OutliningIndicators/InBlock.gif)
182
![](/Images/OutliningIndicators/InBlock.gif)
183
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
184
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
185
![](/Images/OutliningIndicators/InBlock.gif)
186
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
187
![](/Images/OutliningIndicators/InBlock.gif)
188
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
189
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
190
![](/Images/OutliningIndicators/InBlock.gif)
191
![](/Images/OutliningIndicators/InBlock.gif)
192
![](/Images/OutliningIndicators/InBlock.gif)
193
![](/Images/OutliningIndicators/InBlock.gif)
194
![](/Images/OutliningIndicators/InBlock.gif)
195
![](/Images/OutliningIndicators/InBlock.gif)
196
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
197
![](/Images/OutliningIndicators/InBlock.gif)
198
![](/Images/OutliningIndicators/InBlock.gif)
199
![](/Images/OutliningIndicators/InBlock.gif)
200
![](/Images/OutliningIndicators/InBlock.gif)
201
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
202
![](/Images/OutliningIndicators/None.gif)
203
![](/Images/OutliningIndicators/None.gif)
204
![](/Images/OutliningIndicators/None.gif)