Convert Excel to HTML

Name: C# Excel Library - IronXL
Rating: 4.81 (173 reviews)

VB C#

using IronXL;
using IronXL.Options;

WorkBook workBook = WorkBook.Load("sample.xlsx");

var options = new HtmlExportOptions()
{
    // Set row/column numbers visible in html document
    OutputRowNumbers = true,
    OutputColumnHeaders = true,

    // Set hidden rows/columns visible in html document
    OutputHiddenRows = true,
    OutputHiddenColumns = true,

    // Set leading spaces as non-breaking
    OutputLeadingSpacesAsNonBreaking = true
};

// Export workbook to the HTML file
workBook.ExportToHtml("workBook.html", options);

Imports IronXL
Imports IronXL.Options

Private workBook As WorkBook = WorkBook.Load("sample.xlsx")

Private options = New HtmlExportOptions() With {
	.OutputRowNumbers = True,
	.OutputColumnHeaders = True,
	.OutputHiddenRows = True,
	.OutputHiddenColumns = True,
	.OutputLeadingSpacesAsNonBreaking = True
}

' Export workbook to the HTML file
workBook.ExportToHtml("workBook.html", options)

Install-Package IronXL.Excel

Convert Excel to HTML

The code example above demonstrates how to convert Excel to HTML in C#. Use HtmlExportOptions class to customize how the html output. The available options are:

OutputRowNumbers property indicates whether to show row numbers in result file
OutputColumnHeaders property indicates whether to show column header in result file
OutputHiddenRows property indicates whether to show hidden rows in result file
OutputHiddenColumns property indicates whether to show hidden columns in result file
OutputLeadingSpacesAsNonBreaking property indicates whether to show leading spaces(extra spaces before the first character in cell) as non-breaking in result file