getSpreadsheet

Retrieve spreadsheet containing specified cell

Since R2024a

Syntax

spreadsheet = getSpreadsheet(spreadsheetCell)

spreadsheet = getSpreadsheet(spreadsheetRow)

Description

spreadsheet = getSpreadsheet(spreadsheetCell) returns the spreadsheet that contains the specified spreadsheet cell.

spreadsheet = getSpreadsheet(spreadsheetRow) returns the spreadsheet that contains the specified spreadsheet row. (since R2024b)

Examples

Retrieve Safety Analysis Manager Spreadsheet

Suppose that you have a spreadsheet cell, myCell, but you do not know what spreadsheet includes the cell. To retrieve the spreadsheet, use getSpreadsheet and the name of the SpreadsheetCell object.

mySpreadsheet = getSpreadheet(myCell)

mySpreadsheet = 

  Spreadsheet with properties:

       FileName: ''
           Rows: 2
        Columns: 2
    Description: ''

Retrieve Spreadsheet from Row

Suppose that you have a spreadsheet row, myRow, but you do not know what spreadsheet includes the row. To retrieve the spreadsheet, use getSpreadsheet and the name of the SpreadsheetRow object.

mySpreadsheet = getSpreadheet(myRow)

mySpreadsheet = 

  Spreadsheet with properties:

       FileName: ''
           Rows: 2
        Columns: 2
    Description: ''

Input Arguments

spreadsheetCell — Cell in Safety Analysis Manager

SpreadsheetCell object

Cell in the Safety Analysis Manager spreadsheet, specified as a SpreadsheetCell object.

spreadsheetRow — Row in Safety Analysis Manager spreadsheet

SpreadsheetRow object

Since R2024b

Row in the Safety Analysis Manager spreadsheet, specified as a SpreadsheetRow object.

Output Arguments

spreadsheet — Spreadsheet in Safety Analysis Manager

Spreadsheet object

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

Version History

Introduced in R2024a