C# Class Simplexcel.Worksheet

ファイルを表示 Open project: mstum/Simplexcel Class Usage Examples

Public Properties

Property Type Description
InvalidSheetNameChars char[]
MaxSheetNameLength int

Private Properties

Property Type Description

Public Methods

Method Description
Worksheet ( string name ) : System

Create a new Worksheet with the given name
this ( int row, int column ) : Cell

Get the cell with the given zero based row and column, e.g. [0,0] returns the A1 cell. May return NULL.
this ( string address ) : Cell

Get the cell with the given cell reference, e.g. Get the cell "A1". May return NULL.

Method Details

Worksheet() public method

Create a new Worksheet with the given name
public Worksheet ( string name ) : System
name string
return System

this() public method

Get the cell with the given zero based row and column, e.g. [0,0] returns the A1 cell. May return NULL.
public this ( int row, int column ) : Cell
row int
column int
return Cell

this() public method

Get the cell with the given cell reference, e.g. Get the cell "A1". May return NULL.
public this ( string address ) : Cell
address string
return Cell

Property Details

InvalidSheetNameChars public_oe static_oe property

Get a list of characters that are invalid to use in the Sheet Name
These chars are not part of the ECMA-376 standard, but imposed by Excel
public static char[] InvalidSheetNameChars
return char[]

MaxSheetNameLength public_oe static_oe property

Get the maximum allowable length for a sheet name
This limit is not part of the ECMA-376 standard, but imposed by Excel
public static int MaxSheetNameLength
return int