SIMUL8 logo

Match Text in Sheet Area

Quickly search an area of a SIMUL8 spreadsheet and return the location (in column/row coordinates) that exactly matches a text string.

Parameters

  • Sheet location - left/top of the area eg MySheet[5,2] if the area starts at column 5, row 2
  • Columns - Number of columns in the area
  • Rows - Number of rows in the area
  • Text to find – Text string to be found in the sheet area. The text to be found should be put between double quotation marks (e.g. “Find me”).

Alternatively a variable or spreadsheet reference can be used.

  • Returned Column - A data item (global or local) to receive the returned column number of the located cell
  • Returned Row - A data item (global or local) to receive the returned row number of the located cell

If the value is not found then column and row are returned as -1. If the value exists in more than one cell in the area only the first location is returned. SIMUL8 searches each column from the left of the area checking every cell in the left column first, then every cell in the next column etc.

Example

Match Text in Sheet Area MySheet[1,1],10,10,”SIMUL8”,gblColumn, gblRow

This example searches for the text sting “SIMUL8” in the spreadsheet area A1:J10 and returns the cell location using gblColumn (global number) and gblRow (global number).

Related Commands

logo
cleardot