setValue
Description
setValue(
sets the cell in the open spreadsheet file, spreadsheet
,row
,column
,value
)spreadsheet
, in the
specified row and column to the value, value
.
Examples
Set Spreadsheet Value in Specified Row and Column
Suppose that only one spreadsheet is loaded in the Safety
Analysis Manager. Retrieve the Spreadsheet
object of the
spreadsheet.
mySpreadsheet = safetyAnalysisMgr.getOpenDocuments;
Update the value of the cell in the second row and the second column of the
spreadsheet to "my new value"
.
setValue(mySpreadsheet,2,2,"my new value")
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
value
— New cell value
string scalar | character vector | true
(1
) | false
(0
) | enumeration class value
New cell value, specified as a string scalar, character vector, numeric or logical
1
(true
) or 0
(false
), or a value contained in a enumeration class. The value you
can specify depends on the column type:
Column Type | Value |
---|---|
Text | String scalar or character vector |
Check box | Logical true (1 ) or
false (0 ) |
Enumeration | String scalar, character vector, or explicit value specified by an enumeration class |
You cannot set the values of cells in derived columns.
Version History
Introduced in R2023b
MATLAB 命令
您点击的链接对应于以下 MATLAB 命令:
请在 MATLAB 命令行窗口中直接输入以执行命令。Web 浏览器不支持 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)