PowerTools SPREAD for Windows Forms 10.0J
ClipboardCopy(CellRange,ClipboardCopyOptions) メソッド


指定したClipboardCopyOptionsを使用して、シートの指定したセル範囲の内容をクリップボードにコピーします。
構文
'Declaration
 
Public Overloads Sub ClipboardCopy( _
   ByVal cellRange As CellRange, _
   ByVal copyOptions As ClipboardCopyOptions _
) 
'使用法
 
Dim instance As SheetView
Dim cellRange As CellRange
Dim copyOptions As ClipboardCopyOptions
 
instance.ClipboardCopy(cellRange, copyOptions)
public void ClipboardCopy( 
   CellRange cellRange,
   ClipboardCopyOptions copyOptions
)

パラメータ

cellRange
copyOptions
次のサンプルコードは、データをコピーします。
private void Form1_Load(object sender, EventArgs e)
        {
       fpSpread1.Sheets[0].Cells[0, 0].Text = "test";
       fpSpread1.Sheets[0].Cells[0, 1].Text = "B";
       fpSpread1.Sheets[0].Cells[0, 2].Text = "C";
       fpSpread1.Sheets[0].Columns[1].Visible = false;          
        }

private void button1_Click(object sender, EventArgs e)
        {
     FarPoint.Win.Spread.Model.CellRange cr = new FarPoint.Win.Spread.Model.CellRange(0, 0, 3, 3);
     fpSpread1.Sheets[0].ClipboardCopy(cr, FarPoint.Win.Spread.ClipboardCopyOptions.All);
         }
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        FpSpread1.Sheets(0).Cells(0, 0).Text = "test"
        FpSpread1.Sheets(0).Cells(0, 1).Text = "B"
        FpSpread1.Sheets(0).Cells(0, 2).Text = "C"
        FpSpread1.Sheets(0).Columns(1).Visible = False
    End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim cr As New FarPoint.Win.Spread.Model.CellRange(0, 0, 3, 3)
        FpSpread1.Sheets(0).ClipboardCopy(cr, FarPoint.Win.Spread.ClipboardCopyOptions.All)
    End Sub
参照

SheetView クラス
SheetView メンバ
オーバーロード一覧

 

 


© 2004-2017, GrapeCity inc. All rights reserved.