Interface IExcelConfiguration

Namespace

WeihanLi.Npoi.Configurations

Assembly

WeihanLi.Npoi.dll

public interface IExcelConfiguration

Extension Methods

ConfigurationExtensions.HasAuthor(IExcelConfiguration, string)

ConfigurationExtensions.HasCategory(IExcelConfiguration, string)

ConfigurationExtensions.HasCompany(IExcelConfiguration, string)

ConfigurationExtensions.HasDescription(IExcelConfiguration, string)

ConfigurationExtensions.HasSheetConfiguration(IExcelConfiguration, int, string)

ConfigurationExtensions.HasSheetConfiguration(IExcelConfiguration, int, string, bool)

ConfigurationExtensions.HasSheetConfiguration(IExcelConfiguration, int, string, int)

ConfigurationExtensions.HasSheetConfiguration(IExcelConfiguration, int, string, int, bool, int?)

ConfigurationExtensions.HasSubject(IExcelConfiguration, string)

ConfigurationExtensions.HasTitle(IExcelConfiguration, string)

Methods

HasExcelSetting(Action<ExcelSetting>)

excel setting configure

IExcelConfiguration HasExcelSetting(Action<ExcelSetting> configAction)

Parameters

configAction Action<ExcelSetting>

config delegate

Returns

IExcelConfiguration

current excel configuration

HasFilter(int)

setting filter

IExcelConfiguration HasFilter(int firstColumn)

Parameters

firstColumn int

firstCol Index of first column

Returns

IExcelConfiguration

current excel configuration

HasFilter(int, int?)

setting filter

IExcelConfiguration HasFilter(int firstColumn, int? lastColumn)

Parameters

firstColumn int

firstCol Index of first column

lastColumn int?

lastCol Index of last column (inclusive), must be equal to or larger than {@code firstCol}

Returns

IExcelConfiguration

current excel configuration

HasFreezePane(int, int)

setting freeze pane Creates a split (freeze pane). Any existing freeze pane or split pane is overwritten.

IExcelConfiguration HasFreezePane(int colSplit, int rowSplit)

Parameters

colSplit int

Horizontal position of split

rowSplit int

Vertical position of split

Returns

IExcelConfiguration

current excel configuration

HasFreezePane(int, int, int, int)

setting freeze pane Creates a split (freeze pane). Any existing freeze pane or split pane is overwritten.

IExcelConfiguration HasFreezePane(int colSplit, int rowSplit, int leftmostColumn, int topRow)

Parameters

colSplit int

Horizontal position of split

rowSplit int

Vertical position of split

leftmostColumn int

Top row visible in bottom pane

topRow int

Left column visible in right pane

Returns

IExcelConfiguration

current excel configuration

HasSheetSetting(Action<SheetSetting>, int)

Sheet Configuration

IExcelConfiguration HasSheetSetting(Action<SheetSetting> configAction, int sheetIndex = 0)

Parameters

configAction Action<SheetSetting>

sheet config delegate

sheetIndex int

sheetIndex, 0 is the default value

Returns

IExcelConfiguration

current excel configuration