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

Cells and Ranges

Accesses cells and ranges with the A1 notation and with row and column indexes, defines named ranges at worksheet and workbook level and reads the used range of the worksheet.

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

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

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

End Class