FarPoint.Win.SpreadJ アセンブリ > FarPoint.Win.Spread 名前空間 > SheetView クラス > ClearRange メソッド : ClearRange(Int32,Int32,Int32,Int32,Boolean,ClipboardCopyOptions) メソッド |
'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 )
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