spread for .net 常用设置

1.表格的隔行颜色

fpSpread1.Sheets[0].AlternatingRows.Count = 2;
fpSpread1.Sheets[0].AlternatingRows[0].BackColor = Color.GreenYellow ;
fpSpread1.Sheets[0].AlternatingRows[1].BackColor = Color.LightYellow;

2.行选择和选择后的颜色

FpSpread1.ActiveSheetView.OperationMode =  FarPoint.Web.Spread.OperationMode.RowMode;
FpSpread1.ActiveSheetView.SelectionBackColor = Color.Pink

fpSpread1.Sheets[0]指第一个sheet

FpSpread1.ActiveSheetView 指当前所在sheet页