Save workbook as HTML

The following example shows you how to export a workbook to HTML format with a single call. The SaveAsHtml method writes every worksheet as an HTML table, preserving cell values, number formats, fonts, colors, borders and merged cells.

C# example

using System;
using Independentsoft.Office.Spreadsheet;

namespace Sample
{
    class Program
    {
        static void Main(string[] args)
        {
            Workbook book = new Workbook("c:\\test\\input.xlsx");

            book.SaveAsHtml("c:\\test\\output.html");
        }
    }
}

VB example

Imports System
Imports Independentsoft.Office.Spreadsheet

Module Module1
    Sub Main(ByVal args As String())

        Dim book As New Workbook("c:\test\input.xlsx")

        book.SaveAsHtml("c:\test\output.html")

    End Sub
End Module

Use the GetHtml method when you need the HTML markup as a string, for example to return it from a web request or embed it in a larger page instead of writing a file.

C# example

using System;
using Independentsoft.Office.Spreadsheet;

namespace Sample
{
    class Program
    {
        static void Main(string[] args)
        {
            Workbook book = new Workbook("c:\\test\\input.xlsx");

            string html = book.GetHtml();

            Console.WriteLine(html);
        }
    }
}

VB example

Imports System
Imports Independentsoft.Office.Spreadsheet

Module Module1
    Sub Main(ByVal args As String())

        Dim book As New Workbook("c:\test\input.xlsx")

        Dim html As String = book.GetHtml()

        Console.WriteLine(html)

    End Sub
End Module

The SaveAsHtml method also has an overload that writes to any System.IO.Stream, which is convenient when the HTML is streamed directly to the client and never stored on disk.

C# example

using System;
using System.IO;
using Independentsoft.Office.Spreadsheet;

namespace Sample
{
    class Program
    {
        static void Main(string[] args)
        {
            Workbook book = new Workbook("c:\\test\\input.xlsx");

            using (FileStream stream = new FileStream("c:\\test\\output.html", FileMode.Create, FileAccess.Write))
            {
                book.SaveAsHtml(stream);
            }
        }
    }
}

VB example

Imports System
Imports System.IO
Imports Independentsoft.Office.Spreadsheet

Module Module1
    Sub Main(ByVal args As String())

        Dim book As New Workbook("c:\test\input.xlsx")

        Using stream As New FileStream("c:\test\output.html", FileMode.Create, FileAccess.Write)
            book.SaveAsHtml(stream)
        End Using

    End Sub
End Module

Spreadsheet .NET > Tutorial > Save workbook as HTML

Need help? Ask our developers: