Your search did not match any results.
DataGrid

Multi-Row Headers (Bands)

Documentation

The DataGrid widget allows you to group column headers logically to implement a banded layout. In this demo, the columns array has a hierarchical structure, although such a layout can be built on a flat-structured array as well. Note that despite being banded, the nested columns remain interactive.

www.wikipedia.org
Copy to Plunker
Apply
Reset
<div class="long-title"> <h3>Countries Population and GDP Structure</h3> </div> <dx-data-grid id="gridContainer" [dataSource]="countries" [columnAutoWidth]="true" [showBorders]="true" [allowColumnReordering]="true"> <dxi-column dataField="Country"> </dxi-column> <dxi-column dataField="Area" headerCellTemplate="headerTemplate"> </dxi-column> <dxi-column caption="Population"> <dxi-column caption="Total" dataField="Population_Total" format="fixedPoint"> </dxi-column> <dxi-column caption="Urban" dataField="Population_Urban" format="percent"> </dxi-column> </dxi-column> <dxi-column caption="Nominal GDP"> <dxi-column caption="Total, mln $" dataField="GDP_Total" format="fixedPoint" sortOrder="desc"> </dxi-column> <dxi-column caption="By Sector"> <dxi-column caption="Agriculture" dataField="GDP_Agriculture"> <dxo-format type="percent" [precision]="1"> </dxo-format> </dxi-column> <dxi-column caption="Industry" dataField="GDP_Industry"> <dxo-format type="percent" [precision]="1"> </dxo-format> </dxi-column> <dxi-column caption="Services" dataField="GDP_Services"> <dxo-format type="percent" [precision]="1"> </dxo-format> </dxi-column> </dxi-column> </dxi-column> <div *dxTemplate="let data of 'headerTemplate'"> <div>Area, km<sup>2</sup></div> </div> </dx-data-grid>
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'; 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(); } } @NgModule({ imports: [ BrowserModule, DxDataGridModule, DxTemplateModule ], declarations: [AppComponent], bootstrap: [AppComponent] }) export class AppModule { } platformBrowserDynamic().bootstrapModule(AppModule);
/deep/ #gridContainer sup { font-size: 0.8em; vertical-align: super; line-height: 0; } /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://github.com/DevExpress/devextreme-angular/blob/master/README.md System.config({ transpiler: 'ts', typescriptOptions: { module: "commonjs", emitDecoratorMetadata: true, experimentalDecorators: true }, meta: { 'typescript': { "exports": "ts" } }, paths: { 'npm:': 'https://unpkg.com/' }, map: { 'ts': 'npm:plugin-typescript@7.0.6/lib/plugin.js', 'typescript': 'npm:typescript@2.2.2/lib/typescript.js', '@angular/core': 'npm:@angular/core@4.1.0/bundles/core.umd.js', '@angular/common': 'npm:@angular/common@4.1.0/bundles/common.umd.js', '@angular/compiler': 'npm:@angular/compiler@4.1.0/bundles/compiler.umd.js', '@angular/platform-browser': 'npm:@angular/platform-browser@4.1.0/bundles/platform-browser.umd.js', '@angular/platform-browser-dynamic': 'npm:@angular/platform-browser-dynamic@4.1.0/bundles/platform-browser-dynamic.umd.js', '@angular/http': 'npm:@angular/http@4.1.0/bundles/http.umd.js', '@angular/router': 'npm:@angular/router@4.1.0/bundles/router.umd.js', '@angular/forms': 'npm:@angular/forms@4.1.0/bundles/forms.umd.js', 'rxjs': 'npm:rxjs@5.3.1', 'devextreme': 'npm:devextreme@17.2', 'jszip': 'npm:jszip@3.1.3/dist/jszip.min.js', 'jquery': 'npm:jquery@3.1.1/dist/jquery.min.js', 'devextreme-angular': 'npm:devextreme-angular@17.2' }, packages: { 'app': { main: './app.component.ts', defaultExtension: 'ts' }, 'devextreme': { defaultExtension: 'js' }, 'devextreme-angular': { main: 'index.js', defaultExtension: 'js' } } });
<!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/17.2.3/css/dx.spa.css" /> <link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/17.2.3/css/dx.common.css" /> <link rel="dx-theme" data-theme="generic.light" href="https://cdn3.devexpress.com/jslib/17.2.3/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.6.25/dist/zone.js"></script> <script src="https://unpkg.com/reflect-metadata@0.1.3/Reflect.js"></script> <script src="https://unpkg.com/systemjs@0.19.31/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>