Table of Contents

Class XlsxWorksheet

Namespace
DocWright.Formats.Xlsx
Assembly
DocWright.Formats.Xlsx.dll

One worksheet in a workbook.

public sealed class XlsxWorksheet
Inheritance
XlsxWorksheet
Inherited Members

Constructors

XlsxWorksheet(string)

Creates a worksheet.

Properties

AutoFilter

Gets or sets the range an autofilter covers, or null for none.

Columns

Gets the column runs, in ascending order.

FrozenColumns

Gets or sets the number of leading columns frozen in the view, zero for none.

FrozenRows

Gets or sets the number of leading rows frozen in the view, zero for none.

Images

Gets the images anchored on this sheet.

MergedRanges

Gets the merged ranges.

Name

Gets or sets the sheet name as the tab shows it.

OutlineSummaryBelow

Gets or sets whether an outline group's summary row sits below its details.

OutlineSummaryRight

Gets or sets whether an outline group's summary column sits to the right of its details.

PageSetup

Gets the page setup this sheet prints with.

Rows

Gets the rows, in ascending order.

ShowGridLines

Gets or sets whether the grid is drawn behind the cells. True by default, as in Excel.