本文整理汇总了C#中CellRangeAddress类的典型用法代码示例。如果您正苦于以下问题:C#CellRangeAddress类的具体用法?C#CellRangeAddress怎么用?C#CellRangeAddress使用的例子?这里精选的类代码示例或许可以为您提供帮助。
示例1:SetBorderBottom
//[Obsolete]
//publicstaticvoidSetBorderBottom(NPOI.SS.UserModel.CellBorderTypeborder,Regionregion,HSSFSheetsheet,
//HSSFWorkbookworkbook)
//{
//SetBorderBottom(border,toCRA(region),sheet,workbook);
//}
///
///SetstheborderBottomattributeoftheHSSFRegionUtilobject
///
///
Thenewborder
///Theregionthatshouldhavetheborder
///Thesheetthattheregionison.
///Theworkbookthattheregionison.
publicstaticvoidSetBorderBottom(NPOI.SS.UserModel.CellBorderTypeborder,CellRangeAddressregion,HSSFSheetsheet,
HSSFWorkbookworkbook)
{
intcolStart=region.FirstColumn;
intcolEnd=region.LastColumn;
introwIndex=region.LastRow;
CellPropertySettercps=newCellPropertySetter(workbook,HSSFCellUtil.BORDER_BOTTOM,(int)border);
NPOI.SS.UserModel.Rowrow=HSSFCellUtil.GetRow(rowIndex,sheet);
for(inti=colStart;i<=colEnd;i++)
{
cps.SetProperty(row,i);
}
}
原文链接:http://www.jxszl.com/biancheng/C/556702.html