Remove Columns from Excel Export

[Michael Gotfredsen]

Hi,

I'm trying to remove columns from the excel import using exportsettings.Mappings.Remove or RemoveAt, but it seems to be ignoring the command. I can add mappings without issue.

Is there any documentation on this?

Thanks

Michael 

[Dilli Babu Nandha Gopal]

Hi Michael,

Thank you for contacting Syncfusion support.

We are unable to reproduce the reported issue from our side. You can remove the column in the grid while exporting to excel by using Remove() or RemoveAt() methods of Mapping property in ExcelExportOptions, which is illustrated in below code example.

Code example:

ExcelExportOptions exportSettings = new ExcelExportOptions();

exportSettings.Row = 3;

exportSettings.Column = 2;

exportSettings.Mappings = columnMappings;

// Removes the Column Mapping in the collection

exportSettings.Mappings.Remove(exportSettings.Mappings[2]);

// Removes the Column Mapping at specified index in the collection

exportSettings.Mappings.RemoveAt(2);

using (stream)

{

    ExcelBuilder.Export(this.Books, exportSettings, stream);
}

We have shared the sample for your reference which can be downloaded from following link.
Sample link: http://www.syncfusion.com/downloads/support/forum/120760/ze/BookStoreApplication_20131039436365.zip

Kindly try this sample and let us know whether the issue is resolved. If issue exists then please share us the issue reproducing sample to provide the prompt solution at the earliest.

Regards,
Dilli babu.