Class ExcelWorksheets

Namespace

OfficeOpenXml

Assembly

Magicodes.EPPlus.dll

public class ExcelWorksheets : XmlHelper, IEnumerable<ExcelWorksheet>, IEnumerable, IDisposable

Inheritance

object

XmlHelper

ExcelWorksheets

Implements

IEnumerable<ExcelWorksheet>

IEnumerable

IDisposable

Inherited Members

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Extension Methods

ExtensionMethods.IsNumeric(object)

Properties

Count

public int Count { get; }

Property Value

int

this[int]

public ExcelWorksheet this[int PositionID] { get; }

Parameters

PositionID int

Property Value

ExcelWorksheet

this[string]

public ExcelWorksheet this[string Name] { get; }

Parameters

Name string

Property Value

ExcelWorksheet

Methods

Add(string)

public ExcelWorksheet Add(string Name)

Parameters

Name string

Returns

ExcelWorksheet

Add(string, ExcelWorksheet)

public ExcelWorksheet Add(string Name, ExcelWorksheet Copy)

Parameters

Name string

Copy ExcelWorksheet

Returns

ExcelWorksheet

AddChart(string, eChartType)

public ExcelChartsheet AddChart(string Name, eChartType chartType)

Parameters

Name string

chartType eChartType

Returns

ExcelChartsheet

AddChart(string, eChartType, ExcelPivotTable)

public ExcelChartsheet AddChart(string Name, eChartType chartType, ExcelPivotTable pivotTableSource)

Parameters

Name string

chartType eChartType

pivotTableSource ExcelPivotTable

Returns

ExcelChartsheet

Copy(string, string)

public ExcelWorksheet Copy(string Name, string NewName)

Parameters

Name string

NewName string

Returns

ExcelWorksheet

Delete(ExcelWorksheet)

public void Delete(ExcelWorksheet Worksheet)

Parameters

Worksheet ExcelWorksheet

Delete(int)

public void Delete(int Index)

Parameters

Index int

Delete(string)

public void Delete(string name)

Parameters

name string

Dispose()

public void Dispose()

GetEnumerator()

public IEnumerator<ExcelWorksheet> GetEnumerator()

Returns

IEnumerator<ExcelWorksheet>

MoveAfter(int, int)

public void MoveAfter(int sourcePositionId, int targetPositionId)

Parameters

sourcePositionId int

targetPositionId int

MoveAfter(string, string)

public void MoveAfter(string sourceName, string targetName)

Parameters

sourceName string

targetName string

MoveBefore(int, int)

public void MoveBefore(int sourcePositionId, int targetPositionId)

Parameters

sourcePositionId int

targetPositionId int

MoveBefore(string, string)

public void MoveBefore(string sourceName, string targetName)

Parameters

sourceName string

targetName string

MoveToEnd(int)

public void MoveToEnd(int sourcePositionId)

Parameters

sourcePositionId int

MoveToEnd(string)

public void MoveToEnd(string sourceName)

Parameters

sourceName string

MoveToStart(int)

public void MoveToStart(int sourcePositionId)

Parameters

sourcePositionId int

MoveToStart(string)

public void MoveToStart(string sourceName)

Parameters

sourceName string