Generate Excel spreadsheet with ASP.Net (VB)

James Diamond · July 28th, 2004, 05:21 AM

Hi there,

I understand there are commercial ASP.Net tools available that enable you to generate an Excel spreadsheet on the server (from a set of data) and send it to the user's browser (for opening there).

I have looked at a couple of these.

Please can someone recommend one to me? The best one... or a good one...

Many thanks.

James

planoie · July 28th, 2004, 07:47 AM

You don't need anything commercial. You can generate Excel with raw HTML. All you need to do is generate an HTML <table> with your data and formatting within it. You also need to specify the content type of the response so the browser knows that it's looking at "Excel content". There are numerous example on this forum that explain how to do this. Try searching on here for "excel" and "ContentType". That should get you pretty close to what you need.

BrendaBessi · December 11th, 2013, 08:15 AM

Hi, to create an Excel file in .NET you can check out a free version of this VB.NET Excel component.
Here is a small demonstration how to export an Excel file in ASP.NET:

Code:

' Extract DataTable from current ASP.NET session.
Dim dataTable = DirectCast(Me.Session("people"), DataTable)

' Create Excel file.
Dim workbook = New ExcelFile()
Dim worksheet = workbook.Worksheets.Add("DataSheet")

' Insert DataTable to worksheet.
worksheet.InsertDataTable(dataTable,
    New InsertDataTableOptions("A1") With {.ColumnHeaders = True})

' Stream file to browser in XLS file format.
workbook.Save(Me.Response, "Sample.xls")