在原先的表格的基础上导出excel文件,原先是想用java后台来实现这个功能,但是,后来发现,原来extjs也附带有导出excel表的功能,就在GridPanel的基础上导出,
http://www.blogjava.net/rockblue1988/archive/2012/02/29/370977.html,这是我做的时候,参考的一篇网上的文章。具体的做法是,将extjsGridPanel里面的数据拿出来,转换成xml,然后发送给后台,后台响应之后,将数据输出为Excel的格式,具体代码如下。
之后,后台的代码就比较简单了,以下是在strut2下写的。
这样一来,就可以实现利用js导出excel文件了。。
1
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
|
//利用extjs导出excel文件---begin
function
exportExcel(gridpanel) {
//传入的GridPanel的实例
var
vExportContent = gridpanel.getExcelXml();
//获取数据
if
(Ext.isIE8||Ext.isIE6 || Ext.isIE7 || Ext.isSafari
|| Ext.isSafari2 || Ext.isSafari3) {
//判断浏览器
var
fd = Ext.get(
'frmDummy'
);
if
(!fd) {
fd = Ext.DomHelper.append(
Ext.getBody(), {
tag :
'form'
,
method :
'post'
,
id :
'frmDummy'
,
action : exportExcelGrid,
target :
'_blank'
,
name :
'frmDummy'
,
cls :
'x-hidden'
,
cn : [ {
tag :
'input'
,
name :
'exportContent'
,
id :
'exportContent'
,
type :
'hidden'
} ]
},
true
);
}
fd.child(
'#exportContent'
).set( {
value : vExportContent
});
fd.dom.submit();
}
else
{
document.location =
'data:application/vnd.ms-excel;base64,'
+ Base64
.encode(vExportContent);
}
}
//利用extjs导出excel文件---end
|
除此之外,还要引入一个文件
1
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
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
|
/**
* allows for downloading of grid data (store) directly into excel
* Method: extracts data of gridPanel store, uses columnModel to construct XML excel document,
* converts to Base64, then loads everything into a data URL link.
*
* @author Animal <extjs support team>
*
*/
/**
* base64 encode / decode
*
* @location http://www.webtoolkit.info/
*
*/
var
Base64 = (
function
() {
// Private property
var
keyStr =
"ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/="
;
// Private method for UTF-8 encoding
function
utf8Encode(string) {
string = string.replace(/\\r\\n/g,
"\\n"
);
var
utftext =
""
;
for
(
var
n = 0; n < string.length; n++) {
var
c = string.charCodeAt(n);
if
(c < 128) {
utftext += String.fromCharCode(c);
}
else
if
((c > 127) && (c < 2048)) {
utftext += String.fromCharCode((c >> 6) | 192);
utftext += String.fromCharCode((c & 63) | 128);
}
else
{
utftext += String.fromCharCode((c >> 12) | 224);
utftext += String.fromCharCode(((c >> 6) & 63) | 128);
utftext += String.fromCharCode((c & 63) | 128);
}
}
return
utftext;
}
// Public method for encoding
return
{
encode : (
typeof
btoa ==
'function'
) ?
function
(input) {
return
btoa(utf8Encode(input));
} :
function
(input) {
var
output =
""
;
var
chr1, chr2, chr3, enc1, enc2, enc3, enc4;
var
i = 0;
input = utf8Encode(input);
while
(i < input.length) {
chr1 = input.charCodeAt(i++);
chr2 = input.charCodeAt(i++);
chr3 = input.charCodeAt(i++);
enc1 = chr1 >> 2;
enc2 = ((chr1 & 3) << 4) | (chr2 >> 4);
enc3 = ((chr2 & 15) << 2) | (chr3 >> 6);
enc4 = chr3 & 63;
if
(isNaN(chr2)) {
enc3 = enc4 = 64;
}
else
if
(isNaN(chr3)) {
enc4 = 64;
}
output = output +
keyStr.charAt(enc1) + keyStr.charAt(enc2) +
keyStr.charAt(enc3) + keyStr.charAt(enc4);
}
return
output;
}
};
})();
Ext.override(Ext.grid.GridPanel, {
var
worksheet =
this
.createWorksheet(includeHidden);
var
totalWidth =
this
.getColumnModel().getTotalWidth(includeHidden);
return
'<xml version="1.0" encoding="utf-8">'
+
'<ss:Workbook xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:o="urn:schemas-microsoft-com:office:office">'
+
'<o:DocumentProperties><o:Title>'
+
this
.title +
'</o:Title></o:DocumentProperties>'
+
'<ss:ExcelWorkbook>'
+
'<ss:WindowHeight>'
+ worksheet.height +
'</ss:WindowHeight>'
+
'<ss:WindowWidth>'
+ worksheet.width +
'</ss:WindowWidth>'
+
'<ss:ProtectStructure>False</ss:ProtectStructure>'
+
'<ss:ProtectWindows>False</ss:ProtectWindows>'
+
'</ss:ExcelWorkbook>'
+
'<ss:Styles>'
+
'<ss:Style ss:ID="Default">'
+
'<ss:Alignment ss:Vertical="Top" ss:WrapText="1" />'
+
'<ss:Font ss:FontName="arial" ss:Size="10" />'
+
'<ss:Borders>'
+
'<ss:Border ss:Color="#e4e4e4" ss:Weight="1" ss:LineStyle="Continuous" ss:Position="Top" />'
+
'<ss:Border ss:Color="#e4e4e4" ss:Weight="1" ss:LineStyle="Continuous" ss:Position="Bottom" />'
+
'<ss:Border ss:Color="#e4e4e4" ss:Weight="1" ss:LineStyle="Continuous" ss:Position="Left" />'
+
'<ss:Border ss:Color="#e4e4e4" ss:Weight="1" ss:LineStyle="Continuous" ss:Position="Right" />'
+
'</ss:Borders>'
+
'<ss:Interior />'
+
'<ss:NumberFormat />'
+
'<ss:Protection />'
+
'</ss:Style>'
+
'<ss:Style ss:ID="title">'
+
'<ss:Borders />'
+
'<ss:Font />'
+
'<ss:Alignment ss:WrapText="1" ss:Vertical="Center" ss:Horizontal="Center" />'
+
'<ss:NumberFormat ss:Format="@" />'
+
'</ss:Style>'
+
'<ss:Style ss:ID="headercell">'
+
'<ss:Font ss:Bold="1" ss:Size="10" />'
+
'<ss:Alignment ss:WrapText="1" ss:Horizontal="Center" />'
+
'<ss:Interior ss:Pattern="Solid" ss:Color="#A3C9F1" />'
+
'</ss:Style>'
+
'<ss:Style ss:ID="even">'
+
'<ss:Interior ss:Pattern="Solid" ss:Color="#CCFFFF" />'
+
'</ss:Style>'
+
'<ss:Style ss:Parent="even" ss:ID="evendate">'
+
'<ss:NumberFormat ss:Format="yyyy-mm-dd" />'
+
'</ss:Style>'
+
'<ss:Style ss:Parent="even" ss:ID="evenint">'
+
'<ss:NumberFormat ss:Format="0" />'
+
'</ss:Style>'
+
'<ss:Style ss:Parent="even" ss:ID="evenfloat">'
+
'<ss:NumberFormat ss:Format="0.00" />'
+
'</ss:Style>'
+
'<ss:Style ss:ID="odd">'
+
'<ss:Interior ss:Pattern="Solid" ss:Color="#CCCCFF" />'
+
'</ss:Style>'
+
'<ss:Style ss:Parent="odd" ss:ID="odddate">'
+
'<ss:NumberFormat ss:Format="yyyy-mm-dd" />'
+
'</ss:Style>'
+
'<ss:Style ss:Parent="odd" ss:ID="oddint">'
+
'<ss:NumberFormat ss:Format="0" />'
+
'</ss:Style>'
+
'<ss:Style ss:Parent="odd" ss:ID="oddfloat">'
+
'<ss:NumberFormat ss:Format="0.00" />'
+
'</ss:Style>'
+
'</ss:Styles>'
+
worksheet.xml +
'</ss:Workbook>'
;
},
createWorksheet:
function
(includeHidden) {
// Calculate cell data types and extra class names which affect formatting
var
cellType = [];
var
cellTypeClass = [];
var
cm =
this
.getColumnModel();
var
totalWidthInPixels = 0;
var
colXml =
''
;
var
headerXml =
''
;
var
visibleColumnCountReduction = 0;
var
colCount = cm.getColumnCount();
for
(
var
i = 0; i < colCount; i++) {
if
((cm.getDataIndex(i) !=
''
)
&& (includeHidden || !cm.isHidden(i))) {
var
w = cm.getColumnWidth(i)
totalWidthInPixels += w;
if
(cm.getColumnHeader(i) ===
""
){
cellType.push(
"None"
);
cellTypeClass.push(
""
);
++visibleColumnCountReduction;
}
else
{
colXml +=
'<ss:Column ss:AutoFitWidth="1" ss:Width="'
+ w +
'" />'
;
headerXml +=
'<ss:Cell ss:StyleID="headercell">'
+
'<ss:Data ss:Type="String">'
+ cm.getColumnHeader(i) +
'</ss:Data>'
+
'<ss:NamedCell ss:Name="Print_Titles" /></ss:Cell>'
;
var
fld =
this
.store.recordType.prototype.fields.get(cm.getDataIndex(i));
switch
(fld.type) {
case
"int"
:
cellType.push(
"Number"
);
cellTypeClass.push(
"int"
);
break
;
case
"float"
:
cellType.push(
"Number"
);
cellTypeClass.push(
"float"
);
break
;
case
"bool"
:
case
"boolean"
:
cellType.push(
"String"
);
cellTypeClass.push(
""
);
break
;
case
"date"
:
cellType.push(
"DateTime"
);
cellTypeClass.push(
"date"
);
break
;
default
:
cellType.push(
"String"
);
cellTypeClass.push(
""
);
break
;
}
}
}
}
var
visibleColumnCount = cellType.length - visibleColumnCountReduction;
var
result = {
height: 9000,
width: Math.floor(totalWidthInPixels * 30) + 50
};
// Generate worksheet header details.
var
t =
'<ss:Worksheet ss:Name="'
+
this
.title +
'">'
+
'<ss:Names>'
+
'<ss:NamedRange ss:Name="Print_Titles" ss:RefersTo="=\\'
' + this.title + '
\\
'!R1:R2" />'
+
'</ss:Names>'
+
'<ss:Table x:FullRows="1" x:FullColumns="1"'
+
' ss:ExpandedColumnCount="'
+ (visibleColumnCount + 2) +
'" ss:ExpandedRowCount="'
+ (
this
.store.getCount() + 2) +
'">'
+
colXml +
'<ss:Row ss:Height="38">'
+
'<ss:Cell ss:StyleID="title" ss:MergeAcross="'
+ (visibleColumnCount - 1) +
'">'
+
'<html:B></html:B></ss:Data><ss:NamedCell ss:Name="Print_Titles" />'
+
'</ss:Cell>'
+
'</ss:Row>'
+
'<ss:Row ss:AutoFitHeight="1">'
+
headerXml +
'</ss:Row>'
;
// Generate the data rows from the data in the Store
for
(
var
i = 0, it =
this
.store.data.items, l = it.length; i < l; i++) {
t +=
'<ss:Row>'
;
var
cellClass = (i & 1) ?
'odd'
:
'even'
;
r = it[i].data;
var
k = 0;
for
(
var
j = 0; j < colCount; j++) {
if
((cm.getDataIndex(j) !=
''
)
&& (includeHidden || !cm.isHidden(j))) {
var
v = r[cm.getDataIndex(j)];
if
(cellType[k] !==
"None"
) {
t +=
'<ss:Cell ss:StyleID="'
+ cellClass + cellTypeClass[k] +
'"><ss:Data ss:Type="'
+ cellType[k] +
'">'
;
if
(cellType[k] ==
'DateTime'
) {
t += v.format(
'Y-m-d'
);
}
else
{
t += v;
}
t +=
'</ss:Data></ss:Cell>'
;
}
k++;
}
}
t +=
'</ss:Row>'
;
}
result.xml = t +
'</ss:Table>'
+
'<x:WorksheetOptions>'
+
'<x:PageSetup>'
+
'<x:Layout x:CenterHorizontal="1" x:Orientation="Landscape" />'
+
'<x:Footer x:Data="Page &P of &N" x:Margin="0.5" />'
+
'<x:PageMargins x:Top="0.5" x:Right="0.5" x:Left="0.5" x:Bottom="0.8" />'
+
'</x:PageSetup>'
+
'<x:FitToPage />'
+
'<x:Print>'
+
'<x:PrintErrors>Blank</x:PrintErrors>'
+
'<x:FitWidth>1</x:FitWidth>'
+
'<x:FitHeight>32767</x:FitHeight>'
+
'<x:ValidPrinterInfo />'
+
'<x:VerticalResolution>600</x:VerticalResolution>'
+
'</x:Print>'
+
'<x:Selected />'
+
'<x:DoNotDisplayGridlines />'
+
'<x:ProtectObjects>False</x:ProtectObjects>'
+
'<x:ProtectScenarios>False</x:ProtectScenarios>'
+
'</x:WorksheetOptions>'
+
'</ss:Worksheet>'
;
return
result;
}
});
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
logger.info(
"导出excel记录"
);
ActionContext context = ActionContext.getContext();
HttpServletRequest request = (HttpServletRequest) context
.get(ServletActionContext.HTTP_REQUEST);
HttpServletResponse response = (HttpServletResponse) context
.get(ServletActionContext.HTTP_RESPONSE);
PrintWriter out;
try
{
out = response.getWriter();
response.setHeader(
"Content-Type"
,
"application/force-download"
);
response.setHeader(
"Content-Type"
,
"application/vnd.ms-excel"
);
response.setHeader(
"Content-Disposition"
,
"attachment;filename=export.xls"
);
out.print(request.getParameter(
"exportContent"
));
}
catch
(IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return
null
;
}
|