I need to export to Excel from the serer. The data that I need to export is info of customers(FirstName, LastName, Email, PhoneNumber...). Number of records may be even 2000.
I can use Microsoft.Office.Interop.Excel to create excel, to fill it and return through response to the client. But this option creates COM object and I then need to release all COM object(Workbook, Excel...) and call CollectionGarbage to release.
The second way is to create DataGrid, to fill it and send to the client through response.Write(StringWriter) and NO need to dispose COM object
My guess, that the 1st option is more easy one.
What can you suggest?
View Complete Post