Spread for ASP.NET 打印到 PDF 提供了强大的格式定制功能,这些功能由 PrintInfo 提供,最常见的用例之一就是当 Sheet 中有很多列时怎样把所有列打印到一页。下面就通过代码展示设置方法:
-
- protected void Page_Load(object sender, EventArgs e)
- {
- if (IsPostBack)
- return;
- this.FpSpread1.CommandBar.ShowPDFButton = true;
- this.FpSpread1.Sheets[0].PageSize = 40;
- this.FpSpread1.Sheets[0].ColumnCount = 20;
- this.FpSpread1.Sheets[0].RowCount = 30;
- for (int i = 0; i < 20; i++)
- {
- for (int j = 0; j < 30; j++)
- {
- this.FpSpread1.Sheets[0].Cells[j, i].Text = i.ToString() + "列" + j.ToString() + "行";
- }
- }
- FarPoint.Web.Spread.PrintInfo prinf = new FarPoint.Web.Spread.PrintInfo();
- FarPoint.Web.Spread.SmartPrintRulesCollection prules = new FarPoint.Web.Spread.SmartPrintRulesCollection();
- prules.Add(new FarPoint.Web.Spread.SmartPaperRule(FarPoint.Web.Spread.ResetOption.None));
- prinf.SmartPrintRules = prules;
- prinf.UseSmartPrint = true;
- FpSpread1.ActiveSheetView.PrintInfo = prinf;
- }
复制代码
截图展示:
|
|