FarPoint.Win.Spread アセンブリ > FarPoint.Win.Spread 名前空間 > FpSpread クラス > SearchHeaders メソッド : SearchHeaders(Int32,String,Boolean,Int32,Int32) メソッド |
'宣言
Public Overloads Function SearchHeaders( _ ByVal sheetIndex As Integer, _ ByVal searchString As String, _ ByVal searchRowHeaders As Boolean, _ ByRef foundRowIndex As Integer, _ ByRef foundColumnIndex As Integer _ ) As SearchFoundFlags
public SearchFoundFlags SearchHeaders( int sheetIndex, string searchString, bool searchRowHeaders, ref int foundRowIndex, ref int foundColumnIndex )
また、foundRowIndex と foundColumnIndex は、文字列が見つかったセルの行インデックスおよび列インデックスを返します。
// Form Load fpSpread1.Sheets[0].RowHeader.Cells[0, 0].Text = "test"; private void button1_Click(object sender, System.EventArgs e) { int x = 0; int y = 0; FarPoint.Win.Spread.SearchFoundFlags sff; sff = fpSpread1.SearchHeaders(0, "test", true, ref x, ref y); listBox1.Items.Add(sff.ToString()); listBox1.Items.Add(x.ToString()); listBox1.Items.Add(y.ToString()); }
' Form Load FpSpread1.Sheets(0).RowHeader.Cells(0, 0).Text = "test" Dim x As Integer Dim y As Integer Dim sff As FarPoint.Win.Spread.SearchFoundFlags sff = FpSpread1.SearchHeaders(0, "test", True, x, y) ListBox1.Items.Add(sff.ToString()) ListBox1.Items.Add(x) ListBox1.Items.Add(y)