<template>
<div>
<DxDataGrid
id="gridContainer"
:data-source="companies"
:show-borders="true"
@exporting="onExporting"
>
<DxGroupPanel :visible="true"/>
<DxGrouping :auto-expand-all="true"/>
<DxSortByGroupSummaryInfo summary-item="count"/>
<DxColumn
data-field="Name"
:width="190"
/>
<DxColumn
data-field="Address"
:width="200"
/>
<DxColumn data-field="City"/>
<DxColumn
data-field="State"
:group-index="0"
/>
<DxColumn
data-field="Phone"
:format="phoneNumberFormat"
/>
<DxColumn
data-field="Website"
caption=""
alignment="center"
:width="100"
cell-template="grid-cell"
/>
<template #grid-cell="{ data }">
<a
:href="data.text"
target="_blank"
>
Website
</a>
</template>
<DxExport
:enabled="true"
/>
<DxSummary>
<DxTotalItem
column="Name"
summary-type="count"
display-format="Total count: {0} companies"
/>
</DxSummary>
</DxDataGrid>
</div>
</template>
<script>
import { DxDataGrid, DxColumn, DxExport, DxSelection, DxSummary, DxGroupPanel, DxGrouping, DxSortByGroupSummaryInfo, DxTotalItem } from 'devextreme-vue/data-grid';
import { exportDataGrid } from 'devextreme/excel_exporter';
import ExcelJS from 'exceljs';
import saveAs from 'file-saver';
/*
// Use this import for codeSandBox
import FileSaver from "file-saver";
*/
import service from './data.js';
export default {
components: {
DxDataGrid, DxColumn, DxExport, DxSelection, DxSummary, DxGroupPanel, DxGrouping, DxSortByGroupSummaryInfo, DxTotalItem
},
data() {
return {
companies: service.getCompanies()
};
},
methods: {
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;
},
phoneNumberFormat(value) {
const USNumber = value.match(/(\d{3})(\d{3})(\d{4})/);
return `(${ USNumber[1] }) ${ USNumber[2] }-${ USNumber[3] }`;
}
}
};
</script>
<style scoped>
#gridContainer {
height: 436px;
}
</style>
import { createApp } from 'vue';
import App from './App.vue';
createApp(App).mount('#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.5/css/dx.common.css" />
<link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/20.2.5/css/dx.light.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>
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: {
'*.vue': {
loader: 'vue-loader'
},
'devextreme/localization.js': {
"esModule": true
},
},
paths: {
'npm:': 'https://unpkg.com/'
},
map: {
'vue': 'npm:vue@3.0.0/dist/vue.esm-browser.js',
'vue-loader': 'npm:dx-systemjs-vue-browser@1.0.15/index.js',
'exceljs': 'npm:exceljs@1.7.0/dist/exceljs.js',
'file-saver': 'npm:file-saver@1.3.8/FileSaver.js',
'mitt': 'npm:mitt/dist/mitt.umd.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.5',
'devextreme-vue': 'npm:devextreme-vue@20.2.5',
'jszip': 'npm:jszip@3.5.0/dist/jszip.min.js',
'devextreme-quill': 'npm:devextreme-quill@0.9.8/dist/dx-quill.min.js',
'devexpress-diagram': 'npm:devexpress-diagram@2.0.11/dist/dx-diagram.js',
'devexpress-gantt': 'npm:devexpress-gantt@2.0.18/dist/dx-gantt.js',
'preact': 'npm:preact@10.5.11/dist/preact.js',
'preact/hooks': 'npm:preact@10.5.11/hooks/dist/hooks.js',
'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-vue': {
main: 'index.js'
},
'devextreme': {
defaultExtension: 'js'
},
'devextreme/events/utils': {
main: 'index'
},
'devextreme/events': {
main: 'index'
},
'es6-object-assign': {
main: './index.js',
defaultExtension: 'js'
}
},
babelOptions: {
sourceMaps: false,
stage0: true
}
});