How do I hide/exclude a column during export?

Question

I have a column that shows on the grid. I want to hide it only in export, how do I do this in Syncfusion for Blazor?Thank you

Monisha Saravanan · Answer

Hi Issac,Greetings from Syncfusion support.We have support to export specific columns in DataGrid. We
have documented this topic in our below UG section. Kindly refer the attached
documentation for additional information.Reference: https://blazor.syncfusion.com/documentation/datagrid/excel-exporting#how-to-export-the-grid-with-specific-columnsPlease let us know if you have any concerns.

Ahmed Eldamity · Answer

Hi Monisha Saravanan,I am currently excluding specific columns from the PDF export of a Syncfusion Blazor Grid. However, the current approach requires hiding the columns in the grid during export and then making them visible again, which is not user-friendly due to the visual flicker or refresh.Is there a better way to exclude columns from the export without modifying their visibility in the grid? Ideally, I’d like a solution that allows specific columns to be omitted from the export while keeping them displayed in the grid.Thank you for your assistance!

Naveen Palanivel · Answer

Hi
Ahmed,

We reviewed your query and understand that you want to export only specific
columns to PDF, excluding certain others. Currently, you're facing a flickering
issue during export when hiding a particular column and then showing it again.
To resolve this issue, we recommend using the Columns property of the
PdfExportProperties class. This allows you to export the grid to PDF with only
the desired columns, rather than all columns defined in the Grid configuration.
Please refer to the attached sample and the UG documentation for more
information.

Sample : https://blazorplayground.syncfusion.com/embed/rXLeZaUZyiWKfwoD?appbar=true&editor=true&result=true&errorlist=true&theme=bootstrap5

UG : https://blazor.syncfusion.com/documentation/datagrid/pdf-export-options#customizing-columns-on-export

Regards,
Naveen