Hier ein Beispiel wie man eine DataTable mit Aspose.Cells exportieren kann:
Public Class CellsExport
Public Sub New(ByVal dt As DataTable, ByVal name As String)
'Excel-Workbook erzeugen
Dim workbook As Workbook = New Workbook()
workbook.Worksheets.Add()
Dim worksheet As Worksheet = workbook.Worksheets(0)
worksheet.Cells.ImportDataTable(dt, True, "A1")
'Exceldatei ausgeben
Dim ms As MemoryStream = workbook.SaveToStream()
Dim bytes As Byte()
bytes = ms.ToArray()
HttpContext.Current.Response.Clear()
HttpContext.Current.Response.ContentType = "application/vnd.ms-excel"
HttpContext.Current.Response.AddHeader("content-disposition", "attachment; filename=ExcelExport_" & name & ".xls")
HttpContext.Current.Response.BinaryWrite(bytes)
HttpContext.Current.Response.End()
End Sub
End class