SeriesCollection.Paste Method

Pastes data from the Clipboard into the specified series collection.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Function Paste ( _
    Rowcol As XlRowCol, _
    SeriesLabels As Object, _
    CategoryLabels As Object, _
    Replace As Object, _
    NewSeries As Object _
) As Object
'Usage
Dim instance As SeriesCollection
Dim Rowcol As XlRowCol
Dim SeriesLabels As Object
Dim CategoryLabels As Object
Dim Replace As Object
Dim NewSeries As Object
Dim returnValue As Object

returnValue = instance.Paste(Rowcol, SeriesLabels, _
    CategoryLabels, Replace, NewSeries)

Object Paste(
    XlRowCol Rowcol,
    Object SeriesLabels,
    Object CategoryLabels,
    Object Replace,
    Object NewSeries
)

Parameters

• Rowcol
  Type: Microsoft.Office.Interop.Excel.XlRowCol

  Optional XlRowCol. Specifies whether the values corresponding to a particular data series are in rows or columns. Can be one of these XlRowCol constants:

  xlColumns default

  xlRows

• SeriesLabels
  Type: System.Object

  Optional Object. True to use the contents of the cell in the first column of each row (or the first row of each column) as the name of the data series in that row (or column). False to use the contents of the cell in the first column of each row (or the first row of each column) as the first data point in the data series. The default value is False.

• CategoryLabels
  Type: System.Object

  Optional Object. True to use the contents of the first row (or column) of the selection as the categories for the chart. False to use the contents of the first row (or column) as the first data series in the chart. The default value is False.

• Replace
  Type: System.Object

  Optional Object. True to apply categories while replacing existing categories with information from the copied range. False to insert new categories without replacing any old ones. The default value is True.

• NewSeries
  Type: System.Object

  Optional Object. True to paste the data as a new series. False to paste the data as new points in an existing series. The default value is True.

Return Value

Type: System.Object

See Also

Reference

SeriesCollection Interface

SeriesCollection Members

Microsoft.Office.Interop.Excel Namespace