ByteScout Data Extraction Suite – ASP.NET VB – Display xls as html with spreadsheet sdk

Home
/
Articles
/
ByteScout Data Extraction Suite – ASP.NET VB – Display xls as html with spreadsheet sdk

printable version:
ByteScout-Data-Extraction-Suite-ASP-NET-VB-Display-xls-as-html-with-spreadsheet-sdk.pdf

How to display xls as html with spreadsheet sdk in ASP.NET VB with ByteScout Data Extraction Suite

If you want to learn more then this tutorial will show how to display xls as html with spreadsheet sdk in ASP.NET VB

The sample shows instructions and algorithm of how to display xls as html with spreadsheet sdk and how to make it run in your ASP.NET VB application. ByteScout Data Extraction Suite is the bundle that includes three SDK tools for data extraction from PDF, scans, images and from spreadsheets: PDF Extractor SDK, Data Extraction SDK, Barcode Reader SDK. It can display xls as html with spreadsheet sdk in ASP.NET VB.

The following code snippet for ByteScout Data Extraction Suite works best when you need to quickly display xls as html with spreadsheet sdk in your ASP.NET VB application. Simply copy and paste in your ASP.NET VB project or application you and then run your app! Enjoy writing a code with ready-to-use sample ASP.NET VB codes.

If you want to try other source code samples then the free trial version of ByteScout Data Extraction Suite is available for download from our website. Just try other source code samples for ASP.NET VB.

On-demand (REST Web API) version:
Web API (on-demand version)

On-premise offline SDK for Windows:
60 Day Free Trial (on-premise)

Default.aspx

      <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="DisplayXlsAsHtml._Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:Label ID="Label1" runat="server" Width="311px"></asp:Label><br />
        <br />
        <asp:Label ID="Label2" runat="server" Text="Select worksheet to display: "></asp:Label>
        <asp:DropDownList ID="DropDownList1" runat="server"
            Width="233px">
        </asp:DropDownList>
        <asp:Button ID="ButtonGo" runat="server" Text="Go" Width="45px" OnClick="ButtonGo_Click" /></div>
    </form>
</body>
</html>

ON-PREMISE OFFLINE SDK

60 Day Free Trial or Visit ByteScout Data Extraction Suite Home Page

Explore ByteScout Data Extraction Suite Documentation

Explore Samples

Sign Up for ByteScout Data Extraction Suite Online Training

ON-DEMAND REST WEB API

Get Your API Key

Explore Web API Docs

Explore Web API Samples

Default.aspx.designer.vb

      '------------------------------------------------------------------------------
' <auto-generated>
'     This code was generated by a tool.
'     Runtime Version:2.0.50727.4927
'
'     Changes to this file may cause incorrect behavior and will be lost if
'     the code is regenerated.
' </auto-generated>
'------------------------------------------------------------------------------



