I need to export a huge data table consisting 100 columns and 1000 I am using .Net 4.5 as framework and C# as programming language I need a solution where this data table can be exported into Excel very quickly.
Asked
Active
Viewed 3,298 times
0
-
what have you done so far? and how slow is it??? how much faster would you like it to be? – ry8806 Jul 22 '15 at 12:19
-
possible duplicate of [How to export DataTable to Excel in C#](http://stackoverflow.com/questions/8207869/how-to-export-datatable-to-excel-in-c-sharp) – Liam Jul 22 '15 at 12:54
-
1How about you export it into a CSV file? Excel is good for viewing and processing those files and exporting to CSV is much faster. – LightBulb Jul 22 '15 at 12:55
-
1Have you considered [Quantum Computing](https://en.wikipedia.org/wiki/Quantum_computing) :) *Large-scale quantum computers will be able to solve certain problems much more quickly than any classical computers that use even the best currently known algorithms* – Liam Jul 22 '15 at 12:55
-
1Maybe you can take a look [here](http://www.codeproject.com/Tips/659666/Export-very-large-data-to-Excel-file) – DanielV Jul 22 '15 at 14:21
-
Thanks DanielV your suggestion works for me. – agsk Jul 23 '15 at 13:18