find

Find cells in Safety Analysis Manager spreadsheets containing specific values

Since R2023b

Syntax

cells = find(spreadsheet,value)

cells = find(spreadsheet,value,Name=Value)

Description

cells = find(spreadsheet,value) finds the cells in the Safety Analysis Manager spreadsheet, spreadsheet, that contain the specified value.

cells = find(spreadsheet,value,Name=Value) finds the cells in the spreadsheet using one or more name-value arguments.

Examples

Find Cells that Contain Substring

Suppose you have a spreadsheet file named mySpreadsheet.mldatx. Open the spreadsheet in the Safety Analysis Manager and retrieve the spreadsheet as a Spreadsheet object.

mySpreadsheet = safetyAnalysisMgr.openDocument("mySpreadsheet.mldatx");

Find the cells in the spreadsheet that contain the phrase myText.

myCells = find(mySpreadsheet,"mytext");

Retrieve Cells that Contain Case-Sensitive Substring

Suppose you have a spreadsheet file named mySpreadsheet.mldatx. Open the spreadsheet in the Safety Analysis Manager and retrieve the spreadsheet as a Spreadsheet object.

mySpreadsheet = safetyAnalysisMgr.openDocument("mySpreadsheet.mldatx");

Find the cells in the spreadsheet that contain the case-sensitive phrase myText.

myCells = find(mySpreadsheet,"myText",MatchCase=true);

Input Arguments

spreadsheet — Spreadsheet in Safety Analysis Manager

Spreadsheet object

Spreadsheet in the Safety Analysis Manager, specified as a Spreadsheet object.

value — Value to search for

string scalar | character vector

Value to search for in the spreadsheet cells, specified as a string scalar or a character vector.

Data Types: char | string

Name-Value Arguments

Specify optional pairs of arguments as Name1=Value1,...,NameN=ValueN, where Name is the argument name and Value is the corresponding value. Name-value arguments must appear after other arguments, but the order of the pairs does not matter.

Example: find(spreadsheet,"myValue",MatchCase=true) retrieves spreadsheet cells that have the case-sensitive phrase myValue.

MatchCase — Whether to return only case-sensitive matches

false or 0 (default) | true or 1

Whether to return only case-sensitive matches, specified as a numeric or logical 1 (true) or 0 (false).

Data Types: logical

WholeWord — Whether to return only whole cell content matches

false or 0 (default) | true or 1

Whether to return only whole cell content matches, specified as a numeric or logical 1 (true) or 0 (false).

Data Types: logical

Output Arguments

cells — Spreadsheet cells that contain text

SpreadsheetCell object array

Spreadsheet cells that contain the text in the argument value, returned as a SpreadsheetCell object array.

Limitations

• You cannot use this function to search the contents of check box cells.

Version History

Introduced in R2023b