Interface IXLSheets

Namespace

SlapKit.Excel.Excel

Assembly

SlapKit.Excel.dll

public interface IXLSheets : IEnumerable<IXLSheet>, IEnumerable

Inherited Members

IEnumerable<IXLSheet>.GetEnumerator()

Extension Methods

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

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

Properties

Chartsheets

IEnumerable<IXLChartsheet> Chartsheets { get; }

Property Value

IEnumerable<IXLChartsheet>

Count

int Count { get; }

Property Value

int

Worksheets

IEnumerable<IXLWorksheet> Worksheets { get; }

Property Value

IEnumerable<IXLWorksheet>

Methods

AddChartsheet()

IXLChartsheet AddChartsheet()

Returns

IXLChartsheet

AddChartsheet(int)

IXLChartsheet AddChartsheet(int position)

Parameters

position int

Returns

IXLChartsheet

AddChartsheet(string)

IXLChartsheet AddChartsheet(string sheetName)

Parameters

sheetName string

Returns

IXLChartsheet

AddChartsheet(string, int)

IXLChartsheet AddChartsheet(string sheetName, int position)

Parameters

sheetName string

position int

Returns

IXLChartsheet

AddWorksheet()

IXLWorksheet AddWorksheet()

Returns

IXLWorksheet

AddWorksheet(DataSet)

void AddWorksheet(DataSet dataSet)

Parameters

dataSet DataSet

AddWorksheet(DataTable)

IXLWorksheet AddWorksheet(DataTable dataTable)

Parameters

dataTable DataTable

Returns

IXLWorksheet

AddWorksheet(DataTable, string)

IXLWorksheet AddWorksheet(DataTable dataTable, string sheetName)

Parameters

dataTable DataTable

sheetName string

Returns

IXLWorksheet

AddWorksheet(DataTable, string, string)

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

Parameters

dataTable DataTable

sheetName string

tableName string

Returns

IXLWorksheet

AddWorksheet(int)

IXLWorksheet AddWorksheet(int position)

Parameters

position int

Returns

IXLWorksheet

AddWorksheet(string)

IXLWorksheet AddWorksheet(string sheetName)

Parameters

sheetName string

Returns

IXLWorksheet

AddWorksheet(string, int)

IXLWorksheet AddWorksheet(string sheetName, int position)

Parameters

sheetName string

position int

Returns

IXLWorksheet

Chartsheet(int)

IXLChartsheet Chartsheet(int position)

Parameters

position int

Returns

IXLChartsheet

Chartsheet(string)

IXLChartsheet Chartsheet(string sheetName)

Parameters

sheetName string

Returns

IXLChartsheet

Contains(string)

bool Contains(string sheetName)

Parameters

sheetName string

Returns

bool

ContainsWorksheet(string)

bool ContainsWorksheet(string worksheetName)

Parameters

worksheetName 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

Sheet(int)

IXLSheet Sheet(int position)

Parameters

position int

Returns

IXLSheet

Sheet(string)

IXLSheet Sheet(string sheetName)

Parameters

sheetName string

Returns

IXLSheet

TryGetChartsheet(string, out IXLChartsheet?)

bool TryGetChartsheet(string sheetName, out IXLChartsheet? chartsheet)

Parameters

sheetName string

chartsheet IXLChartsheet

Returns

bool

TryGetSheet(string, out IXLSheet?)

bool TryGetSheet(string sheetName, out IXLSheet? worksheet)

Parameters

sheetName string

worksheet IXLSheet

Returns

bool

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