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

  • Home
  • /
  • Articles
  • /
  • ByteScout Spreadsheet SDK – ASP.NET – Display XLS as HTML (C#)

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


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();

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]


<?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" />

  Click here to get your Free Trial version of the SDK