Partager via

ChartSheetBase.Paste(Object) Method

  • Reference

Definition

Namespace:
Microsoft.Office.Tools.Excel
Assembly:
Microsoft.Office.Tools.Excel.v4.0.Utilities.dll

Pastes chart data from the Clipboard into the specified ChartSheetBase.

public void Paste (object type);
member this.Paste : obj -> unit
Public Sub Paste (Optional type As Object)

Parameters

type
Object

Specifies the ChartSheetBase information to paste if a chart is on the Clipboard. Can be one of the following XlPasteType constants: xlPasteFormats, xlPasteFormulas, or xlPasteAll. The default value is xlPasteAll. If there is data other than a chart on the Clipboard, this argument cannot be used.

Examples

The following code example uses the Paste method to paste additional range data from the Clipboard into the current Microsoft.Office.Tools.Excel.ChartSheetBase.

private void PasteIntoChartSheet()
{
    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.xl3DColumn;

    // Set additional range values and copy them to the Clipboard.
    Globals.Sheet1.Range["A6", "A10"].Value2 = 11;
    Globals.Sheet1.Range["B6", "B10"].Value2 = 33;
    Globals.Sheet1.Range["A6", "B10"].Copy();

    // Paste the contents of the Clipboard into the chart.
    this.Paste();
}

Private Sub PasteIntoChartSheet()
    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.xl3DColumn

    ' Set additional range values and copy them to the Clipboard.
    Globals.Sheet1.Range("A6", "A10").Value2 = 11
    Globals.Sheet1.Range("B6", "B10").Value2 = 33
    Globals.Sheet1.Range("A6", "B10").Copy()

    ' Paste the contents of the Clipboard into the chart.
    Me.Paste()
End Sub

Applies to