此文档主要介绍了通过Spread组件模拟网页Excel效果,并可以实现一些简单的样式设置。
}
//最后一行第一个
FarPoint.Web.Spread.Border borderLastTop = new FarPoint.Web.Spread.Border();
borderLastTop.BorderColorLeft = System.Drawing.Color.FromName(borderColor);
borderLastTop.BorderColorBottom = System.Drawing.Color.FromName(borderColor);
borderLastTop.BorderColorRight = System.Drawing.Color.LightGray;//..........................
borderLastTop.BorderColorTop = System.Drawing.Color.LightGray;//..........................
borderLastTop.BorderStyleTop = BorderStyle.NotSet; //~~~~~~~~~~~~~~~~~~~~~~~~~~ borderLastTop.BorderStyleBottom = BorderStyle.Solid; //~~~~~~~~~~~~~~~~~~~~~~~~~~ borderLastTop.BorderStyleLeft = BorderStyle.Solid; //~~~~~~~~~~~~~~~~~~~~~~~~~~ borderLastTop.BorderStyleRight = BorderStyle.NotSet; //~~~~~~~~~~~~~~~~~~~~~~~~~~ FarPoint.Web.Spread.Cell cLastTop;
cLastTop = FpSpreadText.ActiveSheetView.Cells[rowFarthestIndex, columnindex];
cLastTop.Border = borderLastTop;
//最后一行中间
for (int i = columnindex + 1; i < columnFarthestIndex; i++)
{
FarPoint.Web.Spread.Border borderLastMiddle = new FarPoint.Web.Spread.Border();
borderLastMiddle.BorderColorBottom = System.Drawing.Color.FromName(borderColor); borderLastMiddle.BorderColorLeft = System.Drawing.Color.LightGray;//.......................... borderLastMiddle.BorderColorRight = System.Drawing.Color.LightGray;//.......................... borderLastMiddle.BorderColorTop = System.Drawing.Color.LightGray;//.......................... borderLastMiddle.BorderStyleTop = BorderStyle.NotSet;
borderLastMiddle.BorderStyleBottom = BorderStyle.Solid;
borderLastMiddle.BorderStyleLeft = BorderStyle.NotSet;
borderLastMiddle.BorderStyleRight = BorderStyle.NotSet;
FarPoint.Web.Spread.Cell cLastMiddle;
cLastMiddle = FpSpreadText.ActiveSheetView.Cells[rowFarthestIndex, i];
cLastMiddle.Border = borderLastMiddle;
}
//最后一行最后一个
FarPoint.Web.Spread.Border borderLastLast = new FarPoint.Web.Spread.Border();
borderLastLast.BorderColorRight = System.Drawing.Color.FromName(borderColor);
borderLastLast.BorderColorBottom = System.Drawing.Color.FromName(borderColor);
borderLastLast.BorderColorLeft = System.Drawing.Color.LightGray;//..........................
borderLastLast.BorderColorTop = System.Drawing.Color.LightGray;//..........................
borderLastLast.BorderStyleTop = BorderStyle.NotSet; //~~~~~~~~~~~~~~~~~~~~~~~~~~ borderLastLast.BorderStyleBottom = BorderStyle.Solid; //~~~~~~~~~~~~~~~~~~~~~~~~~~ borderLastLast.BorderStyleLeft = BorderStyle.NotSet; //~~~~~~~~~~~~~~~~~~~~~~~~~~ borderLastLast.BorderStyleRight = BorderStyle.Solid;
FarPoint.Web.Spread.Cell cLastLast;
cLastLast = FpSpreadText.ActiveSheetView.Cells[rowFarthestIndex, columnFarthestIndex];
cLastLast.Border = borderLastLast;
//第一列中间?
FarPoint Spread控件使用_计算机软件及应用_IT/计算机_专业资料。FarPoint Spread WinForm交替背景色 grid1.BackColorStyle = 1 ret = grid1.SetOddEvenRowColor(...
//gcdn.grapecity.com Spread 产品介绍 13 2.2 基本功能介绍 Spread 支持导入和导出 Microsoft Excel 格式的文件,支持 PDF 导出,支持多工作表、跨工作表 公式...
Spread 基本知识(一) ---1 取得当前行号,列号.int row=e.Row; int count=e.Count; 或者: int rowindex = fpSpread1.ActiveSheet.ActiveRowIndex; int column...
FarPoint.Win.Spread.InputMap im; //spdResult是你画面中定义的spread的名字...["基本剂量"] = myItem.BaseDose.ToString(); row["剂量单位"] = myItem...
//gcdn.grapecity.com Spread 产品介终 13 2.2 基本功能介绍 Spread for ...单元格操作 3.1 设置单元格类型 Spread 5 for ASP.NET 支持 16 种单元格...
FarPoint.Win.Spread.InputMap im; //spdResult是你画面中定义的spread的名字...["基本剂量"] = myItem.BaseDose.ToString(); row["剂量单位"] = myItem...
通过设计器(Spread Designer)可以设置 Spread、Sheet、Selected Item 三种 对象的属性,以设计出所需的报表。使用方式是 将该控件拖到窗体中。 如果需要进行数据绑定...
Farpoint使用基础_计算机软件及应用_IT/计算机_专业资料。C#使用spread...["基本剂量"] = myItem.BaseDose.ToString(); row["剂量单位"] = myItem...
FarPoint.Win.Spread.InputMap im; //spdResult是你画面中定义的spread的名字...["基本剂量"] = myItem.BaseDose.ToString(); row["剂量单位"] = myItem...
FarPoint.Win.Spread.InputMap im; //spdResult是你画面中定义的spread的名字...["基本剂量"] = myItem.BaseDose.ToString(); row["剂量单位"] = myItem...
热门文档