Interface IXLWorksheets

Namespace

SlapKit.Excel.Excel

Assembly

SlapKit.Excel.dll

public interface IXLWorksheets : IEnumerable<IXLWorksheet>, IEnumerable

Inherited Members

IEnumerable<IXLWorksheet>.GetEnumerator()

Extension Methods

AttributeExtensions.GetMethod<T>(T, Expression<Action<T>>)

AttributeExtensions.GetMethod<T>(T, Expression<Func<T, object>>)

Properties

Count

int Count { get; }

Property Value

int

Methods

Add()

IXLWorksheet Add()

Returns

IXLWorksheet

Add(DataSet)

void Add(DataSet dataSet)

Parameters

dataSet DataSet

Add(DataTable)

IXLWorksheet Add(DataTable dataTable)

Parameters

dataTable DataTable

Returns

IXLWorksheet

Add(DataTable, string)

IXLWorksheet Add(DataTable dataTable, string sheetName)

Parameters

dataTable DataTable

sheetName string

Returns

IXLWorksheet

Add(DataTable, string, string)

IXLWorksheet Add(DataTable dataTable, string sheetName, string tableName)

Parameters

dataTable DataTable

sheetName string

tableName string

Returns

IXLWorksheet

Add(int)

IXLWorksheet Add(int position)

Parameters

position int

Returns

IXLWorksheet

Add(string)

IXLWorksheet Add(string sheetName)

Parameters

sheetName string

Returns

IXLWorksheet

Add(string, int)

IXLWorksheet Add(string sheetName, int position)

Parameters

sheetName string

position int

Returns

IXLWorksheet

Contains(string)

bool Contains(string sheetName)

Parameters

sheetName string

Returns

bool

Delete(int)

void Delete(int position)

Parameters

position int

Delete(string)

void Delete(string sheetName)

Parameters

sheetName string

Rename(string, string)

void Rename(string oldSheetName, string newSheetName)

Parameters

oldSheetName string

newSheetName string

TryGetWorksheet(string, out IXLWorksheet)

bool TryGetWorksheet(string sheetName, out IXLWorksheet worksheet)

Parameters

sheetName string

worksheet IXLWorksheet

Returns

bool

Worksheet(int)

IXLWorksheet Worksheet(int position)

Parameters

position int

Returns

IXLWorksheet

Worksheet(string)

IXLWorksheet Worksheet(string sheetName)

Parameters

sheetName string

Returns

IXLWorksheet