XmlMappedRange.CopyPicture(XlPictureAppearance, XlCopyPictureFormat) Method

Reference

Definition

Namespace:: Microsoft.Office.Tools.Excel

Assembly:: Microsoft.Office.Tools.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Copies the XmlMappedRange control to the Clipboard as a picture.

public object CopyPicture (Microsoft.Office.Interop.Excel.XlPictureAppearance Appearance = Microsoft.Office.Interop.Excel.XlPictureAppearance.xlScreen, Microsoft.Office.Interop.Excel.XlCopyPictureFormat Format = Microsoft.Office.Interop.Excel.XlCopyPictureFormat.xlPicture);

abstract member CopyPicture : Microsoft.Office.Interop.Excel.XlPictureAppearance * Microsoft.Office.Interop.Excel.XlCopyPictureFormat -> obj

Public Function CopyPicture (Optional Appearance As XlPictureAppearance = Microsoft.Office.Interop.Excel.XlPictureAppearance.xlScreen, Optional Format As XlCopyPictureFormat = Microsoft.Office.Interop.Excel.XlCopyPictureFormat.xlPicture) As Object

Parameters

Appearance: XlPictureAppearance

Specifies how the picture should be copied.Can be one of the following XlPictureAppearance constants: xlPrinter xlScreen

Format: XlCopyPictureFormat

The format of the picture.Can be one of the following XlCopyPictureFormat constants: xlBitmap xlPicture

Returns

Object

Examples

The following code example uses the CopyPicture method to copy an XmlMappedRange to the Clipboard as a bitmap. This code example assumes that the current worksheet contains an XmlMappedRange named CustomerLastNameCell.

private void CopyAsBitmap()
{
    this.CustomerLastNameCell.Value2 = "Smith";
    this.CustomerLastNameCell.CopyPicture(
        Excel.XlPictureAppearance.xlScreen, 
        Excel.XlCopyPictureFormat.xlBitmap);
}

Private Sub CopyAsBitmap()
    Me.CustomerLastNameCell.Value2 = "Smith"
    Me.CustomerLastNameCell.CopyPicture( _
        Excel.XlPictureAppearance.xlScreen, Excel.XlCopyPictureFormat.xlBitmap)
End Sub

Remarks

Optional Parameters

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

Applies to