console
onload = function() {
var countries = 'US,Germany,UK,Japan,Italy,Greece'.split(',');
var data = [];
for (var i = 0; i < 200; i++) {
data.push({
id: i,
country: countries[i % countries.length],
sales: Math.random() * 10000,
expenses: Math.random() * 5000
});
}
var theGrid = new wijmo.grid.FlexGrid('#theGrid', {
autoGenerateColumns: false,
columns: [
{ binding: 'id', header: 'ID', width: 60 },
{ binding: 'country', header: 'Country', width: '2*'},
{ binding: 'sales', header: 'Sales', width: '*', format: 'n2'},
{ binding: 'expenses', header: 'Expenses', width: '*', format: 'n2'}
],
itemsSource: data
});
var f = new wijmo.grid.filter.FlexGridFilter(theGrid);
document.getElementById('btnExport').addEventListener('click', function() {
var book = wijmo.grid.xlsx.FlexGridXlsxConverter.save(theGrid, {
includeColumnHeaders: true,
includeRowHeaders: true
});
book.sheets[0].name = 'Learn Wijmo';
book.save('LearnWijmo.xlsx');
})
}
<div class="container">
<h1>
导出XLSX
</h1>
<p>
要将FlexGrid控件导出为XLSX格式,您应该在应用程序中包含三个额外的模块:</p>
<ol>
<li>
<b>wijmo.xlsx.js</b>:
提供保存和加载XLSX文件的一般方法.</li>
<li>
<b>wijmo.grid.xlsx.js</b>:
包含使用wijmo.xlsx.js将FlexGrid控件保存为XLSX或将XLSX文件加载到FlexGrid控件的FlexGridXlsxConverter类.</li>
<li><b><a href="https://stuk.github.io/jszip/" target="_blank">jszip.js</a></b>:
用于创建,阅读和编辑ZIP文件的Javascript库.</li>
</ol>
<p>
要将FlexGrid导出到XLSX,请调用FlexGridXlsxConverter.save方法以获取“book”对象。 保存之前,您可以修改书对象,例如添加或重命名表。 一旦“书”准备就绪,请调用其保存方法创建XLSX文件.</p>
<button id="btnExport" class="btn btn-default">
Export to XLSX
</button>
<div id="theGrid"></div>
</div>
.wj-flexgrid {
max-height: 250px;
margin: 12px 0;
}
body {
margin-bottom: 20px;
}