export to excel

Hi all
I want to export from dataset or from datagrid (alot of records such as hundred thousand or million record) to Microsoft Excel file. How can I do it quikly???
Thanks very much

Quote:

---

Originally Posted by HicHic

Hi all
I want to export from dataset or from datagrid (alot of records such as hundred thousand or million record) to Microsoft Excel file. How can I do it quikly???
Thanks very much

---

Hi,

I search a bit and found this link, try it;

http://msdn.microsoft.com/library/de...HV05201119.asp

hope it helps,

sparrow1

By the way, you will have problems since an Excel spreadsheet has a maximum number of rows that is only around 65,000. Hundreds of thousands of lines will mean that you'll have to split it out onto multiple spreadsheets.

Why do you want that much in a spreadsheet?