ByteScout Spreadsheet SDK - ASP.NET VB.NET - Display XLS as HTML - ByteScout

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

  • Home
  • /
  • Articles
  • /
  • ByteScout Spreadsheet SDK – ASP.NET VB.NET – Display XLS as HTML

How to display XLS as HTML in ASP.NET VB.NET using ByteScout Spreadsheet SDK

How to code in ASP.NET VB.NET to display XLS as HTML with this step-by-step tutorial

This sample source code below will demonstrate you how to display XLS as HTML in ASP.NET VB.NET. ByteScout Spreadsheet SDK: the library (SDK) that is capable of writing, reading, modifying and calculating Excel and CSV spreadsheets. Most popular formulas can be calculated and reculculated with Excel installed. You may import or export data to and from CSV, XML, JSON as well as to and from databases, arrays. It can display XLS as HTML in ASP.NET VB.NET.

ASP.NET VB.NET code samples for ASP.NET VB.NET developers help to speed up coding of your application when using ByteScout Spreadsheet SDK. In your ASP.NET VB.NET project or application you may simply copy & paste the code and then run your app! Further enhancement of the code will make it more vigorous.

Trial version of ByteScout Spreadsheet SDK can be downloaded for free from our website. It also includes source code samples for ASP.NET VB.NET and other programming languages.

Try it today: Get 60 Day Free Trial or sign up for Web API

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>

Try it today: Get 60 Day Free Trial or sign up for Web API

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

Try it today: Get 60 Day Free Trial or sign up for Web API

Default.aspx.vb
      
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() _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

Try it today: Get 60 Day Free Trial or sign up for Web API

DisplayXlsAsHtml.sln
      
Microsoft Visual Studio Solution File, Format Version 12.00 # Visual Studio 2013 VisualStudioVersion = 12.0.40629.0 MinimumVisualStudioVersion = 10.0.40219.1 Project("{F184B08F-C81C-45F6-A57F-5ABD9991F28F}") = "DisplayXlsAsHtml", "DisplayXlsAsHtml.vbproj", "{9981C3E2-AD65-4519-9C85-7EB9B9852931}" EndProject Global GlobalSection(SolutionConfigurationPlatforms) = preSolution Debug|Any CPU = Debug|Any CPU Release|Any CPU = Release|Any CPU EndGlobalSection GlobalSection(ProjectConfigurationPlatforms) = postSolution {9981C3E2-AD65-4519-9C85-7EB9B9852931}.Debug|Any CPU.ActiveCfg = Debug|Any CPU {9981C3E2-AD65-4519-9C85-7EB9B9852931}.Debug|Any CPU.Build.0 = Debug|Any CPU {9981C3E2-AD65-4519-9C85-7EB9B9852931}.Release|Any CPU.ActiveCfg = Release|Any CPU {9981C3E2-AD65-4519-9C85-7EB9B9852931}.Release|Any CPU.Build.0 = Release|Any CPU EndGlobalSection GlobalSection(SolutionProperties) = preSolution HideSolutionNode = FALSE EndGlobalSection EndGlobal

Try it today: Get 60 Day Free Trial or sign up for Web API

DisplayXlsAsHtml.vbproj
      
