C# Class Ywdsoft.Utility.Excel.NPOIExtend

NPOI拓展方法

Datei anzeigen Open project: CrazyJson/TaskManager

Public Methods

Method	Description
FreezePane ( this sheet, int colCount, int rowCount, int startCol, int startRow ) : void	冻结表格
GetXLColour ( this workbook, int R, int G, int B ) : short	获取RGB对应NPOI颜色值

Method Details

FreezePane() public static method

冻结表格

public static FreezePane ( this sheet, int colCount, int rowCount, int startCol, int startRow ) : void
sheet	this	sheet
colCount	int	冻结的列数
rowCount	int	冻结的行数
startCol	int	右边区域可见的首列序号，从1开始计算
startRow	int	下边区域可见的首行序号，也是从1开始计算
return	void

GetXLColour() public static method

获取RGB对应NPOI颜色值

public static GetXLColour ( this workbook, int R, int G, int B ) : short
workbook	this	当前wb
R	int
G	int
B	int
return	short