This topic has not yet been rated - Rate this topic

ChartSheet.Paste Method

Visual Studio 2012

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

Namespace: Microsoft.Office.Tools.Excel
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)

Syntax

void Paste(
	Object Type
)

Parameters

Type: Type: Object
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.

Examples

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

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

.NET Framework Security

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.

Reference

ChartSheet Interface

Microsoft.Office.Tools.Excel Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)