Export To CSV error

[Deepak]

When one of the values of a cell is "Department Stores", it errors out. Initially I thought it might be the space, but other values with space work fine. I have a cellformating event handled, but it does not get there. In other words, it errors out before the event fires

Here is the stack trace

System.NullReferenceException: Object reference not set to an instance of an object.

   at Telerik.WinControls.UI.Export.CSV.CellElement.EscapeQuotesInValue()

   at Telerik.WinControls.UI.Export.CSV.CellElement.RenderChildElements(StringBuilder sb)

   at Telerik.WinControls.UI.Export.CSV.ElementBase.Render(StringBuilder sb)

   at Telerik.WinControls.UI.Export.CSV.RowElement.RenderChildElements(StringBuilder sb)

   at Telerik.WinControls.UI.Export.CSV.ElementBase.Render(StringBuilder sb)

   at Telerik.WinControls.UI.Export.ExportToCSV.FileWriteElement(FileStream fileStream, ElementBase csvElement, Int32 cutLastSymbols)

   at Telerik.WinControls.UI.Export.ExportToCSV.AddCSVRow(GridViewRowInfo gridRowInfo, FileStream fileStream, TableElement csvTableElement)

   at Telerik.WinControls.UI.Export.ExportToCSV.RunExport(String fileName)

Thanks
Deepak

[Richard Slade]

Hi Deepak,

I haven't been avble to replicate your error with the latest version. Please can you try the following in a new project.

    public Form1()
    {
        InitializeComponent();
    }
    private void Form1_Load(object sender, EventArgs e)
    {

        this.radGridView1.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
        this.radGridView1.Columns.Add(new GridViewTextBoxColumn("A"));
        this.radGridView1.Columns.Add(new GridViewTextBoxColumn("B"));
        this.radGridView1.Rows.Add("A1", @"""Department Stores""");
        this.radGridView1.Rows.Add("A2", @"""Department Stores""");
    }
    private ExportToCSV exporter;
    private void radButton1_Click(object sender, EventArgs e)
    {
        exporter = new ExportToCSV(radGridView1);
        // replace with your own filepath
        exporter.RunExport(@"C:\Users\Richard\Documents\MyCSV.csv");
    }
}

If this works for you, then please can you post a small sample to replicate the issue.
Thanks
Richard

[Deepak]

Hello Richard,
 Sorry for the late reply. As I found out it had nothing to do with "Department Stores", but along with the data that contained "Department Stores", there was an extra column which was causing this error.

Thanks
Deepak

[Martin Vasilev]

Hello Deepak,

Could you please send us some sample code, which demonstrates your scenario. I am also unable to reproduce the exception on my side and I need additional details to investigate it further.

I look forward to your reply.

All the best,
Martin Vasilev
the Telerik team

[Deepak]

Hello Martin/Richard,
 Sorry if I wasnt clear, I have fixed it by removing the erenous column. I will try to post some sample code...

Thanks
Deepak