<?xml version="1.0" encoding="utf-8"?> <Project DefaultTargets="Build" xmlns="http://schemas.microsoft.com/developer/msbuild/2003" ToolsVersion="4.0"> <PropertyGroup> <Configuration Condition=" '$(Configuration)' == '' ">Debug</Configuration> <Platform Condition=" '$(Platform)' == '' ">AnyCPU</Platform> <ProductVersion> </ProductVersion> <SchemaVersion>2.0</SchemaVersion> <ProjectGuid>{9981C3E2-AD65-4519-9C85-7EB9B9852931}</ProjectGuid> <ProjectTypeGuids>{349c5851-65df-11da-9384-00065b846f21};{F184B08F-C81C-45F6-A57F-5ABD9991F28F}</ProjectTypeGuids> <OutputType>Library</OutputType> <AppDesignerFolder>Properties</AppDesignerFolder> <RootNamespace>DisplayXlsAsHtml</RootNamespace> <AssemblyName>DisplayXlsAsHtml</AssemblyName> <OldToolsVersion>4.0</OldToolsVersion> <TargetFrameworkVersion>v4.0</TargetFrameworkVersion> <FileUpgradeFlags> </FileUpgradeFlags> <UpgradeBackupLocation> </UpgradeBackupLocation> </PropertyGroup> <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Debug|AnyCPU' "> <DebugSymbols>true</DebugSymbols> <DebugType>full</DebugType> <Optimize>false</Optimize> <OutputPath>bin\</OutputPath> <DefineConstants>DEBUG,TRACE</DefineConstants> <ErrorReport>prompt</ErrorReport> <WarningLevel>4</WarningLevel> <NoWarn>42353,42354,42355</NoWarn> </PropertyGroup> <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Release|AnyCPU' "> <DebugType>pdbonly</DebugType> <Optimize>true</Optimize> <OutputPath>bin\</OutputPath> <DefineConstants>TRACE</DefineConstants> <ErrorReport>prompt</ErrorReport> <WarningLevel>4</WarningLevel> <NoWarn>42353,42354,42355</NoWarn> </PropertyGroup> <Import Project="$(MSBuildToolsPath)\Microsoft.VisualBasic.Targets" /> <ItemGroup> <Import Include="Microsoft.VisualBasic" /> <Import Include="System" /> <Reference Include="Bytescout.Spreadsheet, Version=2.2.0.325, Culture=neutral, PublicKeyToken=f7dd1bd9d40a50eb"> <HintPath>..\..\..\..\..\..\XLSRW\bin\1.1 Debug(DEMO)\Bytescout.Spreadsheet.dll</HintPath> <SpecificVersion>False</SpecificVersion> </Reference> <Reference Include="System" /> <Reference Include="System.Configuration" /> <Reference Include="System.Data" /> <Reference Include="System.Drawing" /> <Reference Include="System.EnterpriseServices" /> <Reference Include="System.Web" /> <Reference Include="System.Web.Mobile" /> <Reference Include="System.Web.Services" /> <Reference Include="System.Xml" /> <Content Include="Default.aspx" /> <Content Include="example.xls" /> <Content Include="Web.config" /> <Compile Include="Default.aspx.designer.vb"> <DependentUpon>Default.aspx</DependentUpon> </Compile> <Compile Include="Default.aspx.vb"> <DependentUpon>Default.aspx</DependentUpon> <SubType>ASPXCodeBehind</SubType> </Compile> <Compile Include="Properties\AssemblyInfo.vb" /> </ItemGroup> <ItemGroup> </ItemGroup> <ProjectExtensions> <VisualStudio> <FlavorProperties GUID="{349c5851-65df-11da-9384-00065b846f21}"> <WebProjectProperties> <UseIIS>False</UseIIS> <AutoAssignPort>True</AutoAssignPort> <DevelopmentServerPort>49443</DevelopmentServerPort> <DevelopmentServerVPath>/</DevelopmentServerVPath> <IISUrl> </IISUrl> <NTLMAuthentication>False</NTLMAuthentication> </WebProjectProperties> </FlavorProperties> </VisualStudio> </ProjectExtensions> <Import Project="$(MSBuildExtensionsPath32)\Microsoft\VisualStudio\v11.0\WebApplications\Microsoft.WebApplication.targets" /> </Project>

Try it today: Get 60 Day Free Trial or sign up for Web API

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>

Try it today: Get 60 Day Free Trial or sign up for Web API

MORE INFORMATION

Get 60 Day Free Trial or Visit ByteScout Spreadsheet SDK page

Explore ByteScout Spreadsheet SDK documentation

WEB API VERSION

Sign Up for free Web API key

Explore Web API Documentation

Tutorials:

prev
next