How can I prevent the transmission of invisible columns

[Eren]

Hi

how can I prevent the transmission of invisible columns to excel or pdf ?

[Adhikesevan Kothandaraman]

Hi Eren,  

 

Thanks for contacting Syncfusion support.  

 

The hidden columns of the SfDataGrid can be restricted while exporting by adding the column to the ExcludeColumns property of the ExcelExportingOptions and PdfExportingOptions.  

Please refer to the following code example and UG link for further reference,  

 

Excel Exporting  

ExcelExportingOptions GridExcelExportingOptions = new ExcelExportingOptions();  

List<string> hiddenColumns = new List<string>();  

foreach (var column in sfDataGrid1.Columns)  

{  

    if (!column.Visible)  

        hiddenColumns.Add(column.MappingName);  

}  

GridExcelExportingOptions.ExcludeColumns = hiddenColumns;  

  

var excelEngine = sfDataGrid1.ExportToExcel(sfDataGrid1.View, GridExcelExportingOptions);  

var workBook = excelEngine.Excel.Workbooks[0];  

workBook.SaveAs("Sample.xlsx");  

  

Pdf Exporting  

PdfExportingOptions pdfExportingOption = new PdfExportingOptions();  

List<string> hiddenColumns = new List<string>();  

foreach (var column in sfDataGrid.Columns)  

{  

    if (!column.Visible)  

        hiddenColumns.Add(column.MappingName);  

}  

  

pdfExportingOption.ExcludeColumns = hiddenColumns;  

  

var document = sfDataGrid.ExportToPdf(sfDataGrid.SelectedItems, pdfExportingOption);            document.Save("Sample.pdf");  

  

  

UG Link:  

https://help.syncfusion.com/windowsforms/sfdatagrid/exporttoexcel#exclude-columns-while-exporting   

https://help.syncfusion.com/windowsforms/sfdatagrid/exporttopdf#exclude-columns-while-exporting   

 

Sample Link:   

http://www.syncfusion.com/downloads/support/forum/137982/ze/Exporting1978541417   

  

Regards,  

Adhi  

[Eren]

Thank you this help me a lot

[Amal Raj U]

Hi Eren, 

Thanks for your update. 

We are glad to know, that the provided solution resolved your queries. Please let us know, if you need any further assistance on this. 

Regards, 

Amal Raj U.