ExpertXls Excel Library ASP.NET Web Forms demo · VB.NET

Excel Tables

Creates an Excel table with a built-in style, banded rows, filter buttons and a totals row, and a formula with a structured reference to the table. Excel tables need the Excel 2007+ format.

Select the format and press the button: the workbook is created on the server and downloaded by the browser.

Workbook format   

Create, edit and read Excel workbooks in ASP.NET: the workbooks are created on the server and sent to the browser. The code of each workbook is in App_Code.

VB.NET code of this sample

Tables.aspx.vb
Imports System.Data
Imports System.IO
Imports System.Web.UI
Imports ExpertXls.ExcelLib

''' <summary>
''' Excel Tables: the workbook code is in App_Code\TablesDemo.vb.
''' </summary>
Partial Class TablesPage
    Inherits Page

    ' AutoEventWireup="true" in the page directive connects Page_Load to the Load event
    Protected Sub Page_Load(sender As Object, e As EventArgs)
    End Sub

    Protected Sub buttonCreate_Click(sender As Object, e As EventArgs)
        Dim format As ExcelWorkbookFormat = If(radioXlsx.Checked, ExcelWorkbookFormat.Xlsx_2007, ExcelWorkbookFormat.Xls_2003)
        Dim workbookBytes As Byte()
        Try
            ' create the workbook in memory; the input files are in the folders of the web site
            Using stream As New MemoryStream()
                TablesDemo.CreateWorkbook(format, Server.MapPath("~"), stream)
                workbookBytes = stream.ToArray()
            End Using
        Catch ex As Exception
            labelError.Text = "The workbook could not be created: " & Server.HtmlEncode(ex.Message)
            Return
        End Try
        WorkbookDownload.Send(Response, workbookBytes, TablesDemo.OutputName & DemoLayout.GetExtension(format), format)
    End Sub

End Class