I'm new to the SpreadSheet control, I have used the standard example WPF code to create it as a user control.
Then I use this control in a RadWindow, and I want to add the data from DataTable from a database table with 72 columns and 110000 rows.
I use a simple loop to do this, since I have understood that databinding is not possible with a datatable on the SpreadSheet control.
When I try to load the data I get this message System.OutOfMemoryException.
I have browsed these posts, and so I also limitted the number of visble rows and columns to 80 x 100 but without success.
Can anyone tell me how I can do this correctly?
Basically I already moved away from the RadGridView since the RadGridView can not save to a Xlsx anymore, and the files that are generated are either not recognized by excel, or take too long too open with Excel.
So if anyone can give me a good way to export preferably with an intermediate grid, or otherwise a datatable to Excel in a Fast way, that keeps all the correct data types, and opens fast in Excel that would also be very helpfull.