Where does HtmlExportOptions live in the IronXL API?

HtmlExportOptions is a class in the IronXL.Options namespace, shipped in IronXL.dll, deriving from System.Object. It configures how a workbook is rendered when exporting to HTML.

How do you show column headers when exporting Excel to HTML in C#?

Create an HtmlExportOptions instance and set OutputColumnHeaders to true, optionally with OutputRowNumbers, then pass it to the HTML export. Both are boolean properties that add the grid labels to the generated page.

Class HtmlExportOptions

Options for exporting workbook to HTML format.

Inheritance

System.Object

HtmlExportOptions

Namespace: IronXL.Options

Assembly: IronXL.dll

Syntax

public class HtmlExportOptions : Object

When a spreadsheet is exported to HTML, HtmlExportOptions controls what the generated page actually shows. It is the settings object a developer passes alongside an HTML export to decide whether spreadsheet furniture such as row numbers and column headers appears in the output, and how hidden content and spacing are treated.

Set the relevant properties before running the export. OutputColumnHeaders and OutputRowNumbers add the A, B, C column letters and the 1, 2, 3 row indexes to the rendered table, useful when the HTML needs to mirror the grid a user sees in Excel. OutputHiddenColumns and OutputHiddenRows decide whether content hidden in the workbook is carried into the page or dropped. OutputLeadingSpacesAsNonBreaking preserves indentation by emitting leading spaces as non-breaking spaces, which browsers would otherwise collapse. Every property is a boolean, so configuring an export is a short sequence of true or false toggles. The parameterless constructor creates the options with default values ready to adjust.

using IronXL.Options;

var options = new HtmlExportOptions();
options.OutputColumnHeaders = true;
options.OutputRowNumbers = true;

The convert Excel to HTML example renders a workbook as a page, and the convert file types how-to covers other output formats.

Constructors

HtmlExportOptions()

Declaration

public HtmlExportOptions()

Properties

OutputColumnHeaders

Property that indicates whether to show column header in result file.

Declaration

public bool OutputColumnHeaders { get; set; }

Property Value

Type	Description
System.Boolean

OutputHiddenColumns

Property that indicates whether to show hidden columns in result file.

Declaration

public bool OutputHiddenColumns { get; set; }

Property Value

Type	Description
System.Boolean

OutputHiddenRows

Property that indicates whether to show hidden rows in result file.

Declaration

public bool OutputHiddenRows { get; set; }

Property Value

Type	Description
System.Boolean

OutputLeadingSpacesAsNonBreaking

Property that indicates whether to show leading spaces as non-breaking in result file.

Declaration

public bool OutputLeadingSpacesAsNonBreaking { get; set; }

Property Value

Type	Description
System.Boolean

OutputRowNumbers

Property that indicates whether to show row numbers in result file.

Declaration

public bool OutputRowNumbers { get; set; }

Property Value

Type	Description
System.Boolean