Hi, you can try this
VB.NET Excel component, I use it for creating a very large excel report files, really fast and did not have any issues.
Here is how you can
export a DataSet to an Excel file in VB.NET:
Code:
' Create new ExcelFile.
Dim workbook = New ExcelFile()
' Export all tables from DataSet to a new file.
For Each dataTable As DataTable In dataSet.Tables
' Add new worksheet to the file.
Dim worksheet = workbook.Worksheets.Add(dataTable.TableName)
' Insert the data from DataTable to the worksheet starting at cell "A1".
worksheet.InsertDataTable(dataTable,
New InsertDataTableOptions("A1") With {.ColumnHeaders = True})
Next
' Save the file to XLS format.
workbook.Save("DataSet.xls")
Export data to MS Excel in VB.NET
