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

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

Default.aspx.cs

using System;
using Bytescout.Spreadsheet;

namespace DisplayXlsAsHtml
{
public partial class _Default : System.Web.UI.Page
{
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(); } } } } [/csharp]

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>

  Click here to get your Free Trial version of the SDK