今天我试了一下,如果直接调用 this.fpSpread1.PrintSheet(fpSpread1.ActiveSheet); 打印出的效果就能满足,我猜是直接调用的Excel模板的设置,然后我手动的设置下,外边框很粗,没设边框的单元格也打印出了淡淡的线,怎么才能实现直接调用 this.fpSpread1.PrintSheet(fpSpread1.ActiveSheet); 的效果呢,我的代码如下,我加载的Excel模板
FarPoint.Win.Spread.PrintInfo pi = new FarPoint.Win.Spread.PrintInfo();
//显示打印对话框,设置打印机、纸张、横行、纵向
pi.ShowPrintDialog = true;
//打印预览
pi.Preview = true;
//pi.ShowBorder = false;
pi.ShowColor = false;
//打印的标题
// pi.Header = "abcdefg";
//不打印行的"1,2,3,4"行号
//不打印列的“A,B,C,D”列号
pi.ShowColumnHeader = PrintHeader.Hide;
pi.ShowRowHeader = PrintHeader.Hide;
pi.PaperSize = new System.Drawing.Printing.PaperSize("A4", 826, 1169);
// pi.ShowShadows = false;
// 设置纸张的打印方向
pi.Margin.Left = 1;
pi.Margin.Top = 1;
pi.Opacity = 0;
//fpSpread1.ActiveSheet.HorizontalGridLine = new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.None);
//fpSpread1.ActiveSheet.VerticalGridLine = new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.None);
//要打印的工作簿
fpSpread1.ActiveSheet.PrintInfo = pi;
this.fpSpread1.PrintSheet(fpSpread1.ActiveSheet); |
|