Display XLS as HTML | ASP.NET C#Bytescout Spreadsheet SDK

Display XLS as HTML | ASP.NET C#

Default.aspx:

VB
Copy
<%@ 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>

Default.aspx.cs:

C#
Copy
using System;
using Bytescout.Spreadsheet;

namespace DisplayXlsAsHtml
{
    public partial class _Default : 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

        */

        Spreadsheet _document = null;

        protected void Page_Load(object sender, EventArgs e)
        {
            String inputXlsFile = Server.MapPath("example.xls");

            // Open spreadsheet
            _document = new Spreadsheet();
            _document.LoadFromFile(inputXlsFile);

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

            for (int i = 0; i < _document.Worksheets.Count ; i++)
            {
                DropDownList1.Items.Add(_document.Worksheets[i].Name);
            }
        }

        protected void ButtonGo_Click(object sender, EventArgs e)
        {
            String sheet = DropDownList1.SelectedItem.Text;

            if (!String.IsNullOrEmpty(sheet))
            {
                // 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();
            }
        }
    }
}

Web.config:

Copy
<?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>