Partager via


ChartSheetBase.CopyPicture Method

Definition

Copies the ChartSheetBase to the Clipboard as a picture.

public void CopyPicture (Microsoft.Office.Interop.Excel.XlPictureAppearance appearance, Microsoft.Office.Interop.Excel.XlCopyPictureFormat format, Microsoft.Office.Interop.Excel.XlPictureAppearance size);
member this.CopyPicture : Microsoft.Office.Interop.Excel.XlPictureAppearance * Microsoft.Office.Interop.Excel.XlCopyPictureFormat * Microsoft.Office.Interop.Excel.XlPictureAppearance -> unit
Public Sub CopyPicture (Optional appearance As XlPictureAppearance, Optional format As XlCopyPictureFormat, Optional size As XlPictureAppearance)

Parameters

appearance
XlPictureAppearance

Specifies how the picture should be copied.

format
XlCopyPictureFormat

The format of the picture.

size
XlPictureAppearance

The size of the copied picture when the object is a chart on a chart sheet (not embedded on a worksheet).

Examples

The following code example uses the CopyPicture method to copy the current Microsoft.Office.Tools.Excel.ChartSheetBase to the clipboard as a bitmap.

private void CopyChartSheetAsBitmap()
{
    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.xlColumnClustered;

    this.CopyPicture(Excel.XlPictureAppearance.xlScreen,
        Excel.XlCopyPictureFormat.xlBitmap,
        Excel.XlPictureAppearance.xlScreen);
}
Private Sub CopyChartSheetAsBitmap()
    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.xlColumnClustered

    Me.CopyPicture(Excel.XlPictureAppearance.xlScreen, _
        Excel.XlCopyPictureFormat.xlBitmap, _
        Excel.XlPictureAppearance.xlScreen)
End Sub

Remarks

Optional Parameters

For information on optional parameters, see Optional Parameters in Office Solutions.

Applies to