SpreadsheetCell

Cell in spreadsheet in Safety Analysis Manager

Since R2023b

Description

SpreadsheetCell objects represent cells in spreadsheets in the Safety Analysis Manager. Use SpreadsheetCell objects to configure spreadsheet cell properties you use in safety analyses.

Creation

To create a SpreadsheetCell object, use the getCell function on a Spreadsheet object.

Properties

Row — Row location of cell

positive integer

This property is read-only.

Row location of the cell in the spreadsheet, returned as a positive integer. The column index of the leftmost column of the spreadsheet is 1.

Data Types: uint64

Column — Column location of cell

positive integer

This property is read-only.

Column location of the cell in the spreadsheet, returned as a positive integer. The row index of the topmost row of the spreadsheet is 1.

Data Types: uint64

ColumnLabel — Label of column

string scalar | character vector

This property is read-only.

Label of the column in the spreadsheet that contains the cell, returned as a character vector.

Data Types: char

Value — Cell value

string scalar | character vector | true (1) | false (0) | enumeration class value

Cell value, specified as these types, depending on the column type:

Column Type	Value Type	See
Text	String scalar or character vector	Add Rows and Columns to a Spreadsheet
Check Box	Logical true (1) or false (0)	Create a Check Box Column
Enumeration	String scalar, character vector, or explicit value specified by an enumeration class	Create an Enumeration Column and Add Enumeration Type Column
Derived	String scalar derived from the output of the column formula	Create a Derived Column That Outputs Based on Two Column Values

Data Types: char | string

Description — Cell description

'' (default) | string scalar | character vector

Cell description, specified as a string scalar or character vector.

Data Types: char | string

Object Functions

addFlag	Add flag to Safety Analysis Manager cell
clearFlags	Clear flags in Safety Analysis Manager spreadsheet
getFlags	Retrieve flags from Safety Analysis Manager spreadsheets
getLinks	Get links associated with spreadsheet cell in Safety Analysis Manager
getSpreadsheet	Retrieve spreadsheet containing specified cell

Examples

Assign Value in Specified Cell of Spreadsheet

Suppose that only one spreadsheet is loaded in the Safety Analysis Manager. Retrieve the Spreadsheet object of the spreadsheet.

mySpreadsheet = safetyAnalysisMgr.getOpenDocuments;

Retrieve the cell in the second row and the second column of the spreadsheet as a SpreadsheetCell object.

myCell = getCell(mySpreadsheet,2,2);

Set the cell value to This is a value.

myCell.Value = "This is a value";

Version History

Introduced in R2023b