SpreadsheetCellData Class

class NXOpen.SpreadsheetCellData

Bases: NXOpen.TransientObject

Represents a class for Spreadsheet cell data.

The data type held in the cell can be obtained from the NXOpen.SpreadsheetCellData.Type(). And then the value can obtained from the correct accessor. The value and type of the cell will be changed when calling the set methods. That is if a cell was a formula, but the NXOpen.SpreadsheetCellData.DoubleValue() is called, the type will be changed as well.

It should be noted the cell value on the sheet will not updated, by calling a set method on this class. The object must then be passed into the appropriate method on NXOpen.SpreadsheetManager. .. Usable only on Windows

New in version NX11.0.0.

Properties

Property Description
DoubleValue Returns or sets the double value stored in the cell.
FormulaValue Returns or sets the formula stored in the cell.
IntValue Returns or sets the integer value stored in the cell.
LogicalValue Returns or sets the logical value stored the cell.
StringValue Returns or sets the string value stored in the cell.
Type Returns or sets the type of data in the cell.

Methods

Method Description
Dispose Free resources associated with the instance.

Enumerations

SpreadsheetCellDataTypes Enumeration Data types enum

Property Detail

DoubleValue

SpreadsheetCellData.DoubleValue

Returns or sets the double value stored in the cell.

-------------------------------------

Getter Method

Signature DoubleValue

Returns:numeric value of the cell
Return type:float

New in version NX11.0.0.

License requirements: None.

-------------------------------------

Setter Method

Signature DoubleValue

Parameters:doubleValue (float) –

New in version NX11.0.0.

License requirements: None.

FormulaValue

SpreadsheetCellData.FormulaValue

Returns or sets the formula stored in the cell.

-------------------------------------

Getter Method

Signature FormulaValue

Returns:formula of the cell
Return type:str

New in version NX11.0.0.

License requirements: None.

-------------------------------------

Setter Method

Signature FormulaValue

Parameters:formulaValue (str) –

New in version NX11.0.0.

License requirements: None.

IntValue

SpreadsheetCellData.IntValue

Returns or sets the integer value stored in the cell.

-------------------------------------

Getter Method

Signature IntValue

Returns:numeric value of the cell
Return type:int

New in version NX11.0.0.

License requirements: None.

-------------------------------------

Setter Method

Signature IntValue

Parameters:intValue (int) –

New in version NX11.0.0.

License requirements: None.

LogicalValue

SpreadsheetCellData.LogicalValue

Returns or sets the logical value stored the cell.

-------------------------------------

Getter Method

Signature LogicalValue

Returns:boolean value of the cell
Return type:bool

New in version NX11.0.0.

License requirements: None.

-------------------------------------

Setter Method

Signature LogicalValue

Parameters:logicalValue (bool) –

New in version NX11.0.0.

License requirements: None.

StringValue

SpreadsheetCellData.StringValue

Returns or sets the string value stored in the cell.

-------------------------------------

Getter Method

Signature StringValue

Returns:sting value of the cell
Return type:str

New in version NX11.0.0.

License requirements: None.

-------------------------------------

Setter Method

Signature StringValue

Parameters:stringValue (str) –

New in version NX11.0.0.

License requirements: None.

Type

SpreadsheetCellData.Type

Returns or sets the type of data in the cell.

-------------------------------------

Getter Method

Signature Type

Returns:Type of value in cell
Return type:NXOpen.SpreadsheetCellDataTypes

New in version NX11.0.0.

License requirements: None.

-------------------------------------

Setter Method

Signature Type

Parameters:cellType (NXOpen.SpreadsheetCellDataTypes) –

New in version NX11.0.0.

License requirements: None.

Method Detail

Dispose

SpreadsheetCellData.Dispose

Free resources associated with the instance.

After this method is called, it is illegal to use the object. In .NET, this method is automatically called when the object is deleted by the garbage collector.

Signature Dispose()

New in version NX11.0.0.

License requirements: None.