Posted 5 May 2026, 3:32 am EST - Updated 5 May 2026, 3:37 am EST
Hi Team,
We have a grid structured as shown in the image, and we want to export it to Excel. Below is the code we’re currently using for the export:
public export() {
wjcGridXlsx.FlexGridXlsxConverter.saveAsync(
this.groupAccessGrid,
{
includeColumnHeaders: true,
includeCellStyles: true,
formatItem: this.exportFormatItem
},
“permissions”
);
}
private exportFormatItem(args: wjcGridXlsx.XlsxFormatItemEventArgs) {
const row = args.panel.rows[args.row];
const col = args.panel.columns[args.col];
const item = row.dataItem;
if (row instanceof wjGrid.GroupRow || !item) {
if (col.binding == ‘permission’ && item) {
args.xlsxCell.textRuns[1].font.bold = true;
args.xlsxCell.textRuns[1].font.size = 16;
args.xlsxCell.textRuns[1].text = item.name;
}
return;
}
if (col.binding == ‘permission’) {
args.xlsxCell.value = item.translatedPermission;
}
if (this.stateService.addedRolesOrAcg.includes(col.binding)) {
const key =
${col.binding}|||${item.module}|||${item.permission}args.xlsxCell.value = item[key];
args.xlsxCell.style = { hAlign: 2 };
}
}
The issue we’re facing is that we want checkboxes to appear in the exported Excel file, just like they are displayed in the grid—including in the grouped row headers.
Please find the screenshot as below
/ ☐ or 
/ 
), or
