Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here.

ChartSheet.CopyPicture Method (2007 System)

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

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel.v9.0 (in Microsoft.Office.Tools.Excel.v9.0.dll)

public 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).

Optional Parameters

For information on optional parameters, see The Variable missing and Optional Parameters in Office Solutions.

The following code example uses the CopyPicture method to copy the current Microsoft.Office.Tools.Excel.ChartSheet 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);
}

Community Additions

ADD
Show:
© 2015 Microsoft