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