import React from 'react';
import DataGrid, { Column, Export, Summary, GroupPanel, Grouping, SortByGroupSummaryInfo, TotalItem } from 'devextreme-react/data-grid';
import ExcelJS from 'exceljs';
import saveAs from 'file-saver';
/*
// Use this import for codeSandBox
import FileSaver from 'file-saver';
*/
import { exportDataGrid } from 'devextreme/excel_exporter';
import service from './data.js';
class App extends React.Component {
constructor(props) {
super(props);
this.companies = service.getCompanies();
this.onExporting = this.onExporting.bind(this);
}
render() {
return (
<div>
<DataGrid
id="gridContainer"
dataSource={this.companies}
showBorders={true}
onExporting={this.onExporting}>
<GroupPanel visible={true} />
<Grouping autoExpandAll={true} />
<SortByGroupSummaryInfo summaryItem="count" />
<Column dataField="Name" width={190} />
<Column dataField="Address" width={200} />
<Column dataField="City" />
<Column dataField="State" groupIndex={0} />
<Column dataField="Phone" format={this.phoneNumberFormat} />
<Column dataField="Website" caption="" alignment="center" width={100} cellRender={this.renderGridCell} />
<Export enabled={true} />
<Summary>
<TotalItem
column="Name"
summaryType="count"
displayFormat="Total count: {0} companies"
/>
</Summary>
</DataGrid>
</div>
);
}
renderGridCell(data) {
return <a href={ data.text } target='_blank' rel='noopener noreferrer'>Website</a>;
}
phoneNumberFormat(value) {
const USNumber = value.match(/(\d{3})(\d{3})(\d{4})/);
return `(${ USNumber[1] }) ${ USNumber[2] }-${ USNumber[3] }`;
}
onExporting(e) {
const workbook = new ExcelJS.Workbook();
const worksheet = workbook.addWorksheet('Companies');
worksheet.columns = [
{ width: 5 }, { width: 30 }, { width: 25 }, { width: 15 }, { width: 25 }, { width: 40 }
];
exportDataGrid({
component: e.component,
worksheet: worksheet,
keepColumnWidths: false,
topLeftCell: { row: 2, column: 2 },
customizeCell: ({ gridCell, excelCell }) => {
if(gridCell.rowType === 'data') {
if(gridCell.column.dataField === 'Phone') {
excelCell.value = parseInt(gridCell.value);
excelCell.numFmt = '[<=9999999]###-####;(###) ###-####';
}
if(gridCell.column.dataField === 'Website') {
excelCell.value = { text: gridCell.value, hyperlink: gridCell.value };
excelCell.font = { color: { argb: 'FF0000FF' }, underline: true };
excelCell.alignment = { horizontal: 'left' };
}
}
if(gridCell.rowType === 'group') {
excelCell.fill = { type: 'pattern', pattern:'solid', fgColor: { argb: 'BEDFE6' } };
}
if(gridCell.rowType === 'totalFooter' && excelCell.value) {
excelCell.font.italic = true;
}
}
}).then(() => {
workbook.xlsx.writeBuffer().then((buffer) => {
saveAs(new Blob([buffer], { type: 'application/octet-stream' }), 'Companies.xlsx');
});
});
e.cancel = true;
}
}
export default App;
import React from 'react';
import ReactDOM from 'react-dom';
import App from './App.js';
ReactDOM.render(
<App />,
document.getElementById('app')
);
<!DOCTYPE html>
<html>
<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.2.4/css/dx.common.css" />
<link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/20.2.4/css/dx.light.css" />
<link rel="stylesheet" type="text/css" href="styles.css" />
<script src="https://unpkg.com/core-js@2.4.1/client/shim.min.js"></script>
<script src="https://unpkg.com/systemjs@0.21.3/dist/system.js"></script>
<script type="text/javascript" src="config.js"></script>
<script type="text/javascript">
System.import('./index.js');
</script>
</head>
<body class="dx-viewport">
<div class="demo-container">
<div id="app"></div>
</div>
</body>
</html>
#gridContainer {
height: 436px;
}
const companies = [{
'ID': 1,
'Name': 'Super Mart of the West',
'Address': '702 SW 8th Street',
'City': 'Bentonville',
'State': 'Arkansas',
'Zipcode': 72716,
'Phone': '8005552797',
'Fax': '(800) 555-2171',
'Website': 'http://nowebsitesupermart.com'
}, {
'ID': 2,
'Name': 'Electronics Depot',
'Address': '2455 Paces Ferry Road NW',
'City': 'Atlanta',
'State': 'Georgia',
'Zipcode': 30339,
'Phone': '8005953232',
'Fax': '(800) 595-3231',
'Website': 'http://nowebsitedepot.com'
}, {
'ID': 3,
'Name': 'K&S Music',
'Address': '1000 Nicllet Mall',
'City': 'Minneapolis',
'State': 'Minnesota',
'Zipcode': 55403,
'Phone': '6123046073',
'Fax': '(612) 304-6074',
'Website': 'http://nowebsitemusic.com'
}, {
'ID': 4,
'Name': 'Tom\'s Club',
'Address': '999 Lake Drive',
'City': 'Issaquah',
'State': 'Washington',
'Zipcode': 98027,
'Phone': '8009552292',
'Fax': '(800) 955-2293',
'Website': 'http://nowebsitetomsclub.com'
}, {
'ID': 5,
'Name': 'E-Mart',
'Address': '3333 Beverly Rd',
'City': 'Hoffman Estates',
'State': 'Illinois',
'Zipcode': 60179,
'Phone': '8472862500',
'Fax': '(847) 286-2501',
'Website': 'http://nowebsiteemart.com'
}, {
'ID': 6,
'Name': 'Walters',
'Address': '200 Wilmot Rd',
'City': 'Deerfield',
'State': 'Illinois',
'Zipcode': 60015,
'Phone': '8479402500',
'Fax': '(847) 940-2501',
'Website': 'http://nowebsitewalters.com'
}, {
'ID': 7,
'Name': 'StereoShack',
'Address': '400 Commerce S',
'City': 'Fort Worth',
'State': 'Texas',
'Zipcode': 76102,
'Phone': '8178200741',
'Fax': '(817) 820-0742',
'Website': 'http://nowebsiteshack.com'
}, {
'ID': 8,
'Name': 'Circuit Town',
'Address': '2200 Kensington Court',
'City': 'Oak Brook',
'State': 'Illinois',
'Zipcode': 60523,
'Phone': '8009552929',
'Fax': '(800) 955-9392',
'Website': 'http://nowebsitecircuittown.com'
}, {
'ID': 9,
'Name': 'Premier Buy',
'Address': '7601 Penn Avenue South',
'City': 'Richfield',
'State': 'Minnesota',
'Zipcode': 55423,
'Phone': '6122911000',
'Fax': '(612) 291-2001',
'Website': 'http://nowebsitepremierbuy.com'
}, {
'ID': 10,
'Name': 'ElectrixMax',
'Address': '263 Shuman Blvd',
'City': 'Naperville',
'State': 'Illinois',
'Zipcode': 60563,
'Phone': '6304387800',
'Fax': '(630) 438-7801',
'Website': 'http://nowebsiteelectrixmax.com'
}, {
'ID': 11,
'Name': 'Video Emporium',
'Address': '1201 Elm Street',
'City': 'Dallas',
'State': 'Texas',
'Zipcode': 75270,
'Phone': '2148543000',
'Fax': '(214) 854-3001',
'Website': 'http://nowebsitevideoemporium.com'
}, {
'ID': 12,
'Name': 'Screen Shop',
'Address': '1000 Lowes Blvd',
'City': 'Mooresville',
'State': 'North Carolina',
'Zipcode': 28117,
'Phone': '8004456937',
'Fax': '(800) 445-6938',
'Website': 'http://nowebsitescreenshop.com'
}];
export default {
getCompanies() {
return companies;
}
};
System.config({
transpiler: 'plugin-babel',
meta: {
},
paths: {
'npm:': 'https://unpkg.com/'
},
defaultExtension: 'js',
map: {
'react': 'npm:react@16.14.0/umd/react.development.js',
'react-dom': 'npm:react-dom@16.14.0/umd/react-dom.development.js',
'prop-types': 'npm:prop-types@15.7.2/prop-types.js',
'exceljs': 'npm:exceljs@1.7.0/dist/exceljs.js',
'file-saver': 'npm:file-saver@1.3.8/FileSaver.js',
'rrule': 'npm:rrule@2.6.6/dist/es5/rrule.js',
'luxon': 'npm:luxon@1.25.0/build/global/luxon.min.js',
'es6-object-assign': 'npm:es6-object-assign@1.1.0',
'devextreme': 'npm:devextreme@20.2.4',
'devextreme-react': 'npm:devextreme-react@20.2.4',
'jszip': 'npm:jszip@3.5.0/dist/jszip.min.js',
'devextreme-quill': 'npm:devextreme-quill@0.9.7/dist/dx-quill.min.js',
'devexpress-diagram': 'npm:devexpress-diagram@2.0.5/dist/dx-diagram.js',
'devexpress-gantt': 'npm:devexpress-gantt@2.0.8/dist/dx-gantt.js',
'preact': 'npm:preact@10.5.7/dist/preact.js',
'preact/hooks': 'npm:preact@10.5.7/hooks/dist/hooks.js',
// SystemJS plugins
'plugin-babel': 'npm:systemjs-plugin-babel@0.0.25/plugin-babel.js',
'systemjs-babel-build': 'npm:systemjs-plugin-babel@0.0.25/systemjs-babel-browser.js'
},
packages: {
'devextreme': {
defaultExtension: 'js'
},
'devextreme-react': {
main: 'index.js'
},
'devextreme/events/utils': {
main: 'index'
},
'devextreme/events': {
main: 'index'
},
'es6-object-assign': {
main: './index.js',
defaultExtension: 'js'
}
},
babelOptions: {
sourceMaps: false,
stage0: true,
react: true
}
});