Expense Report Export (Angular)

Theme:

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));
});

Feedback

Submit and view feedback for

This Product This Page

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' },
'*.mjs': {
format: 'esm'
},
},
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.style': 'npm:@mescius/wijmo.grid.style/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/core': 'npm:@angular/core/fesm2022/core.mjs',
'@angular/core/primitives/signals': 'npm:@angular/core/fesm2022/primitives/signals.mjs',
'@angular/core/primitives/event-dispatch': 'npm:@angular/core/fesm2022/primitives/event-dispatch.mjs',
'@angular/common': 'npm:@angular/common/fesm2022/common.mjs',
'@angular/common/http': 'npm:@angular/common/fesm2022/http.mjs',
'@angular/compiler': 'npm:@angular/compiler/fesm2022/compiler.mjs',
'@angular/platform-browser': 'npm:@angular/platform-browser/fesm2022/platform-browser.mjs',
'@angular/platform-browser-dynamic': 'npm:@angular/platform-browser-dynamic/fesm2022/platform-browser-dynamic.mjs',
'@angular/http': 'npm:@angular/http/fesm2022/http.mjs',
'@angular/router': 'npm:@angular/router/fesm2022/router.mjs',
'@angular/forms': 'npm:@angular/forms/fesm2022/forms.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);