I’m using the following code snippet to generate an XLS file and download to the browser… it works fine up to about 3000 rows or so… then when trying to open the file in Excel, it states there were too many errors in the file and aborts…
oCells.ImportDataTable(dt, True, 0, 0, CType(Me.txtRows.Text, Integer), 50)
If System.IO.File.Exists(cOutput) Then
Response.BufferOutput = True
If Me.rbEXP_ByAccount.Checked Then
Response.ContentType = “text/filedown”
any help would be appreciated…
Would like to email us a completely working test case ( including data) which can reproduce the errors?
Thanks for your cooperation.