Expense Report Export (Vue)

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 Vue.

app.vue
index.html
data.js
Copy to CodeMine
<template> <div class="container-fluid"> <div class="row"> <button v-on:click="saveExpenses()" class="btn btn-default">Save Report</button> </div> </div> </template> <script setup> import * as wjcXlsx from "@mescius/wijmo.xlsx"; import { getEmployeesWithExpences } from "./data"; import { ref } from "vue"; const employees = ref(getEmployeesWithExpences()); function saveExpenses() { let workbook = _exportExpenseReport(employees.value); 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; } </script>
<template> <div class="container-fluid"> <div class="row"> <button v-on:click="saveExpenses()" class="btn btn-default">Save Report</button> </div> </div> </template> <script setup> import * as wjcXlsx from "@mescius/wijmo.xlsx"; import { getEmployeesWithExpences } from "./data"; import { ref } from "vue"; const employees = ref(getEmployeesWithExpences()); function saveExpenses() { let workbook = _exportExpenseReport(employees.value); 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; } </script>
<!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="compiler.js" type="module"></script> <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.js'); </script> </head> <body> <div id="app"> </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' }, '*.vue': { loader: '../plugin-vue/index.js' } //'*.vue': { loader: 'systemjs-plugin-vue' } }, paths: { // paths serve as alias 'npm:': 'node_modules/' }, // map tells the System loader where to look for things map: { '@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.vue2.chart.analytics": "npm:@mescius/wijmo.vue2.chart.analytics/index.js", "@mescius/wijmo.vue2.chart.animation": "npm:@mescius/wijmo.vue2.chart.animation/index.js", "@mescius/wijmo.vue2.chart.annotation": "npm:@mescius/wijmo.vue2.chart.annotation/index.js", "@mescius/wijmo.vue2.chart.finance.analytics": "npm:@mescius/wijmo.vue2.chart.finance.analytics/index.js", "@mescius/wijmo.vue2.chart.finance": "npm:@mescius/wijmo.vue2.chart.finance/index.js", "@mescius/wijmo.vue2.chart.hierarchical": "npm:@mescius/wijmo.vue2.chart.hierarchical/index.js", "@mescius/wijmo.vue2.chart.interaction": "npm:@mescius/wijmo.vue2.chart.interaction/index.js", "@mescius/wijmo.vue2.chart.radar": "npm:@mescius/wijmo.vue2.chart.radar/index.js", '@mescius/wijmo.vue2.chart.map': 'npm:@mescius/wijmo.vue2.chart.map/index.js', "@mescius/wijmo.vue2.chart": "npm:@mescius/wijmo.vue2.chart/index.js", "@mescius/wijmo.vue2.core": "npm:@mescius/wijmo.vue2.core/index.js", "@mescius/wijmo.vue2.gauge": "npm:@mescius/wijmo.vue2.gauge/index.js", "@mescius/wijmo.vue2.grid.detail": "npm:@mescius/wijmo.vue2.grid.detail/index.js", "@mescius/wijmo.vue2.grid.filter": "npm:@mescius/wijmo.vue2.grid.filter/index.js", "@mescius/wijmo.vue2.grid.grouppanel": "npm:@mescius/wijmo.vue2.grid.grouppanel/index.js", '@mescius/wijmo.vue2.grid.search': 'npm:@mescius/wijmo.vue2.grid.search/index.js', "@mescius/wijmo.vue2.grid.multirow": "npm:@mescius/wijmo.vue2.grid.multirow/index.js", "@mescius/wijmo.vue2.grid.sheet": "npm:@mescius/wijmo.vue2.grid.sheet/index.js", '@mescius/wijmo.vue2.grid.transposed': 'npm:@mescius/wijmo.vue2.grid.transposed/index.js', '@mescius/wijmo.vue2.grid.transposedmultirow': 'npm:@mescius/wijmo.vue2.grid.transposedmultirow/index.js', "@mescius/wijmo.vue2.grid": "npm:@mescius/wijmo.vue2.grid/index.js", "@mescius/wijmo.vue2.input": "npm:@mescius/wijmo.vue2.input/index.js", "@mescius/wijmo.vue2.olap": "npm:@mescius/wijmo.vue2.olap/index.js", "@mescius/wijmo.vue2.viewer": "npm:@mescius/wijmo.vue2.viewer/index.js", "@mescius/wijmo.vue2.nav": "npm:@mescius/wijmo.vue2.nav/index.js", "@mescius/wijmo.vue2.base": "npm:@mescius/wijmo.vue2.base/index.js", '@mescius/wijmo.vue2.barcode.common': 'npm:@mescius/wijmo.vue2.barcode.common/index.js', '@mescius/wijmo.vue2.barcode.composite': 'npm:@mescius/wijmo.vue2.barcode.composite/index.js', '@mescius/wijmo.vue2.barcode.specialized': 'npm:@mescius/wijmo.vue2.barcode.specialized/index.js', 'bootstrap.css': 'npm:bootstrap/dist/css/bootstrap.min.css', 'jszip': 'npm:jszip/dist/jszip.js', 'css': 'npm:systemjs-plugin-css/css.js', 'vue': 'npm:vue/dist/vue.cjs.js', '@vue/compiler-dom':'npm:@vue/compiler-dom/dist/compiler-dom.global.prod.js', '@vue/runtime-dom':'npm:@vue/runtime-dom/dist/runtime-dom.global.prod.js', '@vue/shared':'npm:@vue/shared/dist/shared.cjs.js', '@vue/compiler-dom':'npm:@vue/compiler-dom/dist/compiler-dom.global.prod.js', '@vue/runtime-dom':'npm:@vue/runtime-dom/dist/runtime-dom.global.prod.js', '@vue/shared':'npm:@vue/shared/dist/shared.cjs.js', '@vue/compiler-dom':'npm:@vue/compiler-dom/dist/compiler-dom.global.prod.js', '@vue/runtime-dom':'npm:@vue/runtime-dom/dist/runtime-dom.global.prod.js', '@vue/shared':'npm:@vue/shared/dist/shared.cjs.js', '@vue/compiler-dom':'npm:@vue/compiler-dom/dist/compiler-dom.global.prod.js', '@vue/runtime-dom':'npm:@vue/runtime-dom/dist/runtime-dom.global.prod.js', '@vue/shared':'npm:@vue/shared/dist/shared.cjs.js', '@vue/compiler-dom':'npm:@vue/compiler-dom/dist/compiler-dom.global.prod.js', '@vue/runtime-dom':'npm:@vue/runtime-dom/dist/runtime-dom.global.prod.js', '@vue/shared':'npm:@vue/shared/dist/shared.cjs.js', '@vue/compiler-dom':'npm:@vue/compiler-dom/dist/compiler-dom.global.prod.js', '@vue/runtime-dom':'npm:@vue/runtime-dom/dist/runtime-dom.global.prod.js', '@vue/shared':'npm:@vue/shared/dist/shared.cjs.js', '@vue/compiler-dom':'npm:@vue/compiler-dom/dist/compiler-dom.global.prod.js', '@vue/runtime-dom':'npm:@vue/runtime-dom/dist/runtime-dom.global.prod.js', '@vue/shared':'npm:@vue/shared/dist/shared.cjs.js', '@vue/compiler-dom':'npm:@vue/compiler-dom/dist/compiler-dom.global.prod.js', '@vue/runtime-dom':'npm:@vue/runtime-dom/dist/runtime-dom.global.prod.js', '@vue/shared':'npm:@vue/shared/dist/shared.cjs.js', 'vue-loader': 'npm:systemjs-vue-browser/index.js', //'systemjs-plugin-vue': 'npm:systemjs-plugin-vue/index.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' }, rxjs: { defaultExtension: 'js' }, "node_modules": { defaultExtension: 'js' }, wijmo: { defaultExtension: 'js', } } }); })(this);