import 'bootstrap.css';
import '@mescius/wijmo.styles/wijmo.css';
import ReactDOM from 'react-dom/client';
import React from 'react';
import * as wjcXlsx from '@mescius/wijmo.xlsx';
import { getEmployeesWithExpences } from './data';
function App() {
const data = getEmployeesWithExpences();
const exportExpenseReport = (employees) => {
const book = new wjcXlsx.Workbook();
const dateFormat = wjcXlsx.Workbook.toXlsxDateFormat('d');
const stdNumWidth = 85;
const simpleCaptionStyle = new wjcXlsx.WorkbookStyle();
simpleCaptionStyle.hAlign = wjcXlsx.HAlign.Right;
const accentCaptionStyle = new wjcXlsx.WorkbookStyle();
accentCaptionStyle.font = new wjcXlsx.WorkbookFont();
accentCaptionStyle.font.color = '#808097';
const totalCaptionStyle = new wjcXlsx.WorkbookStyle();
totalCaptionStyle.basedOn = simpleCaptionStyle;
totalCaptionStyle.font = new wjcXlsx.WorkbookFont();
totalCaptionStyle.font.bold = true;
totalCaptionStyle.hAlign = wjcXlsx.HAlign.Right;
const valueStyle = new wjcXlsx.WorkbookStyle();
valueStyle.font = new wjcXlsx.WorkbookFont();
valueStyle.font.family = 'Arial';
const highlightedValueStyle = new wjcXlsx.WorkbookStyle();
highlightedValueStyle.basedOn = valueStyle;
highlightedValueStyle.fill = new wjcXlsx.WorkbookFill();
highlightedValueStyle.fill.color = '#e1e1e1';
const tableHeaderStyle = new wjcXlsx.WorkbookStyle();
tableHeaderStyle.font = new wjcXlsx.WorkbookFont();
tableHeaderStyle.font.bold = true;
tableHeaderStyle.fill = new wjcXlsx.WorkbookFill();
tableHeaderStyle.fill.color = '#fad9cd';
const tableFooterCurrencyStyle = new wjcXlsx.WorkbookStyle();
tableFooterCurrencyStyle.basedOn = tableHeaderStyle;
tableFooterCurrencyStyle.format = wjcXlsx.Workbook.toXlsxNumberFormat('c2');
tableFooterCurrencyStyle.hAlign = wjcXlsx.HAlign.Right;
const tableValueStyle = new wjcXlsx.WorkbookStyle();
tableValueStyle.fill = new wjcXlsx.WorkbookFill();
tableValueStyle.fill.color = '#f4b19b';
const tableDateStyle = new wjcXlsx.WorkbookStyle();
tableDateStyle.basedOn = tableValueStyle;
const tableCurrencyStyle = new wjcXlsx.WorkbookStyle();
tableCurrencyStyle.basedOn = tableValueStyle;
tableCurrencyStyle.format = wjcXlsx.Workbook.toXlsxNumberFormat('c2');
const tableIntegerStyle = new wjcXlsx.WorkbookStyle();
tableIntegerStyle.basedOn = tableValueStyle;
tableIntegerStyle.format = wjcXlsx.Workbook.toXlsxNumberFormat('00');
for (var emplIdx = 0; emplIdx < employees.length; emplIdx++) {
const empl = employees[emplIdx];
const sheet = new wjcXlsx.WorkSheet();
const 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;
};
const handleSaveReportClick = () => {
const workbook = exportExpenseReport(data);
workbook.saveAsync('ExpenseReport.xlsx');
};
return (<div className="container-fluid">
<div className="row">
<button className="btn btn-default" onClick={handleSaveReportClick}>Save Report</button>
</div>
</div>);
}
const container = document.getElementById('app');
if (container) {
const root = ReactDOM.createRoot(container);
root.render(<App />);
}
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title>MESCIUS Wijmo 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.19.40/system.src.js" integrity="sha512-G6mEj6h18+m3MvzdviSDfPle/TfH0//cXcB33AKlNR/Rha0yQsKefDZKRTkIZos97HEGq2JMV1RT5ybMoQ3WsQ==" crossorigin="anonymous"></script>
<script src="systemjs.config.js"></script>
<script>
System.import('./src/app');
</script>
</head>
<body>
<div id="app"></div>
</body>
</html>
function generateExpenseItems() {
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;
}
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: generateExpenseItems()
},
{
Id: 'E3667093',
Name: 'John Taylor',
Department: 'Sales',
Position: 'Sales Representative',
SSN: 'A83745',
Manager: 'Andrew Fuller',
Purpose: 'On business',
Attachment: false,
Advance: 800,
Expenses: generateExpenseItems()
},
{
Id: 'E294989',
Name: 'Gregory Allen',
Department: 'Sales',
Position: 'Sales Representative',
SSN: 'A23927',
Manager: 'Andrew Fuller',
Purpose: 'On business',
Attachment: true,
Advance: 1200,
Expenses: generateExpenseItems()
},
];
}
(function (global) {
System.config({
transpiler: 'plugin-babel',
babelOptions: {
es2015: true,
react: 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.grid.immutable': 'npm:@mescius/wijmo.grid.immutable/index.js',
'@mescius/wijmo.touch': 'npm:@mescius/wijmo.touch/index.js',
'@mescius/wijmo.cloud': 'npm:@mescius/wijmo.cloud/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.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',
"@mescius/wijmo.react.chart.analytics": "npm:@mescius/wijmo.react.chart.analytics/index.js",
"@mescius/wijmo.react.chart.animation": "npm:@mescius/wijmo.react.chart.animation/index.js",
"@mescius/wijmo.react.chart.annotation": "npm:@mescius/wijmo.react.chart.annotation/index.js",
"@mescius/wijmo.react.chart.finance.analytics": "npm:@mescius/wijmo.react.chart.finance.analytics/index.js",
"@mescius/wijmo.react.chart.finance": "npm:@mescius/wijmo.react.chart.finance/index.js",
"@mescius/wijmo.react.chart.hierarchical": "npm:@mescius/wijmo.react.chart.hierarchical/index.js",
"@mescius/wijmo.react.chart.interaction": "npm:@mescius/wijmo.react.chart.interaction/index.js",
"@mescius/wijmo.react.chart.radar": "npm:@mescius/wijmo.react.chart.radar/index.js",
"@mescius/wijmo.react.chart": "npm:@mescius/wijmo.react.chart/index.js",
"@mescius/wijmo.react.core": "npm:@mescius/wijmo.react.core/index.js",
'@mescius/wijmo.react.chart.map': 'npm:@mescius/wijmo.react.chart.map/index.js',
"@mescius/wijmo.react.gauge": "npm:@mescius/wijmo.react.gauge/index.js",
"@mescius/wijmo.react.grid.detail": "npm:@mescius/wijmo.react.grid.detail/index.js",
"@mescius/wijmo.react.grid.filter": "npm:@mescius/wijmo.react.grid.filter/index.js",
"@mescius/wijmo.react.grid.grouppanel": "npm:@mescius/wijmo.react.grid.grouppanel/index.js",
'@mescius/wijmo.react.grid.search': 'npm:@mescius/wijmo.react.grid.search/index.js',
"@mescius/wijmo.react.grid.multirow": "npm:@mescius/wijmo.react.grid.multirow/index.js",
"@mescius/wijmo.react.grid.sheet": "npm:@mescius/wijmo.react.grid.sheet/index.js",
'@mescius/wijmo.react.grid.transposed': 'npm:@mescius/wijmo.react.grid.transposed/index.js',
'@mescius/wijmo.react.grid.transposedmultirow': 'npm:@mescius/wijmo.react.grid.transposedmultirow/index.js',
'@mescius/wijmo.react.grid.immutable': 'npm:@mescius/wijmo.react.grid.immutable/index.js',
"@mescius/wijmo.react.grid": "npm:@mescius/wijmo.react.grid/index.js",
"@mescius/wijmo.react.input": "npm:@mescius/wijmo.react.input/index.js",
"@mescius/wijmo.react.olap": "npm:@mescius/wijmo.react.olap/index.js",
"@mescius/wijmo.react.viewer": "npm:@mescius/wijmo.react.viewer/index.js",
"@mescius/wijmo.react.nav": "npm:@mescius/wijmo.react.nav/index.js",
"@mescius/wijmo.react.base": "npm:@mescius/wijmo.react.base/index.js",
'@mescius/wijmo.react.barcode.common': 'npm:@mescius/wijmo.react.barcode.common/index.js',
'@mescius/wijmo.react.barcode.composite': 'npm:@mescius/wijmo.react.barcode.composite/index.js',
'@mescius/wijmo.react.barcode.specialized': 'npm:@mescius/wijmo.react.barcode.specialized/index.js',
'jszip': 'npm:jszip/dist/jszip.js',
'react': 'npm:react/umd/react.production.min.js',
'react-dom': 'npm:react-dom/umd/react-dom.production.min.js',
'react-dom/client': 'npm:react-dom/umd/react-dom.production.min.js',
'redux': 'npm:redux/dist/redux.min.js',
'react-redux': 'npm:react-redux/dist/react-redux.min.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',
"react-use-event-hook": "npm:react-use-event-hook/dist/esm/useEvent.js",
},
// packages tells the System loader how to load when no filename and/or no extension
packages: {
src: {
defaultExtension: 'jsx'
},
"node_modules": {
defaultExtension: 'js'
},
}
});
})(this);
