Header and Footer

import { NgModule, Component, enableProdMode } from '@angular/core'; import { BrowserModule } from '@angular/platform-browser'; import { platformBrowserDynamic } from '@angular/platform-browser-dynamic'; import { DxDataGridModule, DxTemplateModule } from 'devextreme-angular'; import { Service, Country } from './app.service'; import { exportDataGrid } from 'devextreme/excel_exporter'; import ExcelJS from 'exceljs'; import saveAs from 'file-saver'; /* // Use this import for codeSandBox import * as ExcelJS from "exceljs/dist/exceljs.min.js"; import * as FileSaver from "file-saver"; */ if(!/localhost/.test(document.location.host)) { enableProdMode(); } @Component({ selector: 'demo-app', templateUrl: 'app/app.component.html', styleUrls: ['app/app.component.css'], providers: [Service] }) export class AppComponent { countries: Country[]; constructor(service: Service) { this.countries = service.getCountries(); } onExporting(e) { const workbook = new ExcelJS.Workbook(); const worksheet = workbook.addWorksheet('CountriesPopulation'); exportDataGrid({ component: e.component, worksheet: worksheet, topLeftCell: { row: 4, column: 1 } }).then(function(dataGridRange) { // header // https://github.com/exceljs/exceljs#rows const headerRow = worksheet.getRow(2); headerRow.height = 30; // https://github.com/exceljs/exceljs#merged-cells worksheet.mergeCells(2, 1, 2, 8); // https://github.com/exceljs/exceljs#value-types headerRow.getCell(1).value = 'Country Area, Population, and GDP Structure'; // https://github.com/exceljs/exceljs#fonts headerRow.getCell(1).font = { name: 'Segoe UI Light', size: 22 }; // https://github.com/exceljs/exceljs#alignment headerRow.getCell(1).alignment = { horizontal: 'center' }; // footer const footerRowIndex = dataGridRange.to.row + 2; const footerRow = worksheet.getRow(footerRowIndex); worksheet.mergeCells(footerRowIndex, 1, footerRowIndex, 8); footerRow.getCell(1).value = 'www.wikipedia.org'; footerRow.getCell(1).font = { color: { argb: 'BFBFBF' }, italic: true }; footerRow.getCell(1).alignment = { horizontal: 'right' }; }).then(function() { // https://github.com/exceljs/exceljs#writing-xlsx workbook.xlsx.writeBuffer().then(function(buffer) { saveAs(new Blob([buffer], { type: 'application/octet-stream' }), 'CountriesPopulation.xlsx'); }); }); e.cancel = true; } } @NgModule({ imports: [ BrowserModule, DxDataGridModule, DxTemplateModule ], declarations: [AppComponent], bootstrap: [AppComponent] }) export class AppModule { } platformBrowserDynamic().bootstrapModule(AppModule);

::ng-deep #gridContainer sup { font-size: 0.8em; vertical-align: super; line-height: 0; } ::ng-deep .long-title h3 { font-family: 'Segoe UI Light', 'Helvetica Neue Light', 'Segoe UI', 'Helvetica Neue', 'Trebuchet MS', Verdana; font-weight: 200; font-size: 28px; text-align: center; margin-bottom: 20px; }

import { Injectable } from '@angular/core'; export class Country { ID: number; Country: string; Area: number; Population_Urban: number; Population_Rural: number; Population_Total: number; GDP_Agriculture: number; GDP_Industry: number; GDP_Services: number; GDP_Total: number; } let countries: Country[] = [{ "ID": 1, "Country": "Brazil", "Area": 8515767, "Population_Urban": 0.85, "Population_Rural": 0.15, "Population_Total": 205809000, "GDP_Agriculture": 0.054, "GDP_Industry": 0.274, "GDP_Services": 0.672, "GDP_Total": 2353025 }, { "ID": 2, "Country": "China", "Area": 9388211, "Population_Urban": 0.54, "Population_Rural": 0.46, "Population_Total": 1375530000, "GDP_Agriculture": 0.091, "GDP_Industry": 0.426, "GDP_Services": 0.483, "GDP_Total": 10380380 }, { "ID": 3, "Country": "France", "Area": 675417, "Population_Urban": 0.79, "Population_Rural": 0.21, "Population_Total": 64529000, "GDP_Agriculture": 0.019, "GDP_Industry": 0.183, "GDP_Services": 0.798, "GDP_Total": 2846889 }, { "ID": 4, "Country": "Germany", "Area": 357021, "Population_Urban": 0.75, "Population_Rural": 0.25, "Population_Total": 81459000, "GDP_Agriculture": 0.008, "GDP_Industry": 0.281, "GDP_Services": 0.711, "GDP_Total": 3859547 }, { "ID": 5, "Country": "India", "Area": 3287590, "Population_Urban": 0.32, "Population_Rural": 0.68, "Population_Total": 1286260000, "GDP_Agriculture": 0.174, "GDP_Industry": 0.258, "GDP_Services": 0.569, "GDP_Total": 2047811 }, { "ID": 6, "Country": "Italy", "Area": 301230, "Population_Urban": 0.69, "Population_Rural": 0.31, "Population_Total": 60676361, "GDP_Agriculture": 0.02, "GDP_Industry": 0.242, "GDP_Services": 0.738, "GDP_Total": 2147952 }, { "ID": 7, "Country": "Japan", "Area": 377835, "Population_Urban": 0.93, "Population_Rural": 0.07, "Population_Total": 126920000, "GDP_Agriculture": 0.012, "GDP_Industry": 0.275, "GDP_Services": 0.714, "GDP_Total": 4616335 }, { "ID": 8, "Country": "Russia", "Area": 17098242, "Population_Urban": 0.74, "Population_Rural": 0.26, "Population_Total": 146544710, "GDP_Agriculture": 0.039, "GDP_Industry": 0.36, "GDP_Services": 0.601, "GDP_Total": 1857461 }, { "ID": 9, "Country": "United States", "Area": 9147420, "Population_Urban": 0.81, "Population_Rural": 0.19, "Population_Total": 323097000, "GDP_Agriculture": 0.0112, "GDP_Industry": 0.191, "GDP_Services": 0.797, "GDP_Total": 17418925 }, { "ID": 10, "Country": "United Kingdom", "Area": 244820, "Population_Urban": 0.82, "Population_Rural": 0.18, "Population_Total": 65097000, "GDP_Agriculture": 0.007, "GDP_Industry": 0.21, "GDP_Services": 0.783, "GDP_Total": 2945146 }]; @Injectable() export class Service { getCountries(): Country[] { return countries; } }

// In real applications, you should not transpile code in the browser. You can see how to create your own application with Angular and DevExtreme here: // https://js.devexpress.com/Documentation/Guide/Angular_Components/Getting_Started/Create_a_DevExtreme_Application/ System.config({ transpiler: 'ts', typescriptOptions: { module: "system", emitDecoratorMetadata: true, experimentalDecorators: true }, meta: { 'typescript': { "exports": "ts" }, }, paths: { 'npm:': 'https://unpkg.com/' }, map: { 'ts': 'npm:plugin-typescript@8.0.0/lib/plugin.js', 'typescript': 'npm:typescript@3.4.5/lib/typescript.js', '@angular': 'npm:@angular', 'tslib': 'npm:tslib/tslib.js', 'rxjs': 'npm:rxjs', 'exceljs': 'npm:exceljs@1.7.0/dist/exceljs.js', 'file-saver': 'npm:file-saver@1.3.8/FileSaver.js', 'devextreme': 'npm:devextreme@20.1', 'jszip': 'npm:jszip@3.1.3/dist/jszip.min.js', 'quill': 'npm:quill@1.3.7/dist/quill.js', 'devexpress-diagram': 'npm:devexpress-diagram@1.0.17', 'devexpress-gantt': 'npm:devexpress-gantt@1.0.10', 'devextreme-angular': 'npm:devextreme-angular@20.1' }, packages: { 'app': { main: './app.component.ts', defaultExtension: 'ts' }, 'devextreme': { defaultExtension: 'js' }, 'devextreme/events/utils': { main: 'index' }, 'devextreme/events': { main: 'index' }, }, packageConfigPaths: [ "npm:*/package.json", "npm:@angular/*/package.json", "npm:@angular/common/*/package.json", "npm:rxjs/operators/package.json", "npm:devextreme-angular@20.1/*/package.json", "npm:devextreme-angular@20.1/ui/*/package.json", ] });

<!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>DevExtreme Demo</title> <meta http-equiv="X-UA-Compatible" content="IE=edge" /> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0" /> <link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/20.1.8/css/dx.common.css" /> <link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/20.1.8/css/dx.light.css" /> <script src="https://unpkg.com/core-js@2.4.1/client/shim.min.js"></script> <script src="https://unpkg.com/zone.js@0.10.2/dist/zone.js"></script> <script src="https://unpkg.com/reflect-metadata@0.1.3/Reflect.js"></script> <script src="https://unpkg.com/systemjs@0.21.3/dist/system.js"></script> <script src="config.js"></script> <script> System.import('app').catch(console.error.bind(console)); </script> </head> <body class="dx-viewport"> <div class="demo-container"> <demo-app>Loading...</demo-app> </div> </body> </html>