Wijmo FlexGrid saveFileメソッドの改善

by Wijmo5_jp

HTML

<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css">
<link rel="stylesheet" href="https://cdn.grapecity.com/wijmo/5.latest/styles/wijmo.min.css">
<script src="https://cdn.grapecity.com/wijmo/5.latest/controls/wijmo.min.js"></script>
<script src="https://cdn.grapecity.com/wijmo/5.latest/controls/cultures/wijmo.culture.ja.min.js"></script>
<script src="https://cdn.grapecity.com/wijmo/5.latest/controls/wijmo.grid.min.js"></script>
<div class="container-fluid">
  <p>100,000行のデータをCSVファイル（約5.5MB）に保存します。</p>
  <div id="flexGrid" class="grid"></div>
  <button id="exportButton" class="btn btn-default">保存</button>
</div>

CSS

body {
  margin: 50px 0;
}
.grid {
    height: 150px;
    width: 100%;
}

JavaScript

document.readyState === 'complete' ? init() : window.onload = init;
function init() {
  var flexGrid = new wijmo.grid.FlexGrid('#flexGrid', {
    itemsSource: data,
    columns: [
      { binding: 'No', width: 80 },
      { binding: '商品名', width: 200 },
      { binding: '受注日', width: 120 },
      { binding: '金額', format: 'c', width: 100 },
      { binding: '値引', width: 80 }
    ]
  });

  document.querySelector('#exportButton').addEventListener('click', function(){
    var options = wijmo.grid.ClipStringOptions.CSV
    var range =new wijmo.grid.CellRange(0, 0, flexGrid.rows.length - 1, flexGrid.columns.length - 1);
    var csv = flexGrid.getClipString(range, options, false, false);
    wijmo.saveFile(csv, 'FlexGrid.csv', 'text/csv');
  })
}

var productNames = ['果汁100%オレンジ', '果汁100%グレープ', '果汁100%レモン', '果汁100%ピーチ', 'コーヒーマイルド', 'コーヒービター', 'コーヒーミルク', 'ピリピリビール', 'オタル白ラベル', 'バードワイン'];
function random(max, min) {
  if (!min) min = 0;
  return Math.floor(Math.random() * (max - min)) + min;
}
function randomDate(years) {
  if (!years) years = 5;
  let date = new Date((new Date()).getFullYear() - years, 3, 1);
  return wijmo.DateTime.addDays(date, random(365 * years));
}
function getData(length) {
  if (!length) length = 5;
  let data = [];
  for (let i = 0; i < length; i++) {
    data.push({
      No: i,
      商品名: productNames[random(productNames.length)],
      受注日: randomDate(),
      金額: random(99) * 100,
      値引: random(3) == 0
    });
  }
  return data;
}
var data = getData(100000);