ChartSheet.CopyPicture Method

  • Article

Copies the Microsoft.Office.Tools.Excel.ChartSheet to the Clipboard as a picture.

Namespace:  Microsoft.Office.Tools.Excel
Assemblies:   Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)
  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

Syntax

'Declaration
Sub CopyPicture ( _
    Appearance As XlPictureAppearance, _
    Format As XlCopyPictureFormat, _
    Size As XlPictureAppearance _
)

void CopyPicture(
    XlPictureAppearance Appearance,
    XlCopyPictureFormat Format,
    XlPictureAppearance Size
)

Parameters

  • Appearance
    Type: XlPictureAppearance

    Specifies how the picture should be copied.

  • Format
    Type: XlCopyPictureFormat

    The format of the picture.

  • Size
    Type: XlPictureAppearance

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

Remarks

Optional Parameters

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

Examples

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

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

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);
}

.NET Framework Security

See Also

Reference

ChartSheet Interface

Microsoft.Office.Tools.Excel Namespace