SpreadsheetOptions

SpreadsheetOptions class

Provides options for rendering spreadsheets.

public class SpreadsheetOptions

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.

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.