getCell
Description
returns the cell in the open spreadsheet file cell
= getCell(spreadsheet
,row
,column
)spreadsheet
in the
specified row and column.
Examples
Get Value of Cell
Suppose that only one spreadsheet is loaded in the Safety
Analysis Manager. The spreadsheet has two rows and two columns. Retrieve the
Spreadsheet
object of the spreadsheet.
mySpreadsheet = safetyAnalysisMgr.getOpenDocuments;
Retrieve the cell in the second row and the second column.
value = getCell(mySpreadsheet,2,2);
Get Value of Cell with Specified Label
Suppose that only one spreadsheet is loaded in the Safety
Analysis Manager. The spreadsheet has two rows and two columns. The columns are
labeled myColumn
and myOtherColumn
. Retrieve the
Spreadsheet
object of the spreadsheet.
mySpreadsheet = safetyAnalysisMgr.getOpenDocuments;
Retrieve the cell in the second row and the column labeled
myColumn
.
value = getCell(mySpreadsheet,2,"myColumn");
Input Arguments
spreadsheet
— Spreadsheet in Safety Analysis Manager
Spreadsheet
object
Spreadsheet in the Safety Analysis Manager, specified as a
Spreadsheet
object.
row
— Row location of cell
positive integer
Row location of the cell in the spreadsheet, specified as a positive integer. The row index of the topmost row of the spreadsheet is 1
.
Data Types: single
| double
| int8
| int16
| int32
| int64
| uint8
| uint16
| uint32
| uint64
column
— Column location in spreadsheet
positive integer | string scalar | character vector
Column location in the spreadsheet, specified as a positive integer, string scalar, or character vector. Use a positive integer to specify the column index, and use a string scalar or character vector to specify the column by its label. The index starts of leftmost column of the spreadsheet is 1
.
To find the number or columns in the spreadsheet, retrieve the Columns
property of the Spreadsheet
object used in
spreadsheet
. To find the column labels, use the getColumnLabels
function on the Spreadsheet
object.
Data Types: single
| double
| int8
| int16
| int32
| int64
| uint8
| uint16
| uint32
| uint64
| char
| string
Output Arguments
cell
— Cell in spreadsheet
SpreadsheetCell
object
Cell in the spreadsheet, returned as a SpreadsheetCell
object.
Version History
Introduced in R2023b
MATLAB 명령
다음 MATLAB 명령에 해당하는 링크를 클릭했습니다.
명령을 실행하려면 MATLAB 명령 창에 입력하십시오. 웹 브라우저는 MATLAB 명령을 지원하지 않습니다.
Select a Web Site
Choose a web site to get translated content where available and see local events and offers. Based on your location, we recommend that you select: .
You can also select a web site from the following list:
How to Get Best Site Performance
Select the China site (in Chinese or English) for best site performance. Other MathWorks country sites are not optimized for visits from your location.
Americas
- América Latina (Español)
- Canada (English)
- United States (English)
Europe
- Belgium (English)
- Denmark (English)
- Deutschland (Deutsch)
- España (Español)
- Finland (English)
- France (Français)
- Ireland (English)
- Italia (Italiano)
- Luxembourg (English)
- Netherlands (English)
- Norway (English)
- Österreich (Deutsch)
- Portugal (English)
- Sweden (English)
- Switzerland
- United Kingdom (English)