Class ExcelWorksheet

Namespace

OfficeOpenXml

Assembly

Magicodes.EPPlus.dll

public class ExcelWorksheet : XmlHelper, IEqualityComparer<ExcelWorksheet>, IDisposable

Inheritance

object

XmlHelper

ExcelWorksheet

Implements

IEqualityComparer<ExcelWorksheet>

IDisposable

Derived

ExcelChartsheet

Inherited Members

object.GetType()

object.MemberwiseClone()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Extension Methods

CalculationExtension.Calculate(ExcelWorksheet)

CalculationExtension.Calculate(ExcelWorksheet, ExcelCalculationOption)

CalculationExtension.Calculate(ExcelWorksheet, string)

CalculationExtension.Calculate(ExcelWorksheet, string, ExcelCalculationOption)

ExtensionMethods.IsNumeric(object)

Constructors

ExcelWorksheet(XmlNamespaceManager, ExcelPackage, string, Uri, string, int, int, eWorkSheetHidden)

public ExcelWorksheet(XmlNamespaceManager ns, ExcelPackage excelPackage, string relID, Uri uriWorksheet, string sheetName, int sheetID, int positionID, eWorkSheetHidden hide)

Parameters

ns XmlNamespaceManager

excelPackage ExcelPackage

relID string

uriWorksheet Uri

sheetName string

sheetID int

positionID int

hide eWorkSheetHidden

Properties

AutoFilterAddress

public ExcelAddressBase AutoFilterAddress { get; }

Property Value

ExcelAddressBase

BackgroundImage

public ExcelBackgroundImage BackgroundImage { get; }

Property Value

ExcelBackgroundImage

Cells

public ExcelRange Cells { get; }

Property Value

ExcelRange

CodeModule

public ExcelVBAModule CodeModule { get; }

Property Value

ExcelVBAModule

Comments

public ExcelCommentCollection Comments { get; }

Property Value

ExcelCommentCollection

ConditionalFormatting

public ExcelConditionalFormattingCollection ConditionalFormatting { get; }

Property Value

ExcelConditionalFormattingCollection

CustomHeight

public bool CustomHeight { get; set; }

Property Value

bool

DataValidations

public ExcelDataValidationCollection DataValidations { get; }

Property Value

ExcelDataValidationCollection

DefaultColWidth

public double DefaultColWidth { get; set; }

Property Value

double

DefaultRowHeight

public double DefaultRowHeight { get; set; }

Property Value

double

Dimension

public ExcelAddressBase Dimension { get; }

Property Value

ExcelAddressBase

Drawings

public ExcelDrawings Drawings { get; }

Property Value

ExcelDrawings

HeaderFooter

public ExcelHeaderFooter HeaderFooter { get; }

Property Value

ExcelHeaderFooter

Hidden

public eWorkSheetHidden Hidden { get; set; }

Property Value

eWorkSheetHidden

Index

public int Index { get; }

Property Value

int

MergedCells

public ExcelWorksheet.MergeCellsCollection MergedCells { get; }

Property Value

ExcelWorksheet.MergeCellsCollection

Name

public string Name { get; set; }

Property Value

string

Names

public ExcelNamedRangeCollection Names { get; }

Property Value

ExcelNamedRangeCollection

OutLineApplyStyle

public bool OutLineApplyStyle { get; set; }

Property Value

bool

OutLineSummaryBelow

public bool OutLineSummaryBelow { get; set; }

Property Value

bool

OutLineSummaryRight

public bool OutLineSummaryRight { get; set; }

Property Value

bool

PivotTables

public ExcelPivotTableCollection PivotTables { get; }

Property Value

ExcelPivotTableCollection

PrinterSettings

public ExcelPrinterSettings PrinterSettings { get; }

Property Value

ExcelPrinterSettings

ProtectedRanges

public ExcelProtectedRangeCollection ProtectedRanges { get; }

Property Value

ExcelProtectedRangeCollection

Protection

public ExcelSheetProtection Protection { get; }

Property Value

ExcelSheetProtection

SelectedRange

public ExcelRange SelectedRange { get; }

Property Value

ExcelRange

SparklineGroups

public ExcelSparklineGroupCollection SparklineGroups { get; }

Property Value

ExcelSparklineGroupCollection

TabColor

public Color TabColor { get; set; }

Property Value

Color

Tables

public ExcelTableCollection Tables { get; }

Property Value

ExcelTableCollection

View

public ExcelWorksheetView View { get; }

Property Value

ExcelWorksheetView

Workbook

public ExcelWorkbook Workbook { get; }

Property Value

ExcelWorkbook

WorksheetXml

public XmlDocument WorksheetXml { get; }

Property Value

XmlDocument

Methods

Column(int)

public ExcelColumn Column(int col)

Parameters

col int

Returns

ExcelColumn

DeleteColumn(int)

public void DeleteColumn(int column)

Parameters

column int

DeleteColumn(int, int)

public void DeleteColumn(int columnFrom, int columns)

Parameters

columnFrom int

columns int

DeleteRow(int)

public void DeleteRow(int row)

Parameters

row int

DeleteRow(int, int)

public void DeleteRow(int rowFrom, int rows)

Parameters

rowFrom int

rows int

DeleteRow(int, int, bool)

public void DeleteRow(int rowFrom, int rows, bool shiftOtherRowsUp)

Parameters

rowFrom int

rows int

shiftOtherRowsUp bool

Dispose()

public void Dispose()

Equals(ExcelWorksheet, ExcelWorksheet)

public bool Equals(ExcelWorksheet x, ExcelWorksheet y)

Parameters

x ExcelWorksheet

y ExcelWorksheet

Returns

bool

GetHashCode(ExcelWorksheet)

public int GetHashCode(ExcelWorksheet obj)

Parameters

obj ExcelWorksheet

Returns

int

GetMergeCellId(int, int)

public int GetMergeCellId(int row, int column)

Parameters

row int

column int

Returns

int

GetValue(int, int)

public object GetValue(int Row, int Column)

Parameters

Row int

Column int

Returns

object

GetValue<T>(int, int)

public T GetValue<T>(int Row, int Column)

Parameters

Row int

Column int

Returns

T

Type Parameters

T

InsertColumn(int, int)

public void InsertColumn(int columnFrom, int columns)

Parameters

columnFrom int

columns int

InsertColumn(int, int, int)

public void InsertColumn(int columnFrom, int columns, int copyStylesFromColumn)

Parameters

columnFrom int

columns int

copyStylesFromColumn int

InsertRow(int, int)

public void InsertRow(int rowFrom, int rows)

Parameters

rowFrom int

rows int

InsertRow(int, int, int)

public void InsertRow(int rowFrom, int rows, int copyStylesFromRow)

Parameters

rowFrom int

rows int

copyStylesFromRow int

Row(int)

public ExcelRow Row(int row)

Parameters

row int

Returns

ExcelRow

Select()

public void Select()

Select(ExcelAddress)

public void Select(ExcelAddress Address)

Parameters

Address ExcelAddress

Select(ExcelAddress, bool)

public void Select(ExcelAddress Address, bool SelectSheet)

Parameters

Address ExcelAddress

SelectSheet bool

Select(string)

public void Select(string Address)

Parameters

Address string

Select(string, bool)

public void Select(string Address, bool SelectSheet)

Parameters

Address string

SelectSheet bool

SetValue(int, int, object)

public void SetValue(int Row, int Column, object Value)

Parameters

Row int

Column int

Value object

SetValue(string, object)

public void SetValue(string Address, object Value)

Parameters

Address string

Value object

ToString()

public override string ToString()

Returns

string