How to remove extra string when Exporting to Excel

[Raymond]

I have a very basic code that Export data from a GridView using Visual Basic. The problem I am encountering is the Excel file contains many extra space strings
For example instead '123', it is '123          '

Is there anyway to get rid of these extra strings?

[Stefan]

Hi Raymond,

Thank you for writing.

A suitable event for customizing the value of the exported cells is the ExcelCellFormatting event. Here is an example:

void exporter_ExcelCellFormatting(object sender, Telerik.WinControls.UI.Export.ExcelML.ExcelCellFormattingEventArgs e)
{
    if (e.ExcelCellElement.Data.DataItem is string)
    {
        e.ExcelCellElement.Data.DataItem = e.ExcelCellElement.Data.DataItem.ToString().TrimEnd(' ');
    }
}

I hope this helps.
 
Regards,
Stefan
Telerik