Class Spreadsheet

Inheritance

object

MarshalByRefObject

NXRemotableObject

TransientObject

Spreadsheet

Implements

IMessageSink

IDisposable

Inherited Members

TransientObject.Dispose()

TransientObject.ToString()

TransientObject.PrintTestData(string)

TransientObject.PrintTestData(string, int)

TransientObject.Handle

NXRemotableObject.initialize()

NXRemotableObject.SyncProcessMessage(IMessage)

NXRemotableObject.AsyncProcessMessage(IMessage, IMessageSink)

NXRemotableObject.NextSink

MarshalByRefObject.GetLifetimeService()

MarshalByRefObject.InitializeLifetimeService()

MarshalByRefObject.MemberwiseClone(bool)

object.GetType()

object.MemberwiseClone()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Namespace: NXOpen

Assembly: NXOpen.dll

Syntax

public class Spreadsheet : TransientObject, IMessageSink, IDisposable

Constructors

Spreadsheet(nint)

Declaration

protected Spreadsheet(nint ptr)

Parameters

Type	Name	Description
nint	ptr

Methods

Clear()

Declaration

public void Clear()

Delete(int, int, int, int)

Declaration

public void Delete(int start1, int end1, int sheet, int operation)

Parameters

Type	Name	Description
int	start1
int	end1
int	sheet
int	operation

DeleteSheets(int, int)

Declaration

public void DeleteSheets(int sheet, int count)

Parameters

Type	Name	Description
int	sheet
int	count

EraseRange(int, int, int, int, int, int)

Declaration

public void EraseRange(int row0, int col0, int row1, int col1, int sheet0, int sheet1)

Parameters

Type	Name	Description
int	row0
int	col0
int	row1
int	col1
int	sheet0
int	sheet1

EvaluateCell(int, int, int)

Declaration

public SpreadsheetCellData EvaluateCell(int row, int col, int sheet)

Parameters

Type	Name	Description
int	row
int	col
int	sheet

Returns

Type	Description
SpreadsheetCellData

FreeResource()

Declaration

protected override void FreeResource()

Overrides

TransientObject.FreeResource()

GetFormula(int, int, int)

Declaration

public SpreadsheetCellData GetFormula(int row, int col, int sheet)

Parameters

Type	Name	Description
int	row
int	col
int	sheet

Returns

Type	Description
SpreadsheetCellData

GetNamedRange(string, out int[])

Declaration

public void GetNamedRange(string rangename, out int[] namedrange)

Parameters

Type	Name	Description
string	rangename
int[]	namedrange

GetNumber(int, int, int)

Declaration

public SpreadsheetCellData GetNumber(int row, int col, int sheet)

Parameters

Type	Name	Description
int	row
int	col
int	sheet

Returns

Type	Description
SpreadsheetCellData

GetNumberOfSheets()

Declaration

public int GetNumberOfSheets()

Returns

Type	Description
int

GetSheetNames(out string[])

Declaration

public void GetSheetNames(out string[] sheetnames)

Parameters

Type	Name	Description
string[]	sheetnames

GetSheetNumber()

Declaration

public int GetSheetNumber()

Returns

Type	Description
int

GetSheetNumberOfName(string)

Declaration

public int GetSheetNumberOfName(string sheetname)

Parameters

Type	Name	Description
string	sheetname

Returns

Type	Description
int

GetString(int, int, int)

Declaration

public SpreadsheetCellData GetString(int row, int col, int sheet)

Parameters

Type	Name	Description
int	row
int	col
int	sheet

Returns

Type	Description
SpreadsheetCellData

GetValue(int, int, int)

Declaration

public SpreadsheetCellData GetValue(int row, int col, int sheet)

Parameters

Type	Name	Description
int	row
int	col
int	sheet

Returns

Type	Description
SpreadsheetCellData

InsertSheets(int, int)

Declaration

public void InsertSheets(int sheet, int count)

Parameters

Type	Name	Description
int	sheet
int	count

Recalculate()

Declaration

public void Recalculate()

Save()

Declaration

public void Save()

SetFormula(int, int, SpreadsheetCellData, int)

Declaration

public void SetFormula(int row, int col, SpreadsheetCellData cellvalue, int sheet)

Parameters

Type	Name	Description
int	row
int	col
SpreadsheetCellData	cellvalue
int	sheet

SetNamedRange(string, int, int, int, int, int)

Declaration

public void SetNamedRange(string rangename, int row0, int col0, int row1, int col1, int sheet)

Parameters

Type	Name	Description
string	rangename
int	row0
int	col0
int	row1
int	col1
int	sheet

SetNumber(int, int, SpreadsheetCellData, int)

Declaration

public void SetNumber(int row, int col, SpreadsheetCellData cellvalue, int sheet)

Parameters

Type	Name	Description
int	row
int	col
SpreadsheetCellData	cellvalue
int	sheet

SetSheetNumber(int)

Declaration

public void SetSheetNumber(int sheet)

Parameters

Type	Name	Description
int	sheet

SetString(int, int, SpreadsheetCellData, int)

Declaration

public void SetString(int row, int col, SpreadsheetCellData cellvalue, int sheet)

Parameters

Type	Name	Description
int	row
int	col
SpreadsheetCellData	cellvalue
int	sheet

Terminate()

Declaration

public void Terminate()

Implements

System.Runtime.Remoting.Messaging.IMessageSink

IDisposable