ByteScout Spreadsheet SDK – ASP.NET – Display XLS as HTML (VB.NET)


Imports Bytescout.Spreadsheet

Public Partial Class _Default
	Inherits System.Web.UI.Page

	Private _document As Spreadsheet = Nothing

	Protected Sub Page_Load(sender As Object, e As EventArgs)

		Dim inputXlsFile As String = Server.MapPath("example.xls")

		' Open spreadsheet
		_document = New Spreadsheet()

		Label1.Text = """Example.xls"" loaded"

		For i As Integer = 0 To _document.Worksheets.Count - 1

	End Sub

	Protected Sub ButtonGo_Click(ByVal sender As Object, ByVal e As EventArgs)

		Dim sheet As String = DropDownList1.SelectedItem.Text

		If Not String.IsNullOrEmpty(sheet) Then

			' Clear HTTP output
			' Set the content type to HTML
			Response.ContentType = "text/HTML"
			' Save selected worksheet to output stream as HTML


		End If

	End Sub
End Class


<?xml version="1.0"?>

            Set compilation debug="true" to insert debugging 
            symbols into the compiled page. Because this 
            affects performance, set this value to true only 
            during development.
        <compilation debug="true" />
            The <authentication> section enables configuration 
            of the security authentication mode used by 
            ASP.NET to identify an incoming user. 
        <authentication mode="Windows" />
            The <customErrors> section enables configuration 
            of what to do if/when an unhandled error occurs 
            during the execution of a request. Specifically, 
            it enables developers to configure html error pages 
            to be displayed in place of a error stack trace.

        <customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
            <error statusCode="403" redirect="NoAccess.htm" />
            <error statusCode="404" redirect="FileNotFound.htm" />