Class SheetSetting

Namespace

WeihanLi.Npoi.Settings

Assembly

WeihanLi.Npoi.dll

Excel Sheet Settings

public sealed class SheetSetting

Inheritance

object

SheetSetting

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.ReferenceEquals(object, object)

object.ToString()

Properties

AutoColumnWidthEnabled

Gets or set whether to enable auto column width, disabled by default.

public bool AutoColumnWidthEnabled { get; set; }

Property Value

bool

CellAction

Cell Action on export

public Action<ICell>? CellAction { get; set; }

Property Value

Action<ICell>

CellFilter

Cell Filter

public Func<ICell, bool>? CellFilter { get; set; }

Property Value

Func<ICell, bool>

EndRowIndex

EndRowIndex, included

public int? EndRowIndex { get; set; }

Property Value

int?

HeaderRowIndex

HeaderRowIndex

public int HeaderRowIndex { get; }

Property Value

int

RowAction

Row Action on export

public Action<IRow>? RowAction { get; set; }

Property Value

Action<IRow>

RowFilter

Row Filter

public Func<IRow, bool>? RowFilter { get; set; }

Property Value

Func<IRow, bool>

SheetAction

Sheet Action on export

public Action<ISheet>? SheetAction { get; set; }

Property Value

Action<ISheet>

SheetName

SheetName

public string SheetName { get; set; }

Property Value

string

SkipHeaderRow

Gets or sets whether to skip column index adjustment based on header row during import. When false (default), column indices are automatically adjusted based on header row. When true, column indices are used as-is.

public bool SkipHeaderRow { get; set; }

Property Value

bool

StartRowIndex

StartRowIndex

public int StartRowIndex { get; set; }

Property Value

int