[FlexGrid] ヘッダーを含めてコピー
by Wijmo5_jp
HTML
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css">
<script src="https://demo.grapecity.com/wijmo/sample/scripts/sample.js"></script>
<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">
<p>任意のセル範囲を選択してから、<kbd>Ctrl+C</kbd>を押してコピーして、Excelなどのアプリケーションに貼り付けてください。</p>
<label><input type="checkbox" checked onchange="flexGrid.copyHeaders = this.checked ? 'Column' : 'None'">ヘッダーを含めてコピーする</label><br>
<div id="flexGrid"></div>
</div>
CSS
body {
margin: 50px 0;
}
JavaScript
var flexGrid = new wijmo.grid.FlexGrid('#flexGrid', {
copyHeaders: wijmo.grid.HeadersVisibility.Column,
itemsSource: sample.orders(),
columns: [
{ header: 'No', binding: 'No', width: 80 },
{ header: '商品名', binding: '商品名', width: 200 },
{ header: '受注日', binding: '受注日', width: 120 },
{ header: '金額', binding: '金額', format: 'c', width: 100 },
{ header: '値引', binding: '値引', width: 80 }
]
});