ClearRange(Int32,Int32,Int32,Int32,Boolean,ClipboardCopyOptions) メソッド

このシートのセル範囲からすべてのデータ、書式、数式、およびメモを削除します。

構文

Visual Basic
C#

'Declaration
 
Public Overloads Sub ClearRange( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal rowCount As Integer, _
   ByVal columnCount As Integer, _
   ByVal dataOnly As Boolean, _
   ByVal copyOptions As ClipboardCopyOptions _
)

'使用法
 
Dim instance As SheetView
Dim row As Integer
Dim column As Integer
Dim rowCount As Integer
Dim columnCount As Integer
Dim dataOnly As Boolean
Dim copyOptions As ClipboardCopyOptions
 
instance.ClearRange(row, column, rowCount, columnCount, dataOnly, copyOptions)

public void ClearRange( 
   int row,
   int column,
   int rowCount,
   int columnCount,
   bool dataOnly,
   ClipboardCopyOptions copyOptions
)

パラメータ

row: 範囲の先頭のセルの行インデックス
column: 範囲の先頭のセルの列インデックス
rowCount: 範囲の行数
columnCount: 範囲の列数
dataOnly: データのみを削除するかどうか
copyOptions: ClipboardCopyOptions

例

次のサンプルコードは、範囲をクリアします。

C#
Visual Basic

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)
        {
    fpSpread1.Sheets[0].ClearRange(0, 0, 5, 5, true, FarPoint.Win.Spread.ClipboardCopyOptions.Values);
    //fpSpread1.Sheets[0].ClearRange(0, 0, 5, 5, true);
         }

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
        FpSpread1.Sheets(0).ClearRange(0, 0, 5, 5, True, FarPoint.Win.Spread.ClipboardCopyOptions.Values)
        'FpSpread1.Sheets(0).ClearRange(0, 0, 5, 5, True)
    End Sub

参照

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