Page 1 of 1

[ANGULAR] [INFO REQ] [Typescript] > Grid Excel Export > Header Styling and Filtering

Posted: Tue Jan 31, 2023 5:41 pm
by dev team

Hello,

We are attempting to add header styling and filtering to the exported .xlsx.

Looking through the export demo and API documentation, it is not clear if this can be done and if so what configuration is required.

Demo: https://bryntum.com/products/grid/examples/exporttoexcel/
API Docs: https://www.bryntum.com/products/grid/docs/api/Grid/feature/experimental/ExcelExporter

toolbar.push(
          {
            type: 'button',
            text: (window as any).Mpro.LanguageService.translate('page.shared.button.exportBtn'),
            listeners: {
              action: async () => {
                if (this.enableExcelExport) {
                  await this.grid.features.excelExporter.export({
                    filename: this.excelExportFileName,
                    dateFormat: 'DD/MM/YYYY HH:mm:ss',
                  });
                }
              },
              thisObj: this.grid,
            },
          }
        );

Thanks


Re: [ANGULAR] [INFO REQ] [Typescript] > Grid Excel Export > Header Styling and Filtering

Posted: Tue Jan 31, 2023 6:40 pm
by marcio

Hey dev team,

Custom styling with excel exporting is currently not supported. :)


Re: [ANGULAR] [INFO REQ] [Typescript] > Grid Excel Export > Header Styling and Filtering

Posted: Tue Jan 31, 2023 6:48 pm
by dev team

Hello Marcio,

Thank you for the prompt update. Are there any plans to include custom styling in a future release?

Thanks


Re: [ANGULAR] [INFO REQ] [Typescript] > Grid Excel Export > Header Styling and Filtering

Posted: Tue Jan 31, 2023 8:08 pm
by marcio

Hey,

I created a ticket for implementing this, so watch the discussion there for more info regarding the implementation of that feature https://github.com/bryntum/support/issues/6089