''' <summary>
''' _Default class.
''' </summary>
''' <remarks>
''' Auto-generated class.
''' </remarks>
Public Partial Class _Default

	''' <summary>
	''' form1 control.
	''' </summary>
	''' <remarks>
	''' Auto-generated field.
	''' To modify move field declaration from designer file to code-behind file.
	''' </remarks>
	Protected form1 As Global.System.Web.UI.HtmlControls.HtmlForm

	''' <summary>
	''' Label1 control.
	''' </summary>
	''' <remarks>
	''' Auto-generated field.
	''' To modify move field declaration from designer file to code-behind file.
	''' </remarks>
	Protected Label1 As Global.System.Web.UI.WebControls.Label

	''' <summary>
	''' Label2 control.
	''' </summary>
	''' <remarks>
	''' Auto-generated field.
	''' To modify move field declaration from designer file to code-behind file.
	''' </remarks>
	Protected Label2 As Global.System.Web.UI.WebControls.Label

	''' <summary>
	''' DropDownList1 control.
	''' </summary>
	''' <remarks>
	''' Auto-generated field.
	''' To modify move field declaration from designer file to code-behind file.
	''' </remarks>
	Protected DropDownList1 As Global.System.Web.UI.WebControls.DropDownList

	''' <summary>
	''' ButtonGo control.
	''' </summary>
	''' <remarks>
	''' Auto-generated field.
	''' To modify move field declaration from designer file to code-behind file.
	''' </remarks>
	Protected ButtonGo As Global.System.Web.UI.WebControls.Button
End Class

ON-PREMISE OFFLINE SDK

ON-DEMAND REST WEB API

Get Your API Key

Explore Web API Docs

Explore Web API Samples

Default.aspx.vb

      
Imports Bytescout.Spreadsheet

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

    ' IF YOU SEE TEMPORARY FOLDER ACCESS ERRORS: 

    ' Temporary folder access is required for web application when you use ByteScout SDK in it.
    ' If you are getting errors related to the access to temporary folder like "Access to the path 'C:\Windows\TEMP\... is denied" then you need to add permission for this temporary folder to make ByteScout SDK working on that machine and IIS configuration because ByteScout SDK requires access to temp folder to cache some of its data for more efficient work.

    ' SOLUTION:

    ' If your IIS Application Pool has "Load User Profile" option enabled the IIS provides access to user's temp folder. Check user's temporary folder

    ' If you are running Web Application under an impersonated account or IIS_IUSRS group, IIS may redirect all requests into separate temp folder like "c:\temp\".

    ' In this case
    ' - check the User or User Group your web application is running under
    ' - then add permissions for this User or User Group to read and write into that temp folder (c:\temp or c:\windows\temp\ folder)
    ' - restart your web application and try again


	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()
		_document.LoadFromFile(inputXlsFile)

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

		For i As Integer = 0 To _document.Worksheets.Count - 1
			DropDownList1.Items.Add(_document.Worksheets(i).Name)
		Next

	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
			Response.Clear()
			' Set the content type to HTML
			Response.ContentType = "text/HTML"
			' Save selected worksheet to output stream as HTML
			_document.Worksheets(sheet).SaveAsHTML(Response.OutputStream)

			Response.End()

		End If

	End Sub
End Class

ON-PREMISE OFFLINE SDK

ON-DEMAND REST WEB API

Get Your API Key

Explore Web API Docs

Explore Web API Samples

Web.config

      <?xml version="1.0"?>

<configuration>
  
    <appSettings/>
    <connectionStrings/>
  
    <system.web>
        <!-- 
            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" />
        </customErrors>
        -->
    </system.web>
</configuration>

ON-PREMISE OFFLINE SDK

ON-DEMAND REST WEB API

Get Your API Key

Explore Web API Docs

Explore Web API Samples

VIDEO

ON-PREMISE OFFLINE SDK

ON-DEMAND REST WEB API

Get Your API Key

Explore Web API Docs

Explore Web API Samples

printable version:
ByteScout-Data-Extraction-Suite-ASP-NET-VB-Display-xls-as-html-with-spreadsheet-sdk.pdf

ByteScout Data Extraction Suite – ASP.NET VB – Display xls as html with spreadsheet sdk

How to display xls as html with spreadsheet sdk in ASP.NET VB with ByteScout Data Extraction Suite

If you want to learn more then this tutorial will show how to display xls as html with spreadsheet sdk in ASP.NET VB

Default.aspx

ON-PREMISE OFFLINE SDK

ON-DEMAND REST WEB API

Default.aspx.designer.vb

ON-PREMISE OFFLINE SDK

ON-DEMAND REST WEB API

Default.aspx.vb

ON-PREMISE OFFLINE SDK

ON-DEMAND REST WEB API

Web.config

ON-PREMISE OFFLINE SDK

ON-DEMAND REST WEB API

VIDEO

ON-PREMISE OFFLINE SDK

ON-DEMAND REST WEB API

Tutorials: