Previous topicNext topic
Help > 开发指南 > Excel > API > 示例 > Chart图表 >
如何：指定图表工作表打印选项

此示例演示如何使用 ChartSheet.ActiveView 属性返回的 ChartSheetView 对象的属性设置图表工作表的打印选项。使用此对象可以设置页面方向、页边距和纸张大小。

使用 ChartSheet.PrintOptions 属性指定其他打印选项。

Vb.Net 
'创建包含饼图的图表工作表
Dim chartSheet As DevExpress.Spreadsheet.ChartSheet = workbook.ChartSheets.Add(DevExpress.Spreadsheet.Charts.ChartType.Pie, worksheet("B2:C7"))

'指定打印设置。
chartSheet.ActiveView.Orientation = DevExpress.Spreadsheet.PageOrientation.Landscape
chartSheet.ActiveView.PaperKind = DevExpress.Drawing.Printing.DXPaperKind.Letter

'指定页边距。
workbook.Unit = DevExpress.Office.DocumentUnit.Inch
Dim pageMargins As DevExpress.Spreadsheet.Margins = chartSheet.ActiveView.Margins
pageMargins.Left = 0.7F
pageMargins.Top = 0.75F
pageMargins.Right = 0.7F
pageMargins.Bottom = 0.75F

C#
// 创建包含饼图的图表工作表
DevExpress.Spreadsheet.ChartSheet chartSheet = workbook.ChartSheets.Add(DevExpress.Spreadsheet.Charts.ChartType.Pie, worksheet["B2:C7"]);

// 指定打印设置。
chartSheet.ActiveView.Orientation = DevExpress.Spreadsheet.PageOrientation.Landscape;
chartSheet.ActiveView.PaperKind = DevExpress.Drawing.Printing.DXPaperKind.Letter;

// 指定页边距。
workbook.Unit = DevExpress.Office.DocumentUnit.Inch;
DevExpress.Spreadsheet.Margins pageMargins = chartSheet.ActiveView.Margins;
pageMargins.Left = 0.7F;
pageMargins.Top = 0.75F;
pageMargins.Right = 0.7F;
pageMargins.Bottom = 0.75F;