This documentation is archived and is not being maintained.

ChartSheet.Paste Method

Pastes chart data from the Clipboard into the specified Microsoft.Office.Tools.Excel.ChartSheet.

Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel (in microsoft.office.tools.excel.dll)

public virtual void Paste (
	[OptionalAttribute] Object Type
)

Parameters

Type

Specifies the Microsoft.Office.Tools.Excel.ChartSheet 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.

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

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(missing);

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

Show: