如果只是设置背景色为白色,可以先复制一个SheetView,然后设置行列头的背景色,然后打印:
- private void 打印_Click(object sender, EventArgs e)
- {
- FpSpread spread = new FpSpread();
- PrintInfo pi = new PrintInfo();
- pi.Preview = true;
- SheetView view = CopySheet(fpSpread1.ActiveSheet);
- view.ColumnHeader.DefaultStyle.BackColor = Color.White;
- view.RowHeader.DefaultStyle.BackColor = Color.White;
-
- view.PrintInfo = pi;
- spread.Sheets.Add(view);
- spread.PrintSheet(view);
- }
- public FarPoint.Win.Spread.SheetView CopySheet(FarPoint.Win.Spread.SheetView sheet)
- {
- FarPoint.Win.Spread.SheetView newSheet = null;
- if (sheet != null)
- {
- newSheet = FarPoint.Win.Serializer.LoadObjectXml(typeof(SheetView), FarPoint.Win.Serializer.GetObjectXml(sheet, "CopySheet"), "CopySheet") as SheetView;
- newSheet.SheetName = "NewSheet";
- }
- return newSheet;
- }
复制代码 |