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>

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

98

99

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204
