A collection of cells or regions which are all on the same .
Inheritance
object
- ICollection<WorksheetCell>
- IEnumerable<WorksheetCell>
- ICollection<WorksheetRegion>
- IEnumerable<WorksheetRegion>
- IEnumerable
Constructors
Section titled "Constructors"constructor
public WorksheetReferenceCollection(Worksheet worksheet)Returns WorksheetReferenceCollection
constructor
public WorksheetReferenceCollection(Worksheet worksheet, string references)Returns WorksheetReferenceCollection
constructor
public WorksheetReferenceCollection(WorksheetCell cell)Returns WorksheetReferenceCollection
constructor
public WorksheetReferenceCollection(WorksheetRegion region)Returns WorksheetReferenceCollection
Properties
Section titled "Properties"CellsCount
Section titled "CellsCount"Gets the number of cells contains in all references in this collection.
public int CellsCount { get; }Worksheet
Section titled "Worksheet"Gets the worksheet for which this collection contains references.
public Worksheet Worksheet { get; }Methods
Section titled "Methods"Add(WorksheetCell)
Section titled "Add(WorksheetCell)"Adds a cell to the collection of references.
public void Add(WorksheetCell cell)Parameters
- cell:
WorksheetCell
Returns any
Add(WorksheetRegion)
Section titled "Add(WorksheetRegion)"Adds a region to the collection of references.
public void Add(WorksheetRegion region)Parameters
- region:
WorksheetRegion
Returns any
Add(string)
Section titled "Add(string)"Adds a list of references to the collection of references.
public void Add(string references)Parameters
- references:
string
Returns any
Add(string, CellReferenceMode)
Section titled "Add(string, CellReferenceMode)"Adds a list of references to the collection of references.
public void Add(string references, CellReferenceMode cellReferenceMode)Parameters
- references:
string - cellReferenceMode:
CellReferenceMode
Returns any
Clear()
Section titled "Clear()"Clears all references from the collection.
public void Clear()Returns any
Contains(WorksheetCell)
Section titled "Contains(WorksheetCell)"Determines whether the collection contains the specified cell.
public bool Contains(WorksheetCell cell)Parameters
- cell:
WorksheetCell
Returns any
Contains(WorksheetRegion)
Section titled "Contains(WorksheetRegion)"Determines whether the collection contains the specified region.
public bool Contains(WorksheetRegion region)Parameters
- region:
WorksheetRegion
Returns any
GetEnumerator()
Section titled "GetEnumerator()"Gets an enumerator which returns all and instances in the collection of references.
public IEnumerator GetEnumerator()Returns any
Remove(WorksheetCell)
Section titled "Remove(WorksheetCell)"Removes a cell from the collection of references.
public bool Remove(WorksheetCell cell)Parameters
- cell:
WorksheetCell
Returns any
Remove(WorksheetRegion)
Section titled "Remove(WorksheetRegion)"Removes a region from the collection of references.
public bool Remove(WorksheetRegion region)Parameters
- region:
WorksheetRegion
Returns any
Remove(string)
Section titled "Remove(string)"Removes a list of references from the collection of references.
public bool Remove(string references)Parameters
- references:
string
Returns any
Remove(string, CellReferenceMode)
Section titled "Remove(string, CellReferenceMode)"Removes a list of references from the collection of references.
public bool Remove(string references, CellReferenceMode cellReferenceMode)Parameters
- references:
string - cellReferenceMode:
CellReferenceMode
Returns any
ToString()
Section titled "ToString()"Returns the string value represent the cell and region addresses in the collection.
public override string ToString()Returns any
ToString(CellReferenceMode)
Section titled "ToString(CellReferenceMode)"Returns the string value represent the cell and region addresses in the collection.
public string ToString(CellReferenceMode cellReferenceMode)Parameters
- cellReferenceMode:
CellReferenceMode