C# Class OfficeOpenXml.ExcelAddressBase

A range address

Examples of addresses are "A1" "B1:C2" "A:A" "1:1" "A1:E2,G3:G5"

Inheritance: ExcelCellBase

Afficher le fichier Open project: pruiz/EPPlus Class Usage Examples

Protected Properties

Свойство	Type	Description
_address	string
_fromRow	int
_wb	string
_ws	string

Private Properties

Свойство	Type	Description
AddColumn	ExcelAddressBase
AddRow	ExcelAddressBase
ChangeAddress	void
Collide	eAddressCollition
DeleteColumn	ExcelAddressBase
DeleteRow	ExcelAddressBase
ExcelAddressBase	System
ExcelAddressBase	System
ExtractAddress	void
IsValid	AddressType
IsValidName	bool
SetAddress	void
SetWbWs	void

Méthodes publiques

Méthode	Description
ExcelAddressBase ( int fromRow, int fromCol, int toRow, int toColumn ) : System	Creates an Address object
ExcelAddressBase ( string address ) : System	Creates an Address object Examples of addresses are "A1" "B1:C2" "A:A" "1:1" "A1:E2,G3:G5"
ToString ( ) : string

Méthodes protégées

Méthode	Description
SetAddress ( string address ) : void
Validate ( ) : void	Validate the address

Private Methods

Méthode	Description
AddColumn ( int col, int cols ) : ExcelAddressBase
AddRow ( int row, int rows ) : ExcelAddressBase
ChangeAddress ( ) : void
Collide ( ExcelAddressBase address ) : eAddressCollition
DeleteColumn ( int col, int cols ) : ExcelAddressBase
DeleteRow ( int row, int rows ) : ExcelAddressBase
ExcelAddressBase ( ) : System
ExcelAddressBase ( string address, bool isName ) : System	Address is an defined name
ExtractAddress ( string fullAddress ) : void
IsValid ( string Address ) : AddressType
IsValidName ( string address ) : bool
SetAddress ( string &first, string &second, bool &hasSheet ) : void
SetWbWs ( string address ) : void

Method Details

ExcelAddressBase() public méthode

Creates an Address object

public ExcelAddressBase ( int fromRow, int fromCol, int toRow, int toColumn ) : System
fromRow	int	start row
fromCol	int	start column
toRow	int	End row
toColumn	int	End column
Résultat	System

ExcelAddressBase() public méthode

Creates an Address object

Examples of addresses are "A1" "B1:C2" "A:A" "1:1" "A1:E2,G3:G5"

public ExcelAddressBase ( string address ) : System
address	string	The Excel Address
Résultat	System

SetAddress() protected méthode

protected SetAddress ( string address ) : void
address	string
Résultat	void

ToString() public méthode

public ToString ( ) : string
Résultat	string

Validate() protected méthode

Validate the address

protected Validate ( ) : void
Résultat	void

Property Details

_address protected_oe property

protected string _address
Résultat	string

_fromRow protected_oe property

protected int _fromRow
Résultat	int

_wb protected_oe property

protected string _wb
Résultat	string

_ws protected_oe property

protected string _ws
Résultat	string