[Solved] Column limit for exporting to CSV or Word?

[Ed]

Is there an upper limit on how many columns a table may have for it to be successfully exported to CSV or Word format?  I am hitting a bug when my table has 240 columns and I'm trying to export to CSV: this seems like a suspiciously round number but it may be coincidence.  I also hit errors when exporting to Word with far fewer columns, although I am modifying the ExportOutput property quite extensively (to add styling etc.) in this case, so I have presumed the error was a result of my modifications.

[Kostadin]

Hi Ed,

Know that when a large amounts of data is exported you might encounter an exception (Timeout or OutOfMemory). We strongly recommend to limit the number of columns and rows as RadGrid is not suitable for such scenarios.

All the best,
Kostadin
the Telerik team

[Ed]

Hi Kostadin,

Thanks for the reply.  However, my application doesn't throw any exceptions (I catch any that are thrown), so that doesn't seem to be the problem.  If I need to limit the number of rows and columns, how many rows and columns can I allow?  In other words, what is the limiting number for rows and columns such that the exporting functions will work reliably?

Thanks,

Ed

[Kostadin]

Hello Ed,

I am afraid that there is not a way to calculate the exact number of data which could be exported as this depends of the hardware configuration of the customers machines.Nevertheless a possible solution is to traverse the data of your data source and build a csv file manually. I prepared a small sample where I demonstrates how you can implement this approach.

All the best,
Kostadin
the Telerik team