1.MiniUI官网的前端导出excel
前端界面:
<body>
<div style="width: 100%;">
<div class="mini-toolbar" style="border-bottom:0;padding:0;">
<table style="width:100%;">
<tr>
<td style="width:100%;">
<a class="mini-button" onclick="search()">查询</a>
<a class="mini-button" onclick="exportExcel()">导出</a>
</td>
</tr>
</table>
</div>
</div>
<div id="datagrid1" class="mini-datagrid" style="width: 100%; height: 600px" idField="id"
allowResize="true" pageSize="20" allowCellSelect="true" url="../findAll"
>
<div property="columns">
<div type="indexcolumn" width="100" align="center"></div>
<div field="name" headerAlign="center" width="100" align="center">姓名</div>
<div field="age" headerAlign="center" width="100" align="center">年龄</div>
<div field="remarks" width="100" headerAlign="center" align="center">备注</div>
<div field="gender" width="100" headerAlign="center" align="center">性别</div>
<div field="country" width="100" headerAlign="center" align="center">国家</div>
</div>
</div>
</body>
<script type="text/javascript">
mini.parse();
var datagrid1 = mini.get("datagrid1");
function search() {
datagrid1.load();
}
function exportExcel() {
var columns = datagrid1.columns;
function getColumns(columns) {
var cols = [];
for (var i = 0; i < columns.length; i++) {
var column = columns[i];
var col = {
header: column.header, field: column.field, type: column.type };
if (column.columns) {
col.columns = getColumns(column.columns);
}
cols.push(col);
}
return cols;
}
var columns = getColumns(columns);
DownLoad("../download", {
type: "excel", columns: columns, data:datagrid1.getData()});
}
function DownLoad(url, fields) {
//创建Form
var submitfrm = document.