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

Formulas

Adds formulas, array formulas and formulas with named ranges, and calculates the formula results in the library.

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

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

''' <summary>
''' Formulas: the workbook code is in App_Code\FormulasDemo.vb.
''' </summary>
Partial Class FormulasDemoPage
    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()
                FormulasDemo.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, FormulasDemo.OutputName & DemoLayout.GetExtension(format), format)
    End Sub

End Class