Expense Report Export (Angular)

This example exports a hierarchical array of data, containing employees' expenses, to an Excel xlsx file using the Workbook.saveAsync method.

The array contains items with employee data, wherein each employee item contains a child array with employee's expenses. The sample creates a Workbook instance representation of the xlsx file data. Then invoke the Workbook.saveAsync method to save it as an xlsx file on the local disk.

The created workbook contains a separate sheet for each employee, with employee's personal data and expenses table.

This example uses Angular.

import 'bootstrap.css'; import '@mescius/wijmo.styles/wijmo.css'; import '@angular/compiler'; import { Component, enableProdMode, Inject, ɵresolveComponentResources } from '@angular/core'; import { BrowserModule, bootstrapApplication } from '@angular/platform-browser'; import { FormsModule } from '@angular/forms'; import * as wjcXlsx from '@mescius/wijmo.xlsx'; import { DataService } from './app.data'; @Component({ standalone: true, providers: [DataService], imports: [BrowserModule, FormsModule], selector: 'app-component', templateUrl: 'src/app.component.html' }) export class AppComponent { private _data: any[]; constructor(@Inject(DataService) dataSvc: DataService) { this._data = dataSvc.getEmployeesWithExpences(); } saveExpenses() { let workbook = this._exportExpenseReport(this._data); workbook.saveAsync('ExpenseReport.xlsx'); } private _exportExpenseReport(employees: any[]): wjcXlsx.Workbook { 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 = <any[]>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; } } enableProdMode(); // Resolve resources (templateUrl, styleUrls etc), After resolution all URLs have been converted into `template` strings. ɵresolveComponentResources(fetch).then(() => { // Bootstrap application bootstrapApplication(AppComponent).catch(err => console.error(err)); });
<!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"> <!-- Polyfills --> <script src="node_modules/core-js/client/shim.min.js"></script> <script src="node_modules/zone.js/fesm2015/zone.min.js"></script> <!-- 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> // workaround to load 'rxjs/operators' from the rxjs bundle System.import('rxjs').then(function (m) { System.set(SystemJS.resolveSync('rxjs/operators'), System.newModule(m.operators)); System.import('./src/app.component'); }); </script> </head> <body> <app-component></app-component> </body> </html>
<div class="container-fluid"> <div class="row"> <button (click)="saveExpenses()" class="btn btn-default">Save Report</button> </div> </div>
import { Injectable } from '@angular/core'; @Injectable() export class DataService { 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: this._getExpenseItems() }, { Id: 'E3667093', Name: 'John Taylor', Department: 'Sales', Position: 'Sales Representative', SSN: 'A83745', Manager: 'Andrew Fuller', Purpose: 'On business', Attachment: false, Advance: 800, Expenses: this._getExpenseItems() }, { Id: 'E294989', Name: 'Gregory Allen', Department: 'Sales', Position: 'Sales Representative', SSN: 'A23927', Manager: 'Andrew Fuller', Purpose: 'On business', Attachment: true, Advance: 1200, Expenses: this._getExpenseItems() }, ]; } private _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) { SystemJS.config({ transpiler: './plugin-typescript.js', typescriptOptions: { "target": "ES2022", "module": "system", "emitDecoratorMetadata": true, "experimentalDecorators": true, }, baseURL: 'node_modules/', meta: { 'typescript': { "exports": "ts" }, '*.css': { loader: 'systemjs-plugin-css' } }, paths: { // paths serve as alias 'npm:': '' }, packageConfigPaths: [ '/node_modules/*/package.json', "/node_modules/@angular/*/package.json", "/node_modules/@mescius/*/package.json" ], map: { 'core-js': 'https://cdn.jsdelivr.net/npm/core-js@2.6.12/client/shim.min.js', 'typescript': 'https://cdnjs.cloudflare.com/ajax/libs/typescript/5.2.2/typescript.min.js', "rxjs": "https://cdnjs.cloudflare.com/ajax/libs/rxjs/7.8.1/rxjs.umd.min.js", 'systemjs-plugin-css': 'https://cdn.jsdelivr.net/npm/systemjs-plugin-css@0.1.37/css.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', "@mescius/wijmo.angular2.chart.analytics": "npm:@mescius/wijmo.angular2.chart.analytics/index.js", "@mescius/wijmo.angular2.chart.animation": "npm:@mescius/wijmo.angular2.chart.animation/index.js", "@mescius/wijmo.angular2.chart.annotation": "npm:@mescius/wijmo.angular2.chart.annotation/index.js", "@mescius/wijmo.angular2.chart.finance.analytics": "npm:@mescius/wijmo.angular2.chart.finance.analytics/index.js", "@mescius/wijmo.angular2.chart.finance": "npm:@mescius/wijmo.angular2.chart.finance/index.js", "@mescius/wijmo.angular2.chart.hierarchical": "npm:@mescius/wijmo.angular2.chart.hierarchical/index.js", "@mescius/wijmo.angular2.chart.interaction": "npm:@mescius/wijmo.angular2.chart.interaction/index.js", "@mescius/wijmo.angular2.chart.radar": "npm:@mescius/wijmo.angular2.chart.radar/index.js", '@mescius/wijmo.angular2.chart.map': 'npm:@mescius/wijmo.angular2.chart.map/index.js', "@mescius/wijmo.angular2.chart": "npm:@mescius/wijmo.angular2.chart/index.js", "@mescius/wijmo.angular2.core": "npm:@mescius/wijmo.angular2.core/index.js", "@mescius/wijmo.angular2.gauge": "npm:@mescius/wijmo.angular2.gauge/index.js", "@mescius/wijmo.angular2.grid.detail": "npm:@mescius/wijmo.angular2.grid.detail/index.js", "@mescius/wijmo.angular2.grid.filter": "npm:@mescius/wijmo.angular2.grid.filter/index.js", "@mescius/wijmo.angular2.grid.grouppanel": "npm:@mescius/wijmo.angular2.grid.grouppanel/index.js", "@mescius/wijmo.angular2.grid.search": "npm:@mescius/wijmo.angular2.grid.search/index.js", "@mescius/wijmo.angular2.grid.multirow": "npm:@mescius/wijmo.angular2.grid.multirow/index.js", "@mescius/wijmo.angular2.grid.sheet": "npm:@mescius/wijmo.angular2.grid.sheet/index.js", '@mescius/wijmo.angular2.grid.transposed': 'npm:@mescius/wijmo.angular2.grid.transposed/index.js', '@mescius/wijmo.angular2.grid.transposedmultirow': 'npm:@mescius/wijmo.angular2.grid.transposedmultirow/index.js', "@mescius/wijmo.angular2.grid": "npm:@mescius/wijmo.angular2.grid/index.js", "@mescius/wijmo.angular2.input": "npm:@mescius/wijmo.angular2.input/index.js", "@mescius/wijmo.angular2.olap": "npm:@mescius/wijmo.angular2.olap/index.js", "@mescius/wijmo.angular2.viewer": "npm:@mescius/wijmo.angular2.viewer/index.js", "@mescius/wijmo.angular2.nav": "npm:@mescius/wijmo.angular2.nav/index.js", "@mescius/wijmo.angular2.directivebase": "npm:@mescius/wijmo.angular2.directivebase/index.js", '@mescius/wijmo.angular2.barcode.common': 'npm:@mescius/wijmo.angular2.barcode.common/index.js', '@mescius/wijmo.angular2.barcode.composite': 'npm:@mescius/wijmo.angular2.barcode.composite/index.js', '@mescius/wijmo.angular2.barcode.specialized': 'npm:@mescius/wijmo.angular2.barcode.specialized/index.js', 'bootstrap.css': 'npm:bootstrap/dist/css/bootstrap.min.css', 'jszip': 'https://cdnjs.cloudflare.com/ajax/libs/jszip/3.10.1/jszip.min.js', "@angular/common/http": "https://cdn.jsdelivr.net/npm/@angular/common@16.2.6/fesm2022/http.mjs", "@angular/core": "https://cdn.jsdelivr.net/npm/@angular/core@16.2.6/fesm2022/core.mjs", "@angular/platform-browser": "https://cdn.jsdelivr.net/npm/@angular/platform-browser@16.2.6/fesm2022/platform-browser.mjs", "@angular/common": "https://cdn.jsdelivr.net/npm/@angular/common@16.2.6/fesm2022/common.mjs", "@angular/compiler": "https://cdn.jsdelivr.net/npm/@angular/compiler@16.2.6/fesm2022/compiler.mjs", "@angular/forms": "https://cdn.jsdelivr.net/npm/@angular/forms@16.2.6/fesm2022/forms.mjs", "@angular/localize": "https://cdn.jsdelivr.net/npm/@angular/localize@16.2.6/fesm2022/localize.mjs", "@angular/platform-browser-dynamic": "https://cdn.jsdelivr.net/npm/@angular/platform-browser-dynamic@16.2.6/fesm2022/platform-browser-dynamic.mjs", }, // packages tells the System loader how to load when no filename and/or no extension packages: { "./src": { defaultExtension: 'ts' }, "node_modules": { defaultExtension: 'js' }, wijmo: { defaultExtension: 'js', } } }); })(this);