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('c2');
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('c2');
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 = 'For Office Use Only';
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 = 'Expense Report';
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 = 'PURPOSE:';
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 = 'Attachment:';
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 = 'EMPLOYEE IMFORMATION:';
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 = 'Name';
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 = 'Position';
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 = 'SSN';
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 = 'Department';
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 = 'Manager';
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 = 'Employee ID';
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 = 'Date';
rows[9].cells[1].style = tableHeaderStyle;
rows[9].cells[2] = new wjcXlsx.WorkbookCell();
rows[9].cells[2].value = 'Decsription';
rows[9].cells[2].style = tableHeaderStyle;
rows[9].cells[3] = new wjcXlsx.WorkbookCell();
rows[9].cells[3].value = 'Hotel';
rows[9].cells[3].style = tableHeaderStyle;
rows[9].cells[4] = new wjcXlsx.WorkbookCell();
rows[9].cells[4].value = 'Transport';
rows[9].cells[4].style = tableHeaderStyle;
rows[9].cells[5] = new wjcXlsx.WorkbookCell();
rows[9].cells[5].value = 'Fuel';
rows[9].cells[5].style = tableHeaderStyle;
rows[9].cells[6] = new wjcXlsx.WorkbookCell();
rows[9].cells[6].value = 'Meal';
rows[9].cells[6].style = tableHeaderStyle;
rows[9].cells[7] = new wjcXlsx.WorkbookCell();
rows[9].cells[7].value = 'Misc';
rows[9].cells[7].style = tableHeaderStyle;
rows[9].cells[8] = new wjcXlsx.WorkbookCell();
rows[9].cells[8].value = 'Parking (per hour)';
rows[9].cells[8].style = tableHeaderStyle;
rows[9].cells[9] = new wjcXlsx.WorkbookCell();
rows[9].cells[9].value = 'Parking (hours)';
rows[9].cells[9].style = tableHeaderStyle;
rows[9].cells[10] = new wjcXlsx.WorkbookCell();
rows[9].cells[10].value = 'Total';
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 = 'Total';
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 = 'PAY PERIOD:';
rows[2].cells[8].style = accentCaptionStyle;
rows[2].cells[9] = new wjcXlsx.WorkbookCell();
rows[2].cells[9].value = 'From';
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 = 'To';
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 = 'Subtotal';
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('c2');
rows[footerIdx + 1] = new wjcXlsx.WorkbookRow();
rows[footerIdx + 1].cells[9] = new wjcXlsx.WorkbookCell();
rows[footerIdx + 1].cells[9].value = 'Cash Advance';
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('c2');
rows[footerIdx + 2] = new wjcXlsx.WorkbookRow();
rows[footerIdx + 2].cells[9] = new wjcXlsx.WorkbookCell();
rows[footerIdx + 2].cells[9].value = 'Total';
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('c2');
rows[footerIdx + 3] = new wjcXlsx.WorkbookRow();
rows[footerIdx + 3].cells[1] = new wjcXlsx.WorkbookCell();
rows[footerIdx + 3].cells[1].value = 'APPROVED:';
rows[footerIdx + 3].cells[1].style = accentCaptionStyle;
rows[footerIdx + 3].cells[4] = new wjcXlsx.WorkbookCell();
rows[footerIdx + 3].cells[4].value = 'NOTES:';
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">Save Report</button>
</div>
</div>
</body>
</html>
export function getEmployeesWithExpences() {
return [
{
Id: 'E892659',
Name: 'Robert King',
Department: 'Sales',
Position: 'Sales Representative',
SSN: 'A37830',
Manager: 'Andrew Fuller',
Purpose: 'On business',
Attachment: true,
Advance: 1000,
Expenses: _getExpenseItems()
},
{
Id: 'E3667093',
Name: 'John Taylor',
Department: 'Sales',
Position: 'Sales Representative',
SSN: 'A83745',
Manager: 'Andrew Fuller',
Purpose: 'On business',
Attachment: false,
Advance: 800,
Expenses: _getExpenseItems()
},
{
Id: 'E294989',
Name: 'Gregory Allen',
Department: 'Sales',
Position: 'Sales Representative',
SSN: 'A23927',
Manager: 'Andrew Fuller',
Purpose: 'On business',
Attachment: true,
Advance: 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: 'Customer visit',
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);
