SeriesCollection.Paste(XlRowCol, Object, Object, Object, Object) Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Pastes data from the Clipboard into the specified series collection.
public object Paste (Microsoft.Office.Interop.Excel.XlRowCol Rowcol = (Microsoft.Office.Interop.Excel.XlRowCol) -4105, object SeriesLabels, object CategoryLabels, object Replace, object NewSeries);
Public Function Paste (Optional Rowcol As XlRowCol = (Microsoft.Office.Interop.Excel.XlRowCol) -4105, Optional SeriesLabels As Object, Optional CategoryLabels As Object, Optional Replace As Object, Optional NewSeries As Object) As Object
Parameters
- Rowcol
- 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 defaultxlRows
- SeriesLabels
- 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
- 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
- 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
- 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.
Returns
Applies to
意見反應
https://aka.ms/ContentUserFeedback。
即將登場:在 2024 年,我們將逐步淘汰 GitHub 問題作為內容的意見反應機制,並將它取代為新的意見反應系統。 如需詳細資訊,請參閱:提交並檢視相關的意見反應