ChartSheet.Paste Method
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
'Declaration
Sub Paste ( _
Type As Object _
)
void Paste(
Object Type
)
Parameters
Type
Type: System.ObjectSpecifies 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 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
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.