Pull down to refresh...
Release to refresh...
Refreshing...
-
Data Grid
- Overview
-
Data Binding
-
Paging and Scrolling
-
Editing
-
Grouping
-
Filtering and Sorting
- Focused Row
-
Row Drag & Drop
-
Selection
-
Columns
- State Persistence
-
Appearance
-
Templates
-
Data Summaries
-
Master-Detail
-
Export to PDF
-
Export to Excel
-
Adaptability
- Keyboard Navigation
-
Pivot Grid
- Overview
-
Data Binding
-
Field Chooser
-
Features
-
Export to Excel
-
Tree List
- Overview
-
Data Binding
- Sorting
- Paging
-
Editing
- Node Drag & Drop
- Focused Row
-
Selection
-
Filtering
-
Column Customization
- State Persistence
- Adaptability
- Keyboard Navigation
-
Scheduler
- Overview
-
Data Binding
-
Views
-
Features
- Virtual Scrolling
-
Grouping
-
Customization
- Adaptability
-
Html Editor
-
Chat
-
Diagram
- Overview
-
Data Binding
-
Featured Shapes
-
Custom Shapes
-
Document Capabilities
-
User Interaction
- UI Customization
- Adaptability
-
Charts
- Overview
-
Data Binding
-
Area Charts
-
Bar Charts
- Bullet Charts
-
Doughnut Charts
-
Financial Charts
-
Line Charts
-
Pie Charts
-
Point Charts
-
Polar and Radar Charts
-
Range Charts
-
Sparkline Charts
-
Tree Map
-
Funnel and Pyramid Charts
- Sankey Chart
-
Combinations
-
More Features
-
Export
-
Selection
-
Tooltips
-
Zooming
-
-
Gantt
- Overview
-
Data
-
UI Customization
- Strip Lines
- Export to PDF
- Sorting
-
Filtering
-
Gauges
- Overview
-
Data Binding
-
Bar Gauge
-
Circular Gauge
-
Linear Gauge
-
Navigation
- Overview
- Accordion
-
Menu
- Multi View
-
Drawer
-
Tab Panel
-
Tabs
-
Toolbar
- Pagination
-
Tree View
- Right-to-Left Support
-
Layout
-
Tile View
- Splitter
-
Gallery
- Scroll View
- Box
- Responsive Box
- Resizable
-
-
Editors
- Overview
- Autocomplete
-
Calendar
- Check Box
- Color Box
-
Date Box
-
Date Range Box
-
Drop Down Box
-
Number Box
-
Select Box
- Switch
-
Tag Box
- Text Area
- Text Box
- Validation
- Custom Text Editor Buttons
- Right-to-Left Support
- Editor Appearance Variants
-
Forms and Multi-Purpose
- Overview
- Button Group
- Field Set
-
Filter Builder
-
Form
- Radio Group
-
Range Selector
- Numeric Scale (Lightweight)
- Numeric Scale
- Date-Time Scale (Lightweight)
- Date-Time Scale
- Logarithmic Scale
- Discrete scale
- Custom Formatting
- Use Range Selection for Calculation
- Use Range Selection for Filtering
- Image on Background
- Chart on Background
- Customized Chart on Background
- Chart on Background with Series Template
- Range Slider
- Slider
-
Sortable
-
File Management
-
File Manager
- Overview
-
File System Types
-
Customization
-
File Uploader
-
-
Actions and Lists
- Overview
-
Action Sheet
-
Button
- Floating Action Button
- Drop Down Button
-
Context Menu
-
List
-
Lookup
-
Maps
- Overview
-
Map
-
Vector Map
-
Dialogs and Notifications
-
Localization
Related Demos:
Your search did not match any results.
Loading...
React Data Grid - Header and Footer
ExcelJS library allows you to customize worksheets outside the exported cell area. This demo uses this functionality to add a header (a title before exported data) and a footer (a note after exported data).
Review the onExporting handler to see the data export code. The functions that create header and footer sections utilize the following customization features:
- Merged cells
- Cell values formatting
- Font properties
- Text alignment
www.wikipedia.org
Was this demo helpful?
Feel free to share demo-related thoughts here.
If you have technical questions, please create a support ticket in the DevExpress Support Center.
Thank you for the feedback!
If you have technical questions, please create a support ticket in the DevExpress Support Center.
Backend API
x
import React from 'react';
import DataGrid, { Column, DataGridTypes, Export } from 'devextreme-react/data-grid';
import { Workbook } from 'exceljs';
import { saveAs } from 'file-saver-es';
import { exportDataGrid } from 'devextreme/excel_exporter';
import { countries } from './data.ts';
const gdpFormat = {
type: 'percent',
precision: 1,
};
const onExporting = (e: DataGridTypes.ExportingEvent) => {
const workbook = new Workbook();
const worksheet = workbook.addWorksheet('CountriesPopulation');
exportDataGrid({
component: e.component,
worksheet,
topLeftCell: { row: 4, column: 1 },
}).then((cellRange) => {
// header
const headerRow = worksheet.getRow(2);
headerRow.height = 30;
worksheet.mergeCells(2, 1, 2, 8);
headerRow.getCell(1).value = 'Country Area, Population, and GDP Structure';
headerRow.getCell(1).font = { name: 'Segoe UI Light', size: 22 };
headerRow.getCell(1).alignment = { horizontal: 'center' };
// footer
const footerRowIndex = cellRange.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' };
workbook.xlsx.writeBuffer().then((buffer) => {
saveAs(new Blob([buffer], { type: 'application/octet-stream' }), 'CountriesPopulation.xlsx');
});
});
};
const App = () => (
<DataGrid
dataSource={countries}
keyExpr="ID"
showBorders={true}
onExporting={onExporting}
>
<Export enabled={true} />
<Column dataField="Country" />
<Column dataField="Area" />
<Column caption="Population">
<Column
dataField="Population_Total"
caption="Total"
format="fixedPoint"
/>
<Column
dataField="Population_Urban"
caption="Urban"
format="percent"
/>
</Column>
<Column caption="Nominal GDP">
<Column
dataField="GDP_Total"
caption="Total, mln $"
format="fixedPoint"
sortOrder="desc"
/>
<Column caption="By Sector">
<Column
dataField="GDP_Agriculture"
caption="Agriculture"
format={gdpFormat}
width={95}
/>
<Column
dataField="GDP_Industry"
caption="Industry"
format={gdpFormat}
width={80}
/>
<Column
dataField="GDP_Services"
caption="Services"
format={gdpFormat}
width={85}
/>
</Column>
</Column>
</DataGrid>
);
export default App;
xxxxxxxxxx
xxxxxxxxxx
xxxxxxxxxx
xxxxxxxxxx
xxxxxxxxxx
xxxxxxxxxx
xxxxxxxxxx
xxxxxxxxxx