C# Class KEngine.Editor.ExcelFile

基于NPOI操作Excel文件, 读取，首行是列名

Exibir arquivo Open project: mr-kelly/KEngine Class Usage Examples

Public Properties

Property	Type	Description
ColName2Index	int>.Dictionary
IsLoadSuccess	bool

Public Methods

Method	Description
ClearRow ( int row ) : void	清除行内容
ExcelFile ( string excelPath ) : System
GetFloat ( string columnName, int row ) : float
GetInt ( string columnName, int row ) : int
GetRowsCount ( ) : int
GetString ( string columnName, int row ) : string
Save ( ) : void
SetRow ( string columnName, int row, string value ) : void
SetRowGrey ( int row ) : void

Method Details

ClearRow() public method

清除行内容

public ClearRow ( int row ) : void
row	int
return	void

ExcelFile() public method

public ExcelFile ( string excelPath ) : System
excelPath	string
return	System

GetFloat() public method

public GetFloat ( string columnName, int row ) : float
columnName	string
row	int
return	float

GetInt() public method

public GetInt ( string columnName, int row ) : int
columnName	string
row	int
return	int

GetRowsCount() public method

public GetRowsCount ( ) : int
return	int

GetString() public method

public GetString ( string columnName, int row ) : string
columnName	string
row	int
return	string

Save() public method

public Save ( ) : void
return	void

SetRow() public method

public SetRow ( string columnName, int row, string value ) : void
columnName	string
row	int
value	string
return	void

SetRowGrey() public method

public SetRowGrey ( int row ) : void
row	int
return	void

Property Details

ColName2Index public_oe property

public Dictionary ColName2Index
return	int>.Dictionary

IsLoadSuccess public_oe property

public bool IsLoadSuccess
return	bool