Interface IExcelWorkbook

Inherited Members
Namespace: LemonEdge.Document.Core
Assembly: LemonEdge.Document.Core.dll
Syntax
public interface IExcelWorkbook : IDisposable

Properties

ActiveSheet

Declaration
IExcelSheet ActiveSheet { get; set; }
Property Value
Type Description
IExcelSheet

Methods

AddName(string, string, int, int, int, int)

Declaration
void AddName(string name, string sheetName, int fromRow, int fromCol, int toRow, int toCol)
Parameters
Type Name Description
string name
string sheetName
int fromRow
int fromCol
int toRow
int toCol

DeleteName(string)

Declaration
void DeleteName(string name)
Parameters
Type Name Description
string name

EndBulkUpdates()

Declaration
void EndBulkUpdates()

GetSheet(string)

Declaration
IExcelSheet GetSheet(string name)
Parameters
Type Name Description
string name
Returns
Type Description
IExcelSheet

GetSheets()

Declaration
IEnumerable<IExcelSheet> GetSheets()
Returns
Type Description
IEnumerable<IExcelSheet>

HasName(string)

Declaration
bool HasName(string name)
Parameters
Type Name Description
string name
Returns
Type Description
bool

HasSheet(string)

Declaration
bool HasSheet(string name)
Parameters
Type Name Description
string name
Returns
Type Description
bool

MoveSheet(IExcelSheet, int)

Declaration
void MoveSheet(IExcelSheet sht, int newIndex)
Parameters
Type Name Description
IExcelSheet sht
int newIndex

StartBulkUpdates()

Declaration
void StartBulkUpdates()

TryGetCellFromReference(string, out string, out int, out int)

Declaration
bool TryGetCellFromReference(string cellReference, out string sheetName, out int row, out int col)
Parameters
Type Name Description
string cellReference
string sheetName
int row
int col
Returns
Type Description
bool

Extension Methods