Udostępnij za pośrednictwem

ChartSheet.PrintPreview(Object) Method

  • Reference

Definition

Namespace:
Microsoft.Office.Tools.Excel
Assemblies:
Microsoft.Office.Tools.Excel.dll, Microsoft.Office.Tools.Excel.v4.0.Utilities.dll

Shows a preview of the ChartSheet as it would look when printed.

public void PrintPreview (object EnableChanges);
abstract member PrintPreview : obj -> unit
Public Sub PrintPreview (Optional EnableChanges As Object)

Parameters

EnableChanges
Object

Examples

The following code example uses the PrintPreview method to preview the printout of the current Microsoft.Office.Tools.Excel.ChartSheet.

private void PreviewChartSheet()
{
    Globals.Sheet1.Range["A1", "A5"].Value2 = 22;
    Globals.Sheet1.Range["B1", "B5"].Value2 = 55;

    this.SetSourceData(Globals.Sheet1.Range["A1", "B5"],
        Excel.XlRowCol.xlColumns);
    this.ChartType = Excel.XlChartType.xl3DColumn;

    this.PrintPreview(false);
}

Private Sub PreviewChartSheet()
    Globals.Sheet1.Range("A1", "A5").Value2 = 22
    Globals.Sheet1.Range("B1", "B5").Value2 = 55

    Me.SetSourceData(Globals.Sheet1.Range("A1", "B5"), _
        Excel.XlRowCol.xlColumns)
    Me.ChartType = Excel.XlChartType.xl3DColumn
    Me.PrintPreview(False)
End Sub

Applies to