SpreadsheetOptions

SpreadsheetOptions class

Provides options for rendering spreadsheets.

public class SpreadsheetOptions

Properties

Name Description
CountColumnsPerPage { get; } The columns count to include into each page when splitting worksheet into pages.
CountRowsPerPage { get; } The rows count to include into each page when splitting worksheet into pages.
DetectSeparator { get; set; } Detect separator (for CSV/TSV files).
RenderGridLines { get; set; } Enables grid lines rendering.
RenderHeadings { get; set; } Enables headings rendering.
RenderHiddenColumns { get; set; } Enables hidden columns rendering.
RenderHiddenRows { get; set; } Enables hidden rows rendering.
SkipEmptyColumns { get; set; } Disables empty columns rendering.
SkipEmptyRows { get; set; } Disables empty rows rendering.
TextOverflowMode { get; set; } The text overflow mode for rendering spreadsheet documents into HTML.

Methods

Name Description
static ForOnePagePerSheet() Initializes new instance of SpreadsheetOptions class for rendering whole sheet into page.
static ForRenderingByPageBreaks() Initializes new instance of SpreadsheetOptions for rendering print areas only.
static ForRenderingPrintArea() Initializes new instance of SpreadsheetOptions for rendering print areas only.
static ForSplitSheetIntoPages(int) Initializes new instance of SpreadsheetOptions for rendering sheet into pages.
static ForSplitSheetIntoPages(int, int) Initializes new instance of SpreadsheetOptions for rendering sheet into pages.

See Also