export to excel

[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

[sparrow1]

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

[Shaggy Hiker]

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?