Partager via

ChartSheetBase.PrintPreview(Object) Method

  • Reference

Definition

Namespace:
Microsoft.Office.Tools.Excel
Assembly:
Microsoft.Office.Tools.Excel.v4.0.Utilities.dll

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

public void PrintPreview (object enableChanges);
member this.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.ChartSheetBase.

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