SetCell Method (Python)
.SetCell(cell). Sets the value for the cell specified
by the currently selected set of category values. The argument cell is
the value, specified as a CellText object
(one of CellText.Number
, CellText.String
, CellText.VarName
,
or CellText.VarValue
). Category values are selected
using the SetCategories method as shown in the following
example.
Example
table = spss.BasePivotTable("Table Title",
"OMS table subtype")
rowdim = table.Append(spss.Dimension.Place.row,"rowdim")
coldim = table.Append(spss.Dimension.Place.column,"coldim")
# Define category values and set the currently selected set of
# category values to "row1" for rowdim and "column1" for coldim.
table.SetCategories(rowdim,spss.CellText.String("row1"))
table.SetCategories(coldim,spss.CellText.String("column1"))
# Set the value for the current cell specified by the currently
# selected set of category values.
table.SetCell(spss.CellText.Number(11))
table.SetCategories(rowdim,spss.CellText.String("row2"))
table.SetCategories(coldim,spss.CellText.String("column2"))
# Set the value for the current cell. Its category values are "row2"
# for rowdim and "column2" for coldim.
table.SetCell(spss.CellText.Number(22))
# Set the currently selected category to "row1" for rowdim.
table.SetCategories(rowdim,spss.CellText.String("row1"))
# Set the value for the current cell. Its category values are "row1"
# for rowdim and "column2" for coldim.
table.SetCell(spss.CellText.Number(12))
- In this example, Number objects are used to specify numeric values
for the cells. Values will be formatted using the table's default
format. Instances of the
BasePivotTable
class have an implicit default format ofGeneralStat
. You can change the default format using the SetDefaultFormatSpec method, or you can override the default by explicitly specifying the format, as in:CellText.Number(22,spss.FormatSpec.Correlation)
. See the topic Number Class (Python) for more information.
