Spreadsheet
Description
Spreadsheet
objects represent spreadsheets in the Safety Analysis
Manager. Use Spreadsheet
objects to configure spreadsheets you use
for safety analyses.
Creation
To create a Spreadsheet
object:
Use the
safetyAnalysisMgr.newSpreadsheet
function to create a new spreadsheet in the Safety Analysis Manager.Use the
safetyAnalysisMgr.openDocument
function to open a spreadsheet in the Safety Analysis Manager.Use the
safetyAnalysisMgr.getOpenDocuments
function to retrieve the open spreadsheets in the Safety Analysis Manager.
Properties
Object Functions
addCallback | Add custom callback to Safety Analysis Manager spreadsheets |
addColumn | Add column to spreadsheet in Safety Analysis Manager |
addDocumentAttribute | Add document attribute to spreadsheet in Safety Analysis Manager |
addRow | Add row to spreadsheet in Safety Analysis Manager |
close | Close spreadsheet in Safety Analysis Manager |
clearFlags | Clear flags in Safety Analysis Manager spreadsheet |
deleteCallback | Delete custom callback from Safety Analysis Manager spreadsheets |
deleteColumn | Delete column in spreadsheet in Safety Analysis Manager |
deleteDocumentAttribute | Delete document attributes in spreadsheet in Safety Analysis Manager |
deleteRow | Delete row in spreadsheet in Safety Analysis Manager |
export | Export Safety Analysis Manager spreadsheet to Excel |
getCallback | Retrieve spreadsheet callback code in Safety Analysis Manager |
getCell | Retrieve spreadsheet cells |
getColumnLabels | Retrieve column labels in spreadsheet in Safety Analysis Manager |
getDocumentAttribute | Retrieve document attribute values in spreadsheet in Safety Analysis Manager |
getFlags | Retrieve flags from Safety Analysis Manager spreadsheets |
isCallbackEnabled | Determine whether custom callbacks are enabled |
renameCallback | Rename custom callbacks in Safety Analysis Manager spreadsheets |
renameDocumentAttribute | Rename document attributes in spreadsheets |
runAnalysis | Execute callback script on Safety Analysis Manager spreadsheet |
save | Save spreadsheet in Safety Analysis Manager |
saveTemplate | Save spreadsheet in Safety Analysis Manager as a template |
setCallback | Assign code to Safety Analysis Manager spreadsheet callback |
setColumnFormula | Specify derived column formulas in spreadsheet in Safety Analysis Manager |
setColumnLabel | Adjust column label of spreadsheet in Safety Analysis Manager |
setDocumentAttribute | Set document attributes in spreadsheet in Safety Analysis Manager |
setValue | Write values to spreadsheet cells |
Examples
Version History
Introduced in R2023b