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

CSV Import and Export

Imports Data\awemployees.csv into a new workbook, the numbers and dates as number and date cells, and formats the table. Export to CSV saves the first worksheet back to a CSV file.

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

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

''' <summary>
''' CSV Import and Export: the workbook code is in App_Code\ImportCsvDemo.vb.
''' </summary>
Partial Class ImportCSVPage
    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()
                ImportCsvDemo.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, ImportCsvDemo.OutputName & DemoLayout.GetExtension(format), format)
    End Sub

End Class