ExcelHtmlExportOptions
OfficeIMO.Excel.Html
Options for exporting Excel workbooks and worksheets to HTML.
Inheritance
- object
- ExcelHtmlExportOptions
Usage
Explore 7 API references to this type
This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.
Returned or exposed by 3
Accepted by parameters 4
Constructors
public ExcelHtmlExportOptions() #Methods
public ExcelHtmlExportOptions Clone() #Creates an independent settings snapshot for one export operation.
Returns
ExcelHtmlExportOptionspublic static ExcelHtmlExportOptions CreateSemanticTablesProfile(OfficeVisualThemeKind theme = WordLike) #Creates semantic worksheet-table export settings.
Parameters
- theme OfficeIMO.Drawing.OfficeVisualThemeKind = WordLike
Returns
ExcelHtmlExportOptionspublic static ExcelHtmlExportOptions CreateVisualReviewProfile(OfficeVisualThemeKind theme = Report) #Creates positioned visual-review export settings.
Parameters
- theme OfficeIMO.Drawing.OfficeVisualThemeKind = Report
Returns
ExcelHtmlExportOptionsInherited Methods
Properties
public ExcelHtmlExportProfile ExportProfile { get; set; } #Excel-to-HTML lane to export. Defaults to semantic worksheet tables.
public OfficeHtmlConversionProfile Profile { get; set; } #Compatibility bridge to the former cross-format profile enum. New code should use ExcelHtmlExportOptions.ExportProfile so only Excel profiles are representable.
public OfficeHtmlDocumentOptions DocumentOutput { get; set; } #Composed document-versus-fragment, theme, title, language, style, and newline settings.
public OfficeVisualThemeKind Theme { get; set; } #Compatibility alias for OfficeHtmlDocumentOptions.Theme.
public bool IncludeDefaultStyles { get; set; } #Compatibility alias for OfficeHtmlDocumentOptions.IncludeDefaultStyles.
public string? Title { get; set; } #Compatibility alias for OfficeHtmlDocumentOptions.Title.
public bool EmitDocumentShell { get; set; } #Compatibility alias for OfficeHtmlDocumentOptions.EmitDocumentShell.
public string? Language { get; set; } #Compatibility alias for OfficeHtmlDocumentOptions.Language.
public string NewLine { get; set; } #Compatibility alias for OfficeHtmlDocumentOptions.NewLine.
public int? MaxRowsPerSheet { get; set; } #Maximum number of used-range rows exported per worksheet. Null uses the bounded default.
public int? MaxColumnsPerSheet { get; set; } #Maximum number of used-range columns exported per worksheet. Null uses the bounded default.
public int MaxCellsPerSheet { get; set; } #Maximum number of worksheet cells visited per semantic HTML table.
public int MaxMergedRangesPerSheet { get; set; } #Maximum number of merged-range records inspected per semantic HTML table.
public ExcelHtmlHeaderMode HeaderMode { get; set; } #Controls worksheet header semantics. Defaults to ExcelHtmlHeaderMode.FirstRow for compatibility with earlier OfficeIMO HTML output.
public ExcelImageExportOptions? VisualOptions { get; set; } #Options used by the existing Excel SVG visual export lane.
public bool IncludePivotInventory { get; set; } #Includes a deterministic semantic inventory for pivot tables. Interactive pivot behavior, caches, slicers, and timelines remain native workbook features and are not executed in HTML.
public bool ApplyCellPresentation { get; set; } #Applies worksheet presentation to semantic tables: cell fills, table-style header fills, conditional fills and data bars, number formats and spreadsheet alignment. Defaults to true. When false, cells keep their raw text and only font styling is emitted.
public bool RenderCharts { get; set; } #Renders worksheet charts as inline SVG in semantic tables, with the chart data in a collapsible table. Defaults to true.
public bool IncludeFormulaInventory { get; set; } #Appends a formula inventory (formula text, cached values and dependencies) after each worksheet. Defaults to false.
public bool IncludeObjectMetadata { get; set; } #Shows object metadata such as chart type, series counts, anchor cells and pixel sizes as visible text. Defaults to false; the data attributes are always written.
public bool FailOnLoss { get; set; } #Throws OfficeConversionException when the conversion reports loss.
Fields
public const int DefaultMaxRowsPerSheet #Default maximum worksheet rows projected to semantic HTML.
10000public const int DefaultMaxColumnsPerSheet #Default maximum worksheet columns projected to semantic HTML.
1024public const int DefaultMaxCellsPerSheet #Default maximum worksheet cells visited while projecting semantic HTML.
1000000public const int DefaultMaxMergedRangesPerSheet #Default maximum merged-range records inspected per worksheet.
10000