SOURCE

console 命令行工具 X clear

                    
>
console
onload = function() {

  // create some random data
  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
    });
  }

  // show the data in a grid
  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
  });
  
  // add a filter to show that it works while exporting
  var f = new wijmo.grid.filter.FlexGridFilter(theGrid);
  
	// export grid to XLSX
  document.getElementById('btnExport').addEventListener('click', function() {

			// create book with current view
      var book = wijmo.grid.xlsx.FlexGridXlsxConverter.save(theGrid, {
      	includeColumnHeaders: true,
        includeRowHeaders: true
			});
      book.sheets[0].name = 'Learn Wijmo';
      
			// save the book
      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;
}