#SAVE DATASET AS EXCEL FILE C# CODE#

Please remember to mark the replies as answers if they help and unmark them if they provide no help, this will help others who are looking for solutions to the same or similar problem. My two top picks are SpreadSheetLight and GemBox.

#SAVE DATASET AS EXCEL FILE C# CODE#

The following, the code used can be written in a VB.NET class project and called from C#.

Using OpenXML (which libraries such as SpreadSheetLight use under the covers) but going this direction needs you to understand the underlying model of Open XML.

Excel automation is not well suited to run server side. There are many articles on the web on this.

Using Excel automation, you need to be extremely careful with object management else you can leak memory during the processing or after processing.

Aspose Cells (paid for library), works well from my experience but is not cheap (where Gembox is an acceptable price).

Once opened the user can save the file as a native Excel file. When Excel is installed it becomes the default program to open. OleDb data provider, most likely this will not do well with a large data set and has a column limit.Gembox spreadsheet library (paid for), here is.Note with the amount of data you are working with even the best library and/or method is going to take time.Дepending on if the work is being done on a local computer or server can limit your options. Here are a couple of options in no specific order.

Save dataset as excel file c#