ChartSheet.CopyPicture Method
Visual Studio 2012
Copies the Microsoft.Office.Tools.Excel.ChartSheet to the Clipboard as a picture.
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)
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 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); }
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.
