Javascript导出Excel的方法

<!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

<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>

posted @ 2008-11-25 15:05 yunhuasheng 阅读(3653) 评论(0) 收藏举报

刷新页面返回顶部