How to export a table to excel?
-
Hello, everyone: Now i want to export my query result to excel. At first, i have tried to export the results displayed through datagrid directly to excel. However, the amount of query result is quite large, in this case i decide to use page sorting datagrid. but most articles in CP tell us how to export only one page to excel, not all the datatable. Therefore, is there any better approach to export all the datatable directly to excel? Any idear will be appreciated! Thanks in advance!
-
Hello, everyone: Now i want to export my query result to excel. At first, i have tried to export the results displayed through datagrid directly to excel. However, the amount of query result is quite large, in this case i decide to use page sorting datagrid. but most articles in CP tell us how to export only one page to excel, not all the datatable. Therefore, is there any better approach to export all the datatable directly to excel? Any idear will be appreciated! Thanks in advance!
The above link will solve you problem, very nice code and easy to use. http://www.codeproject.com/csharp/datasettoexcel.asp Ram