Represents a class for Spreadsheet cell data. More...

Inheritance diagram for NXOpen.SpreadsheetCellData:

Public Types
enum	Types { Int, Double, String, Logical, Formula }
	Data types enum More...

Protected Member Functions
override void	FreeResource ()
	Free resources associated with the instance. More...

Properties
unsafe double	DoubleValue `[get, set]`
	Returns or sets the double value stored in the cell. More...

unsafe string	FormulaValue `[get, set]`
	Returns or sets the formula stored in the cell. More...

unsafe int	IntValue `[get, set]`
	Returns or sets the integer value stored in the cell. More...

unsafe bool	LogicalValue `[get, set]`
	Returns or sets the logical value stored the cell. More...

unsafe string	StringValue `[get, set]`
	Returns or sets the string value stored in the cell. More...

unsafe NXOpen.SpreadsheetCellData.Types	Type `[get, set]`
	Returns or sets the type of data in the cell. More...

Properties inherited from NXOpen.TransientObject
IntPtr	Handle `[get]`
	Handle of the internal object represented by this object. More...

Properties inherited from NXOpen.Utilities.NXRemotableObject
IMessageSink	NextSink `[get]`
	Gets the next message sink in the sink chain. More...

Additional Inherited Members
Public Member Functions inherited from NXOpen.TransientObject
void	Dispose ()
	Frees the object from memory. More...

void	PrintTestData (String variableName)
	<exclude> More...

void	PrintTestData (String variableName, int lineNumber)
	<exclude> More...

new string	ToString ()
	Returns a String that represents the current Object. More...

Detailed Description

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

Created in NX11.0.0

Member Enumeration Documentation

enum NXOpen.SpreadsheetCellData.Types

Data types enum

Enumerator
Int
Double
String
Logical
Formula

Member Function Documentation

override void NXOpen.SpreadsheetCellData.FreeResource ( )

inlineprotectedvirtual

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.

Created in NX11.0.0

License requirements: None.

Implements NXOpen.TransientObject.

Property Documentation

unsafe double NXOpen.SpreadsheetCellData.DoubleValue

getset

Returns or sets the double value stored in the cell.

Created in NX11.0.0