<%@ page language="java" pageEncoding="GBK"%>
<%@page contentType="text/html;charset=UTF-8"%>
<html>
<head>
<title>Column Layout</title>
<link rel="stylesheet" type="text/css" href="js/ext-all.css" />
<script type="text/javascript" src="js/ext-base.js"></script>
<script type="text/javascript" src="js/ext-all.js"></script>
<script type="text/javascript" src="js/gridToExcel.js"></script>
<!--<script type="text/javascript" src="js/ext-lang-zh_CN-GBK-min.js"></script>
--><script type="text/javascript">
Ext.onReady(function(){
Ext.state.Manager.setProvider(new Ext.state.CookieProvider());
var myData = [
['3m Co',71.72,0.02,0.03,'9/1 12:00am'],
['Alcoa Inc',29.01,0.42,1.47,'9/1 12:00am'],
['Altria Group Inc',83.81,0.28,0.34,'9/1 12:00am'],
['American Express Company',52.55,0.01,0.02,'9/1 12:00am'],
['American International Group, Inc.',64.13,0.31,0.49,'9/1 12:00am'],
['AT&T Inc.',31.61,-0.48,-1.54,'9/1 12:00am'],
['Boeing Co.',75.43,0.53,0.71,'9/1 12:00am'],
['Caterpillar Inc.',67.27,0.92,1.39,'9/1 12:00am'],
['Citigroup, Inc.',49.37,0.02,0.04,'9/1 12:00am'],
['中国银行',49.37,0.02,0.04,'9/1 12:00am']
];
// example of custom renderer function
function change(val){
if(val > 0){
return '<span style="color:green;">' + val + '</span>';
}else if(val < 0){
return '<span style="color:red;">' + val + '</span>';
}
return val;
}
// example of custom renderer function
function pctChange(val){
if(val > 0){
return '<span style="color:green;">' + val + '%</span>';
}else if(val < 0){
return '<span style="color:red;">' + val + '%</span>';
}
return val;
}
// create the data store
var store = new Ext.data.SimpleStore({
fields: [
{name: 'company'},
{name: 'price', type: 'float'},
{name: 'change', type: 'float'},
{name: 'pctChange', type: 'float'},
{name: 'lastChange', type: 'date', dateFormat: 'n/j h:ia'}
]
});
store.loadData(myData);
var linkButton = new Ext.Button({
text: '导出到Excel',
handler: function() {
var vExportContent = grid.getExcelXml();
if (Ext.isIE6 || Ext.isIE7 || Ext.isSafari || Ext.isSafari2 || Ext.isSafari3) {
var fd=Ext.get('frmDummy');
alert(vExportContent);
alert(fd);
if (!fd) {
fd=Ext.DomHelper.append(Ext.getBody(),{tag:'form',method:'post',id:'frmDummy',action:'exportexcel.jsp', 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);
}}
});
// create the Grid
var grid = new Ext.grid.GridPanel({
id: 'static-grid',
store: store,
columns: [
{id:'company',header: "Company", width: 160, sortable: true, dataIndex: 'company'},
{header: "Price", width: 75, sortable: true, renderer: 'usMoney', dataIndex: 'price'},
{header: "Change", width: 75, sortable: true, renderer: change, dataIndex: 'change'},
{header: "% Change", width: 75, sortable: true, renderer: pctChange, dataIndex: 'pctChange'},
{header: "Last Updated", width: 85, sortable: true, renderer: Ext.util.Format.dateRenderer('m/d/Y'), dataIndex: 'lastChange'}
],
stripeRows: true,
autoExpandColumn: 'company',
height:350,
width:600,
title:'EXT Grid 导出',
bbar: new Ext.Toolbar({
buttons: [linkButton]
})
});
grid.render('grid-example');
grid.getSelectionModel().selectFirstRow();
});
</script>
</head>
<body>
<div id="grid-example"></div>
</body>
</html>
分享到:
相关推荐
jsp页面使用ext ajax,导出excel利用poi框架。
Ext_PrinterFriendly.rar是ext打印、js.rar是 jquery打印、temp.rar是ext导出excel
用ext-3.3 开发的导出Excel的完整例子代码
支持Ext3 Ext4导出excel,客户端导出表格,支持各种主流浏览器。
ext导出excel,如需以文件的格式导出,还需做相应的修改。
SpringMVC+ExtJs4.2实例 导入项目链接数据库即可运行 数据库用的是MySql 完全遵循ExtJs4.2的MVC模式来分成
NULL 博文链接:https://damen.iteye.com/blog/946039
可以选择字段导出,也可以排序导出。还可以导出当前页和导出所有的数据。
使用对ExtGrid 的扩展,根据store里的数据生成xml格式的excel文件,然后导出。
Ext解决题目(内存分页+导出Excel) Ext解决题目(内存分页+导出Excel) Ext解决题目(内存分页+导出Excel) Ext解决题目(内存分页+导出Excel)
最近项目要用到的一些aop做的日志管理和ext导出excel技术,自己搜集的。
ext grid 导出excel 代码实例
包括用普通的方法来导出Excel 还有用Ext方式来导出Excel 可以选中行来导出
ext 4.2 grid导出excel 文件 ,包括导出脚本,传输页面,及页面需要连接的按钮代码
EXT grid导出EXCEL,有事例,下载后直接可用
将页面的GridPanel中的数据导出到Excel中 测试Ext:版本2.2.1 支持GridSummary,GroupSummary和GroupHeaderPlugin插件 使用方法: 1)把三个JS文件引入到页面中 2)调用例句: var data2Excel = new Ext.icss.Data2...
Ext完整例子,含jar包,建好表可直接运行,含Ext导出excel
ext导出到excel, 支持最新的Extjs 4.0,4.1,