/* * Copyright (C) 2022 Huawei Device Co., Ltd. * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ const htmlStr = () => { const html_start = ``; return { uri : 'data:application/vnd.ms-excel;base64,', template_ExcelWorksheet : `{SheetName}`, template_ListWorksheet : ``, template_WorkBook : `MIME-Version: 1.0 X-Document-Type: Workbook Content-Type: multipart/related; boundary="----=_NextPart_dummy" ------=_NextPart_dummy Content-Location: WorkBook.htm Content-Type: text/html; charset=windows-1252 ` + html_start + ` <body><p>This page uses frames, but your browser does not support them.</p></body> {HTMLWorksheets} Content-Location: filelist.xml Content-Type: text/xml; charset="utf-8" {ListWorksheets} ------=_NextPart_dummy-- ` } } export class ExcelFormater { static tmplCellXML = '{data}'; static base64 = function (s: any) { return window.btoa(unescape(encodeURIComponent(s))); }; static format(s: any, c: any): string { return s.replace(/{(\w+)}/g, function (m: any, p: any) { return c[p]; }); } static createExcelRow(columns: any[], data: any): string { let rowsXML = ''; rowsXML += ''; for (let k = 0; k < columns.length; k++) { let dataIndex = columns[k].getAttribute('data-index'); let columnName = columns[k].getAttribute('title'); if (columnName == '') { columnName = dataIndex; } let ctx = { attributeStyleID: '', nameType: 'String', data: data ? data[dataIndex] || '' : columnName, attributeFormula: '', }; rowsXML += this.format(this.tmplCellXML, ctx); } rowsXML += ''; if (data && data.children != undefined && data.children.length > 0) { data.children.forEach((child: any) => { rowsXML += this.createExcelRow(columns, child); }); } return rowsXML; } static addImage(baseStr: string) { return `${this.format(this.tmplCellXML, { attributeStyleID: '', nameType: 'String', data: `

`, attributeFormula: '', })}`; } static testExport(dataSource: { columns: any[]; tables: any[]; sheetName: string }[], fileName: string) { this.tablesToHtmlExcelMultipleSheet(dataSource, fileName); } static tablesToHtmlExcelMultipleSheet( dataSource: { columns: any[]; tables: any[]; sheetName: string }[], fileName: string, image?: string ) { let sheets: any[] = []; dataSource.forEach((data) => { sheets.push(this.createTableData(data.columns, data.tables, image)); }); this.tablesToExcelTestSheet(sheets, fileName, dataSource); } static createTableData(columns: any[], dataSource: any[], image?: string) { let tableData = ''; let columnDatas = columns.map((column) => { let dataIndex = column.getAttribute('data-index'); let columnName = column.getAttribute('title'); if (columnName == '') { columnName = dataIndex; } return { columnName: columnName, dataIndex: dataIndex, }; }); tableData += this.createTHead( columnDatas.map((item) => { return item.columnName; }) ); let columnDataIndexes = columnDatas.map((item) => item.dataIndex); dataSource.forEach((data, index) => { if (index == 0 && image) { tableData += this.createTableRow(columnDataIndexes, data, image); } else { tableData += this.createTableRow(columnDataIndexes, data); } }); return tableData; } static createTHead(columns: any[]) { let header = ''; columns.forEach((column) => { header += `${column}`; }); header += ''; return header; } static createTableRow(columns: any[], data: any, image?: any) { let childrenData = ''; if (data.children !== undefined) { data.children.forEach((child: any) => { if (child) { childrenData += this.createTableRow(columns, child); } }); } return `${columns .map((column) => { return `${(data[column] + '').replace('μ', 'u')}` || ''; }) .join('')}${image ? `

` : ''}${childrenData}`; } static tablesToExcelTestSheet( tables: any[], filename: string, dataSource: { columns: any[]; tables: any[]; sheetName: string }[] ) { const html_start = ``; let {uri,template_ExcelWorksheet,template_ListWorksheet,template_WorkBook} = htmlStr(); let template_HTMLWorksheet = ` ------=_NextPart_dummy Content-Location: sheet{SheetIndex}.htm Content-Type: text/html; charset=windows-1252 ` + html_start + ` {SheetContent}

`; let context_WorkBook = { ExcelWorksheets: '', HTMLWorksheets: '', ListWorksheets: '', }; tables.forEach((item, sheetIndex) => { context_WorkBook.ExcelWorksheets += this.format(template_ExcelWorksheet, { SheetIndex: sheetIndex, SheetName: dataSource[sheetIndex].sheetName, }); context_WorkBook.HTMLWorksheets += this.format(template_HTMLWorksheet, { SheetIndex: sheetIndex, SheetContent: item, }); context_WorkBook.ListWorksheets += this.format(template_ListWorksheet, { SheetIndex: sheetIndex, }); }); let link = document.createElement('a'); link.href = uri + this.base64(this.format(template_WorkBook, context_WorkBook)); link.download = filename + '.xls'; link.target = '_blank'; link.click(); } }