C# Class OfficeOpenXml.ExcelAddressBase

A range address

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

Inheritance: ExcelCellBase

Show file Open project: pruiz/EPPlus Class Usage Examples

Protected Properties

Property	Type	Description
_address	string
_fromRow	int
_wb	string
_ws	string

Private Properties

Property	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

Public Methods

Method	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

Protected Methods

Method	Description
SetAddress ( string address ) : void
Validate ( ) : void	Validate the address

Private Methods

Method	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 method

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
return	System

ExcelAddressBase() public method

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
return	System

SetAddress() protected method

protected SetAddress ( string address ) : void
address	string
return	void

ToString() public method

public ToString ( ) : string
return	string

Validate() protected method

Validate the address

protected Validate ( ) : void
return	void

Property Details

_address protected property

protected string _address
return	string

_fromRow protected property

protected int _fromRow
return	int

_wb protected property

protected string _wb
return	string

_ws protected property

protected string _ws
return	string