SpreadsheetEditOptions

SpreadsheetEditOptions class

Allows to specify custom options for editing documents of all supportable Spreadsheet (Excel-compatible) formats

public class SpreadsheetEditOptions : IEditOptions

Constructors

Name Description
SpreadsheetEditOptions() The default constructor.

Properties

Name Description
ExcludeHiddenWorksheets { get; set; } Allows to exclude hidden worksheets in the input Spreadsheet document, so they will be totally ignored. Default is false - hidden worksheets are available and processed as normal.
ExportBogusRowData { get; set; } When enabled, the HTML table in produced HTML document contains an empty bottom hidden row with zero height and empty cells, where only width is specified. This row with empty cells contains exact width values for each column and improves backward conversion from HTML to Spreadsheet. By default is enabled (true).
MergeEmptyAdjacentCells { get; set; } When enabled, the empty adjucent horizontal cells from the input Spreadsheet document will be represented in editable HTML document as merged into a single cell with corresponding colspan attribute. By default is disabled (false).
WorksheetIndex { get; set; } Allows to specify the 0-based index of the worksheet (tab) of the input Spreadsheet document, which should be converted to the HTML (see remarks).

See Also