Excel:レポート

この例では、Workbook.saveAsyncメソッドを使用して、従業員の諸経費を含む階層的なデータの配列をExcelのxlsxファイルにエクスポートします。

この配列の内容は従業員データの項目であり、その中の各従業員の項目に、従業員の諸経費を含む子配列が含まれています。このサンプルは、xlsxファイルデータを表示するWorkbookインスタンスを作成します。次に、Workbook.saveAsyncメソッドを呼び出して、それをローカルディスクにxlsxファイルとして保存します。

作成されたワークブックには従業員ごとに個別のシートがあり、シートには従業員の個人データおよび諸経費テーブルが含まれています。

import 'bootstrap.css'; import '@mescius/wijmo.styles/wijmo.css'; import * as wjcXlsx from '@mescius/wijmo.xlsx'; import { getEmployeesWithExpences } from './data'; document.readyState === 'complete' ? init() : window.onload = init; function init() { let data = getEmployeesWithExpences(); document.querySelector('#saveExpense').addEventListener('click', () => { let workbook = _exportExpenseReport(data); workbook.saveAsync('ExpenseReport.xlsx'); }); function _exportExpenseReport(employees) { var book = new wjcXlsx.Workbook(); var dateFormat = wjcXlsx.Workbook.toXlsxDateFormat('d'), stdNumWidth = 85, simpleCaptionStyle = new wjcXlsx.WorkbookStyle(), accentCaptionStyle = new wjcXlsx.WorkbookStyle(), totalCaptionStyle = new wjcXlsx.WorkbookStyle(), valueStyle = new wjcXlsx.WorkbookStyle(), highlightedValueStyle = new wjcXlsx.WorkbookStyle(), tableHeaderStyle = new wjcXlsx.WorkbookStyle(), tableFooterCurrencyStyle = new wjcXlsx.WorkbookStyle(), tableValueStyle = new wjcXlsx.WorkbookStyle(), tableDateStyle = new wjcXlsx.WorkbookStyle(), tableCurrencyStyle = new wjcXlsx.WorkbookStyle(), tableIntegerStyle = new wjcXlsx.WorkbookStyle(); simpleCaptionStyle.hAlign = wjcXlsx.HAlign.Right; accentCaptionStyle.font = new wjcXlsx.WorkbookFont(); accentCaptionStyle.font.color = '#808097'; totalCaptionStyle.basedOn = simpleCaptionStyle; totalCaptionStyle.font = new wjcXlsx.WorkbookFont(); totalCaptionStyle.font.bold = true; totalCaptionStyle.hAlign = wjcXlsx.HAlign.Right; valueStyle.font = new wjcXlsx.WorkbookFont(); valueStyle.font.family = 'Arial'; highlightedValueStyle.basedOn = valueStyle; highlightedValueStyle.fill = new wjcXlsx.WorkbookFill(); highlightedValueStyle.fill.color = '#e1e1e1'; tableHeaderStyle.font = new wjcXlsx.WorkbookFont(); tableHeaderStyle.font.bold = true; tableHeaderStyle.fill = new wjcXlsx.WorkbookFill(); tableHeaderStyle.fill.color = '#fad9cd'; tableFooterCurrencyStyle.basedOn = tableHeaderStyle; tableFooterCurrencyStyle.format = wjcXlsx.Workbook.toXlsxNumberFormat('c0'); tableFooterCurrencyStyle.hAlign = wjcXlsx.HAlign.Right; tableValueStyle.fill = new wjcXlsx.WorkbookFill(); tableValueStyle.fill.color = '#f4b19b'; tableDateStyle.basedOn = tableValueStyle; tableCurrencyStyle.basedOn = tableValueStyle; tableCurrencyStyle.format = wjcXlsx.Workbook.toXlsxNumberFormat('c0'); tableIntegerStyle.basedOn = tableValueStyle; tableIntegerStyle.format = wjcXlsx.Workbook.toXlsxNumberFormat('00'); for (var emplIdx = 0; emplIdx < employees.length; emplIdx++) { var empl = employees[emplIdx], sheet = new wjcXlsx.WorkSheet(), rows = sheet.rows; book.sheets.push(sheet); sheet.name = empl.Name; sheet.columns[0] = new wjcXlsx.WorkbookColumn(); sheet.columns[0].width = '1ch'; sheet.columns[1] = new wjcXlsx.WorkbookColumn(); sheet.columns[1].width = 100; sheet.columns[2] = new wjcXlsx.WorkbookColumn(); sheet.columns[2].width = 200; sheet.columns[3] = new wjcXlsx.WorkbookColumn(); sheet.columns[3].width = stdNumWidth; sheet.columns[4] = new wjcXlsx.WorkbookColumn(); sheet.columns[4].width = stdNumWidth; sheet.columns[6] = new wjcXlsx.WorkbookColumn(); sheet.columns[6].width = stdNumWidth; sheet.columns[7] = new wjcXlsx.WorkbookColumn(); sheet.columns[7].width = stdNumWidth; sheet.columns[8] = new wjcXlsx.WorkbookColumn(); sheet.columns[8].width = 130; sheet.columns[9] = new wjcXlsx.WorkbookColumn(); sheet.columns[9].width = 130; sheet.columns[10] = new wjcXlsx.WorkbookColumn(); sheet.columns[10].width = stdNumWidth; //============= Report header - Employee data ========================= rows[0] = new wjcXlsx.WorkbookRow(); rows[0].cells[8] = new wjcXlsx.WorkbookCell(); rows[0].cells[8].colSpan = 3; rows[0].cells[8].value = '社外秘'; rows[0].cells[8].style = new wjcXlsx.WorkbookStyle(); rows[0].cells[8].style.basedOn = highlightedValueStyle; rows[0].cells[8].style.font = new wjcXlsx.WorkbookFont(); rows[0].cells[8].style.font.italic = true; rows[1] = new wjcXlsx.WorkbookRow(); rows[1].height = 45; rows[1].cells[1] = new wjcXlsx.WorkbookCell(); rows[1].cells[1].value = '経費報告書'; rows[1].cells[1].link = 'A1:B1'; rows[1].cells[1].colSpan = 3; rows[1].cells[1].style = new wjcXlsx.WorkbookStyle(); rows[1].cells[1].style.basedOn = accentCaptionStyle; rows[1].cells[1].style.font = new wjcXlsx.WorkbookFont(); rows[1].cells[1].style.font.size = 32; rows[1].cells[1].style.font.bold = true; rows[2] = new wjcXlsx.WorkbookRow(); rows[2].cells[1] = new wjcXlsx.WorkbookCell(); rows[2].cells[1].value = '目的:'; rows[2].cells[1].style = accentCaptionStyle; rows[2].cells[2] = new wjcXlsx.WorkbookCell(); rows[2].cells[2].value = empl.Purpose; rows[2].cells[5] = new wjcXlsx.WorkbookCell(); rows[2].cells[5].value = '添付:'; rows[2].cells[5].style = accentCaptionStyle; rows[2].cells[6] = new wjcXlsx.WorkbookCell(); rows[2].cells[6].value = empl.Attachment ? 'あり' : 'なし'; rows[5] = new wjcXlsx.WorkbookRow(); rows[5].cells[1] = new wjcXlsx.WorkbookCell(); rows[5].cells[1].value = '社員情報:'; rows[5].cells[1].style = accentCaptionStyle; rows[5].cells[1].colSpan = 2; rows[6] = new wjcXlsx.WorkbookRow(); rows[6].cells[1] = new wjcXlsx.WorkbookCell(); rows[6].cells[1].value = '名前'; rows[6].cells[1].link = 'https://cn.bing.com/'; rows[6].cells[1].style = simpleCaptionStyle; rows[6].cells[2] = new wjcXlsx.WorkbookCell(); rows[6].cells[2].value = empl.Name; rows[6].cells[5] = new wjcXlsx.WorkbookCell(); rows[6].cells[5].value = '職種'; rows[6].cells[5].style = simpleCaptionStyle; rows[6].cells[6] = new wjcXlsx.WorkbookCell(); rows[6].cells[6].value = empl.Position; rows[6].cells[9] = new wjcXlsx.WorkbookCell(); rows[6].cells[9].value = '社会保障番号'; rows[6].cells[9].style = simpleCaptionStyle; rows[6].cells[10] = new wjcXlsx.WorkbookCell(); rows[6].cells[10].value = empl.SSN; rows[7] = new wjcXlsx.WorkbookRow(); rows[7].cells[1] = new wjcXlsx.WorkbookCell(); rows[7].cells[1].value = '部署'; rows[7].cells[1].style = simpleCaptionStyle; rows[7].cells[2] = new wjcXlsx.WorkbookCell(); rows[7].cells[2].value = empl.Department; rows[7].cells[5] = new wjcXlsx.WorkbookCell(); rows[7].cells[5].value = '上司'; rows[7].cells[5].style = simpleCaptionStyle; rows[7].cells[6] = new wjcXlsx.WorkbookCell(); rows[7].cells[6].value = empl.Manager; rows[7].cells[9] = new wjcXlsx.WorkbookCell(); rows[7].cells[9].value = '社員番号'; rows[7].cells[9].style = simpleCaptionStyle; rows[7].cells[10] = new wjcXlsx.WorkbookCell(); rows[7].cells[10].value = empl.Id; //================ Expense items table ========================== // Table header rows[9] = new wjcXlsx.WorkbookRow(); rows[9].style = new wjcXlsx.WorkbookStyle(); rows[9].style.hAlign = wjcXlsx.HAlign.Center; rows[9].cells[1] = new wjcXlsx.WorkbookCell(); rows[9].cells[1].value = '日付'; rows[9].cells[1].style = tableHeaderStyle; rows[9].cells[2] = new wjcXlsx.WorkbookCell(); rows[9].cells[2].value = '詳細'; rows[9].cells[2].style = tableHeaderStyle; rows[9].cells[3] = new wjcXlsx.WorkbookCell(); rows[9].cells[3].value = '宿泊費'; rows[9].cells[3].style = tableHeaderStyle; rows[9].cells[4] = new wjcXlsx.WorkbookCell(); rows[9].cells[4].value = '交通費'; rows[9].cells[4].style = tableHeaderStyle; rows[9].cells[5] = new wjcXlsx.WorkbookCell(); rows[9].cells[5].value = '燃料費'; rows[9].cells[5].style = tableHeaderStyle; rows[9].cells[6] = new wjcXlsx.WorkbookCell(); rows[9].cells[6].value = '食事代'; rows[9].cells[6].style = tableHeaderStyle; rows[9].cells[7] = new wjcXlsx.WorkbookCell(); rows[9].cells[7].value = 'その他'; rows[9].cells[7].style = tableHeaderStyle; rows[9].cells[8] = new wjcXlsx.WorkbookCell(); rows[9].cells[8].value = '駐車料 (時間当たり)'; rows[9].cells[8].style = tableHeaderStyle; rows[9].cells[9] = new wjcXlsx.WorkbookCell(); rows[9].cells[9].value = '駐車料 (時間)'; rows[9].cells[9].style = tableHeaderStyle; rows[9].cells[10] = new wjcXlsx.WorkbookCell(); rows[9].cells[10].value = '合計'; rows[9].cells[10].style = tableHeaderStyle; // Table items var expenses = empl.Expenses, firstIdx = 10, totalIdx = firstIdx + expenses.length; for (var i = 0; i < expenses.length; i++) { var curExpense = expenses[i], rowIdx = firstIdx + i; rows[rowIdx] = new wjcXlsx.WorkbookRow(); rows[rowIdx].cells[1] = new wjcXlsx.WorkbookCell(); rows[rowIdx].cells[1].value = curExpense.Date; rows[rowIdx].cells[1].style = tableDateStyle; rows[rowIdx].cells[2] = new wjcXlsx.WorkbookCell(); rows[rowIdx].cells[2].value = curExpense.Decsription; rows[rowIdx].cells[2].style = tableCurrencyStyle; rows[rowIdx].cells[3] = new wjcXlsx.WorkbookCell(); rows[rowIdx].cells[3].value = curExpense.Hotel; rows[rowIdx].cells[3].style = tableCurrencyStyle; rows[rowIdx].cells[4] = new wjcXlsx.WorkbookCell(); rows[rowIdx].cells[4].value = curExpense.Transport; rows[rowIdx].cells[4].style = tableCurrencyStyle; rows[rowIdx].cells[5] = new wjcXlsx.WorkbookCell(); rows[rowIdx].cells[5].value = curExpense.Fuel; rows[rowIdx].cells[5].style = tableCurrencyStyle; rows[rowIdx].cells[6] = new wjcXlsx.WorkbookCell(); rows[rowIdx].cells[6].value = curExpense.Meal; rows[rowIdx].cells[6].style = tableCurrencyStyle; rows[rowIdx].cells[7] = new wjcXlsx.WorkbookCell(); rows[rowIdx].cells[7].value = curExpense.Misc; rows[rowIdx].cells[7].style = tableCurrencyStyle; rows[rowIdx].cells[8] = new wjcXlsx.WorkbookCell(); rows[rowIdx].cells[8].value = curExpense.ParkingRate; rows[rowIdx].cells[8].style = tableCurrencyStyle; rows[rowIdx].cells[9] = new wjcXlsx.WorkbookCell(); rows[rowIdx].cells[9].value = curExpense.ParkingHours; rows[rowIdx].cells[9].style = tableIntegerStyle; rows[rowIdx].cells[10] = new wjcXlsx.WorkbookCell(); rows[rowIdx].cells[10].formula = 'SUM(' + wjcXlsx.Workbook.xlsxAddress(rowIdx, 3) + ':' + wjcXlsx.Workbook.xlsxAddress(rowIdx, 7) + ')+' + wjcXlsx.Workbook.xlsxAddress(rowIdx, 8) + '*' + wjcXlsx.Workbook.xlsxAddress(rowIdx, 9); rows[rowIdx].cells[10].style = tableCurrencyStyle; } // Totals row var totalColumnIndexes = [3, 4, 5, 6, 7, 10]; rows[totalIdx] = new wjcXlsx.WorkbookRow(); rows[totalIdx].cells[1] = new wjcXlsx.WorkbookCell(); rows[totalIdx].cells[1].value = '合計'; rows[totalIdx].cells[1].style = tableHeaderStyle; for (var ti in totalColumnIndexes) { var ci = totalColumnIndexes[ti]; rows[totalIdx].cells[ci] = new wjcXlsx.WorkbookCell(); rows[totalIdx].cells[ci].formula = 'sum(' + wjcXlsx.Workbook.xlsxAddress(firstIdx, ci) + ':' + wjcXlsx.Workbook.xlsxAddress(totalIdx - 1, ci) + ')'; rows[totalIdx].cells[ci].style = tableFooterCurrencyStyle; } rows[totalIdx].cells[8] = new wjcXlsx.WorkbookCell(); rows[totalIdx].cells[8].formula = 'SUMPRODUCT(' + wjcXlsx.Workbook.xlsxAddress(firstIdx, 7) + ':' + wjcXlsx.Workbook.xlsxAddress(totalIdx - 1, 7) + ',' + wjcXlsx.Workbook.xlsxAddress(firstIdx, 8) + ':' + wjcXlsx.Workbook.xlsxAddress(totalIdx - 1, 8) + ')'; rows[totalIdx].cells[8].colSpan = 2; rows[totalIdx].cells[8].style = tableFooterCurrencyStyle; rows[totalIdx].cells[2] = new wjcXlsx.WorkbookCell(); rows[totalIdx].cells[2].style = tableHeaderStyle; // From/To dates in header, via MAX/MIN formulas on Date field rows[2].cells[8] = new wjcXlsx.WorkbookCell(); rows[2].cells[8].value = '支払期間:'; rows[2].cells[8].style = accentCaptionStyle; rows[2].cells[9] = new wjcXlsx.WorkbookCell(); rows[2].cells[9].value = '開始'; rows[2].cells[9].style = simpleCaptionStyle; var datesRange = wjcXlsx.Workbook.xlsxAddress(firstIdx, 1, true) + ':' + wjcXlsx.Workbook.xlsxAddress(totalIdx - 1, 1, true); rows[2].cells[10] = new wjcXlsx.WorkbookCell(); rows[2].cells[10].formula = 'MIN(' + datesRange + ')'; rows[2].cells[10].style = new wjcXlsx.WorkbookStyle(); rows[2].cells[10].style.format = dateFormat; rows[3] = new wjcXlsx.WorkbookRow(); rows[3].cells[9] = new wjcXlsx.WorkbookCell(); rows[3].cells[9].value = '終了'; rows[3].cells[9].style = simpleCaptionStyle; rows[3].cells[10] = new wjcXlsx.WorkbookCell(); rows[3].cells[10].formula = 'MAX(' + datesRange + ')'; rows[3].cells[10].style = new wjcXlsx.WorkbookStyle(); rows[3].cells[10].style.format = dateFormat; //============ Report footer - totals and misc fields var footerIdx = totalIdx + 1; rows[footerIdx] = new wjcXlsx.WorkbookRow(); rows[footerIdx].cells[9] = new wjcXlsx.WorkbookCell(); rows[footerIdx].cells[9].value = '小計'; rows[footerIdx].cells[9].style = totalCaptionStyle; rows[footerIdx].cells[10] = new wjcXlsx.WorkbookCell(); rows[footerIdx].cells[10].formula = wjcXlsx.Workbook.xlsxAddress(footerIdx + 2, 10) + '-' + wjcXlsx.Workbook.xlsxAddress(footerIdx + 1, 10); rows[footerIdx].cells[10].style = new wjcXlsx.WorkbookStyle(); rows[footerIdx].cells[10].style.format = wjcXlsx.Workbook.toXlsxNumberFormat('c0'); rows[footerIdx + 1] = new wjcXlsx.WorkbookRow(); rows[footerIdx + 1].cells[9] = new wjcXlsx.WorkbookCell(); rows[footerIdx + 1].cells[9].value = '仮払金'; rows[footerIdx + 1].cells[9].style = totalCaptionStyle; rows[footerIdx + 1].cells[10] = new wjcXlsx.WorkbookCell(); rows[footerIdx + 1].cells[10].value = empl.Advance; rows[footerIdx + 1].cells[10].style = new wjcXlsx.WorkbookStyle(); rows[footerIdx + 1].cells[10].style.format = wjcXlsx.Workbook.toXlsxNumberFormat('c0'); rows[footerIdx + 2] = new wjcXlsx.WorkbookRow(); rows[footerIdx + 2].cells[9] = new wjcXlsx.WorkbookCell(); rows[footerIdx + 2].cells[9].value = '合計'; rows[footerIdx + 2].cells[9].style = totalCaptionStyle; rows[footerIdx + 2].cells[10] = new wjcXlsx.WorkbookCell(); rows[footerIdx + 2].cells[10].formula = wjcXlsx.Workbook.xlsxAddress(totalIdx, 10); rows[footerIdx + 2].cells[10].style = new wjcXlsx.WorkbookStyle(); rows[footerIdx + 2].cells[10].style.format = wjcXlsx.Workbook.toXlsxNumberFormat('c0'); rows[footerIdx + 3] = new wjcXlsx.WorkbookRow(); rows[footerIdx + 3].cells[1] = new wjcXlsx.WorkbookCell(); rows[footerIdx + 3].cells[1].value = '承認:'; rows[footerIdx + 3].cells[1].style = accentCaptionStyle; rows[footerIdx + 3].cells[4] = new wjcXlsx.WorkbookCell(); rows[footerIdx + 3].cells[4].value = '補足:'; rows[footerIdx + 3].cells[4].style = accentCaptionStyle; } return book; } }
<!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <title>MESCIUS Wijmo Expense Report Export</title> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <!-- SystemJS --> <script src="https://cdnjs.cloudflare.com/ajax/libs/systemjs/0.21.5/system.src.js" integrity="sha512-skZbMyvYdNoZfLmiGn5ii6KmklM82rYX2uWctBhzaXPxJgiv4XBwJnFGr5k8s+6tE1pcR1nuTKghozJHyzMcoA==" crossorigin="anonymous"></script> <script src="systemjs.config.js"></script> <script> System.import('./src/app'); </script> </head> <body> <div class="container-fluid"> <!-- the flex grid --> <div class="row"> <button id="saveExpense" class="btn btn-default">レポートの保存</button> </div> </div> </body> </html>
export function getEmployeesWithExpences() { return [ { Id: 'E892659', Name: '正門 恵子', Department: '営業部', Position: '販売員', SSN: 'A37830', Manager: '森上 偉久馬', Purpose: '商用', Attachment: true, Advance: 100 * 1000, Expenses: _getExpenseItems() }, { Id: 'E3667093', Name: '木下 和明', Department: '営業部', Position: '販売員', SSN: 'A83745', Manager: '森上 偉久馬', Purpose: '商用', Attachment: false, Advance: 100 * 800, Expenses: _getExpenseItems() }, { Id: 'E294989', Name: '田中 秀樹', Department: '営業部', Position: '販売員', SSN: 'A23927', Manager: '森上 偉久馬', Purpose: '商用', Attachment: true, Advance: 100 * 1200, Expenses: _getExpenseItems() }, ]; } function _getExpenseItems() { let count = 5 + Math.round(Math.random() * 5), ret = [], msPerDay = 1000 * 24 * 60 * 60, curDate = Date.now() - 60 * msPerDay; for (let i = 0; i < count; i++) { ret.push({ Date: new Date(curDate), Decsription: '顧客訪問', Hotel: 30 + Math.random() * 200, Transport: 10 + Math.random() * 150, Fuel: Math.random() * 50, Meal: 30 + Math.random() * 170, ParkingRate: 3.75, ParkingHours: 8 + Math.round(Math.random() * 16), Misc: Math.random() * 220 }); curDate += msPerDay * Math.round(Math.random() * 4); } return ret; }
(function (global) { System.config({ transpiler: 'plugin-babel', babelOptions: { es2015: true }, meta: { '*.css': { loader: 'css' } }, paths: { // paths serve as alias 'npm:': 'node_modules/' }, // map tells the System loader where to look for things map: { 'jszip': 'npm:jszip/dist/jszip.js', '@mescius/wijmo': 'npm:@mescius/wijmo/index.js', '@mescius/wijmo.input': 'npm:@mescius/wijmo.input/index.js', '@mescius/wijmo.styles': 'npm:@mescius/wijmo.styles', '@mescius/wijmo.cultures': 'npm:@mescius/wijmo.cultures', '@mescius/wijmo.chart': 'npm:@mescius/wijmo.chart/index.js', '@mescius/wijmo.chart.analytics': 'npm:@mescius/wijmo.chart.analytics/index.js', '@mescius/wijmo.chart.animation': 'npm:@mescius/wijmo.chart.animation/index.js', '@mescius/wijmo.chart.annotation': 'npm:@mescius/wijmo.chart.annotation/index.js', '@mescius/wijmo.chart.finance': 'npm:@mescius/wijmo.chart.finance/index.js', '@mescius/wijmo.chart.finance.analytics': 'npm:@mescius/wijmo.chart.finance.analytics/index.js', '@mescius/wijmo.chart.hierarchical': 'npm:@mescius/wijmo.chart.hierarchical/index.js', '@mescius/wijmo.chart.interaction': 'npm:@mescius/wijmo.chart.interaction/index.js', '@mescius/wijmo.chart.radar': 'npm:@mescius/wijmo.chart.radar/index.js', '@mescius/wijmo.chart.render': 'npm:@mescius/wijmo.chart.render/index.js', '@mescius/wijmo.chart.webgl': 'npm:@mescius/wijmo.chart.webgl/index.js', '@mescius/wijmo.chart.map': 'npm:@mescius/wijmo.chart.map/index.js', '@mescius/wijmo.gauge': 'npm:@mescius/wijmo.gauge/index.js', '@mescius/wijmo.grid': 'npm:@mescius/wijmo.grid/index.js', '@mescius/wijmo.grid.detail': 'npm:@mescius/wijmo.grid.detail/index.js', '@mescius/wijmo.grid.filter': 'npm:@mescius/wijmo.grid.filter/index.js', '@mescius/wijmo.grid.search': 'npm:@mescius/wijmo.grid.search/index.js', '@mescius/wijmo.grid.grouppanel': 'npm:@mescius/wijmo.grid.grouppanel/index.js', '@mescius/wijmo.grid.multirow': 'npm:@mescius/wijmo.grid.multirow/index.js', '@mescius/wijmo.grid.transposed': 'npm:@mescius/wijmo.grid.transposed/index.js', '@mescius/wijmo.grid.transposedmultirow': 'npm:@mescius/wijmo.grid.transposedmultirow/index.js', '@mescius/wijmo.grid.pdf': 'npm:@mescius/wijmo.grid.pdf/index.js', '@mescius/wijmo.grid.sheet': 'npm:@mescius/wijmo.grid.sheet/index.js', '@mescius/wijmo.grid.xlsx': 'npm:@mescius/wijmo.grid.xlsx/index.js', '@mescius/wijmo.grid.selector': 'npm:@mescius/wijmo.grid.selector/index.js', '@mescius/wijmo.grid.cellmaker': 'npm:@mescius/wijmo.grid.cellmaker/index.js', '@mescius/wijmo.nav': 'npm:@mescius/wijmo.nav/index.js', '@mescius/wijmo.odata': 'npm:@mescius/wijmo.odata/index.js', '@mescius/wijmo.olap': 'npm:@mescius/wijmo.olap/index.js', '@mescius/wijmo.rest': 'npm:@mescius/wijmo.rest/index.js', '@mescius/wijmo.pdf': 'npm:@mescius/wijmo.pdf/index.js', '@mescius/wijmo.pdf.security': 'npm:@mescius/wijmo.pdf.security/index.js', '@mescius/wijmo.viewer': 'npm:@mescius/wijmo.viewer/index.js', '@mescius/wijmo.xlsx': 'npm:@mescius/wijmo.xlsx/index.js', '@mescius/wijmo.undo': 'npm:@mescius/wijmo.undo/index.js', '@mescius/wijmo.interop.grid': 'npm:@mescius/wijmo.interop.grid/index.js', '@mescius/wijmo.touch': 'npm:@mescius/wijmo.touch/index.js', '@mescius/wijmo.cloud': 'npm:@mescius/wijmo.cloud/index.js', '@mescius/wijmo.barcode': 'npm:@mescius/wijmo.barcode/index.js', '@mescius/wijmo.barcode.common': 'npm:@mescius/wijmo.barcode.common/index.js', '@mescius/wijmo.barcode.composite': 'npm:@mescius/wijmo.barcode.composite/index.js', '@mescius/wijmo.barcode.specialized': 'npm:@mescius/wijmo.barcode.specialized/index.js', 'jszip': 'npm:jszip/dist/jszip.js', 'bootstrap.css': 'npm:bootstrap/dist/css/bootstrap.min.css', 'css': 'npm:systemjs-plugin-css/css.js', 'plugin-babel': 'npm:systemjs-plugin-babel/plugin-babel.js', 'systemjs-babel-build':'npm:systemjs-plugin-babel/systemjs-babel-browser.js' }, // packages tells the System loader how to load when no filename and/or no extension packages: { src: { defaultExtension: 'js' }, "node_modules": { defaultExtension: 'js' }, } }); })(this);