Class Spreadsheet

Inheritance

System.Object

System.MarshalByRefObject

NXRemotableObject

TransientObject

Spreadsheet

Implements

System.Runtime.Remoting.Messaging.IMessageSink

System.IDisposable

Inherited Members

TransientObject.Dispose()

TransientObject.ToString()

TransientObject.PrintTestData(String)

TransientObject.PrintTestData(String, Int32)

TransientObject.Handle

NXRemotableObject.initialize()

NXRemotableObject.SyncProcessMessage(IMessage)

NXRemotableObject.AsyncProcessMessage(IMessage, IMessageSink)

NXRemotableObject.NextSink

System.MarshalByRefObject.CreateObjRef(System.Type)

System.MarshalByRefObject.GetLifetimeService()

System.MarshalByRefObject.InitializeLifetimeService()

System.MarshalByRefObject.MemberwiseClone(System.Boolean)

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

Namespace: NXOpen

Assembly: NXOpen.dll

Syntax

public class Spreadsheet : TransientObject, IMessageSink, IDisposable

Constructors

Spreadsheet(IntPtr)

Declaration

protected Spreadsheet(IntPtr ptr)

Parameters

Type	Name	Description
System.IntPtr	ptr

Methods

Clear()

Declaration

public void Clear()

Delete(Int32, Int32, Int32, Int32)

Declaration

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

Parameters

Type	Name	Description
System.Int32	start1
System.Int32	end1
System.Int32	sheet
System.Int32	operation

DeleteSheets(Int32, Int32)

Declaration

public void DeleteSheets(int sheet, int count)

Parameters

Type	Name	Description
System.Int32	sheet
System.Int32	count

EraseRange(Int32, Int32, Int32, Int32, Int32, Int32)

Declaration

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

Parameters

Type	Name	Description
System.Int32	row0
System.Int32	col0
System.Int32	row1
System.Int32	col1
System.Int32	sheet0
System.Int32	sheet1

EvaluateCell(Int32, Int32, Int32)

Declaration

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

Parameters

Type	Name	Description
System.Int32	row
System.Int32	col
System.Int32	sheet

Returns

Type	Description
SpreadsheetCellData

FreeResource()

Declaration

protected override void FreeResource()

Overrides

TransientObject.FreeResource()

GetFormula(Int32, Int32, Int32)

Declaration

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

Parameters

Type	Name	Description
System.Int32	row
System.Int32	col
System.Int32	sheet

Returns

Type	Description
SpreadsheetCellData

GetNamedRange(String, out Int32[])

Declaration

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

Parameters

Type	Name	Description
System.String	rangename
System.Int32[]	namedrange

GetNumber(Int32, Int32, Int32)

Declaration

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

Parameters

Type	Name	Description
System.Int32	row
System.Int32	col
System.Int32	sheet

Returns

Type	Description
SpreadsheetCellData

GetNumberOfSheets()

Declaration

public int GetNumberOfSheets()

Returns

Type	Description
System.Int32

GetSheetNames(out String[])

Declaration

public void GetSheetNames(out string[] sheetnames)

Parameters

Type	Name	Description
System.String[]	sheetnames

GetSheetNumber()

Declaration

public int GetSheetNumber()

Returns

Type	Description
System.Int32

GetSheetNumberOfName(String)

Declaration

public int GetSheetNumberOfName(string sheetname)

Parameters

Type	Name	Description
System.String	sheetname

Returns

Type	Description
System.Int32

GetString(Int32, Int32, Int32)

Declaration

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

Parameters

Type	Name	Description
System.Int32	row
System.Int32	col
System.Int32	sheet

Returns

Type	Description
SpreadsheetCellData

GetValue(Int32, Int32, Int32)

Declaration

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

Parameters

Type	Name	Description
System.Int32	row
System.Int32	col
System.Int32	sheet

Returns

Type	Description
SpreadsheetCellData

InsertSheets(Int32, Int32)

Declaration

public void InsertSheets(int sheet, int count)

Parameters

Type	Name	Description
System.Int32	sheet
System.Int32	count

Recalculate()

Declaration

public void Recalculate()

Save()

Declaration

public void Save()

SetFormula(Int32, Int32, SpreadsheetCellData, Int32)

Declaration

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

Parameters

Type	Name	Description
System.Int32	row
System.Int32	col
SpreadsheetCellData	cellvalue
System.Int32	sheet

SetNamedRange(String, Int32, Int32, Int32, Int32, Int32)

Declaration

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

Parameters

Type	Name	Description
System.String	rangename
System.Int32	row0
System.Int32	col0
System.Int32	row1
System.Int32	col1
System.Int32	sheet

SetNumber(Int32, Int32, SpreadsheetCellData, Int32)

Declaration

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

Parameters

Type	Name	Description
System.Int32	row
System.Int32	col
SpreadsheetCellData	cellvalue
System.Int32	sheet

SetSheetNumber(Int32)

Declaration

public void SetSheetNumber(int sheet)

Parameters

Type	Name	Description
System.Int32	sheet

SetString(Int32, Int32, SpreadsheetCellData, Int32)

Declaration

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

Parameters

Type	Name	Description
System.Int32	row
System.Int32	col
SpreadsheetCellData	cellvalue
System.Int32	sheet

Terminate()

Declaration

public void Terminate()

Implements

System.Runtime.Remoting.Messaging.IMessageSink

System.IDisposable