How can i export large ​datatable(>1​M) into excel ?

i got error when rows number is greater than 64K .

@davidlliu:Excel 2003? It can only deal with 64k rows at a time.

I agree with blowdart though - if you need 64k rows in a spreadsheet, "you're doing it wrong."

@davidlliu:  Excel has a built in limitation of 65535 rows (unless you are using 2007+).  This limit is per worksheet, not workbook.  Technically you could create 65535 rows on work sheet #1, add a new worksheet and continue adding rows.  Repeat action until done.

I had a situation where the customer dictated that the final data be contained within a excel formatted document.  While I warned them trying to fit 11 GB of data into Excel was insane, it is technically possible.  It is very impractical.  I would recommend keeping the number of worksheets per workbook to a small number as things tend to get out of hand.

@davidlliu:

We developed our own grid control for our Winforms apps over the years. Its export to excel functionality placed content on subsequent worksheets in the workbook, when we it 60000 rows. I have easily sent over 1 million rows into excel that way spread across multiple sheets in the workbook.