Class SpreadsheetExternal

Inheritance

System.Object

System.MarshalByRefObject

NXRemotableObject

TransientObject

SpreadsheetExternal

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 SpreadsheetExternal : TransientObject, IMessageSink, IDisposable

Constructors

SpreadsheetExternal(IntPtr)

Declaration

protected SpreadsheetExternal(IntPtr ptr)

Parameters

Type	Name	Description
System.IntPtr	ptr

Methods

AddWorksheet(String)

Declaration

public int AddWorksheet(string sheetname)

Parameters

Type	Name	Description
System.String	sheetname

Returns

Type	Description
System.Int32

AppendRow(Int32, SpreadsheetCellData[])

Declaration

public void AppendRow(int worksheet, SpreadsheetCellData[] data)

Parameters

Type	Name	Description
System.Int32	worksheet
SpreadsheetCellData[]	data

AutofitColumns(Int32, Int32, Int32)

Declaration

public void AutofitColumns(int worksheet, int colstart, int colend)

Parameters

Type	Name	Description
System.Int32	worksheet
System.Int32	colstart
System.Int32	colend

CloseFile(Boolean)

Declaration

public void CloseFile(bool save)

Parameters

Type	Name	Description
System.Boolean	save

DeleteColumn(Int32, Int32)

Declaration

public void DeleteColumn(int worksheet, int columnnumber)

Parameters

Type	Name	Description
System.Int32	worksheet
System.Int32	columnnumber

DeleteRange(Int32, Int32, Int32, Int32, Int32)

Declaration

public void DeleteRange(int worksheet, int columnstart, int columnend, int rowstart, int rowend)

Parameters

Type	Name	Description
System.Int32	worksheet
System.Int32	columnstart
System.Int32	columnend
System.Int32	rowstart
System.Int32	rowend

DeleteRow(Int32, Int32)

Declaration

public void DeleteRow(int worksheet, int rownumber)

Parameters

Type	Name	Description
System.Int32	worksheet
System.Int32	rownumber

FreeResource()

Declaration

protected override void FreeResource()

Overrides

TransientObject.FreeResource()

GetNumberofsheets()

Declaration

public int GetNumberofsheets()

Returns

Type	Description
System.Int32

GetWorksheetIndex(String)

Declaration

public int GetWorksheetIndex(string sheetname)

Parameters

Type	Name	Description
System.String	sheetname

Returns

Type	Description
System.Int32

GetWorksheetNames(out String[])

Declaration

public void GetWorksheetNames(out string[] sheetnames)

Parameters

Type	Name	Description
System.String[]	sheetnames

InsertImage(Int32, Int32, Int32, Int32, Int32, String)

Declaration

public void InsertImage(int worksheet, int rowstart, int colstart, int rowend, int colend, string imagepath)

Parameters

Type	Name	Description
System.Int32	worksheet
System.Int32	rowstart
System.Int32	colstart
System.Int32	rowend
System.Int32	colend
System.String	imagepath

MergeCellRange(Int32, Int32, Int32, Int32, Int32)

Declaration

public void MergeCellRange(int worksheet, int rowstart, int colstart, int rowend, int colend)

Parameters

Type	Name	Description
System.Int32	worksheet
System.Int32	rowstart
System.Int32	colstart
System.Int32	rowend
System.Int32	colend

ReadNamedRange(Int32, String, out SpreadsheetCellData[])

Declaration

public void ReadNamedRange(int worksheet, string rangename, out SpreadsheetCellData[] v2)

Parameters

Type	Name	Description
System.Int32	worksheet
System.String	rangename
SpreadsheetCellData[]	v2

ReadRange(Int32, Int32, Int32, Int32, Int32, out SpreadsheetCellData[])

Declaration

public void ReadRange(int worksheet, int rowstart, int colstart, int rowend, int colend, out SpreadsheetCellData[] v2)

Parameters

Type	Name	Description
System.Int32	worksheet
System.Int32	rowstart
System.Int32	colstart
System.Int32	rowend
System.Int32	colend
SpreadsheetCellData[]	v2

ReadSpreadsheetRange(Int32, Int32, Int32, Int32, Int32, out SpreadsheetCellData[])

Declaration

public void ReadSpreadsheetRange(int worksheet, int rowstart, int colstart, int rowend, int colend, out SpreadsheetCellData[] v2)

Parameters

Type	Name	Description
System.Int32	worksheet
System.Int32	rowstart
System.Int32	colstart
System.Int32	rowend
System.Int32	colend
SpreadsheetCellData[]	v2

SaveAs(Int32, String, ExcelFileFormatT)

Declaration

public void SaveAs(int worksheet, string fileName, ExcelFileFormatT fileFormat)

Parameters

Type	Name	Description
System.Int32	worksheet
System.String	fileName
ExcelFileFormatT	fileFormat

SetRangeAlignment(Int32, Int32, Int32, Int32, Int32, AlignmentStyleT, TextAlignmentModeT)

Declaration

public void SetRangeAlignment(int worksheet, int rowstart, int colstart, int rowend, int colend, AlignmentStyleT alignStyle, TextAlignmentModeT alignMode)

Parameters

Type	Name	Description
System.Int32	worksheet
System.Int32	rowstart
System.Int32	colstart
System.Int32	rowend
System.Int32	colend
AlignmentStyleT	alignStyle
TextAlignmentModeT	alignMode

SetRangeBackgroundColor(Int32, Int32, Int32, Int32, Int32, Double[])

Declaration

public void SetRangeBackgroundColor(int worksheet, int rowstart, int colstart, int rowend, int colend, double[] cellBackgroundColor)

Parameters

Type	Name	Description
System.Int32	worksheet
System.Int32	rowstart
System.Int32	colstart
System.Int32	rowend
System.Int32	colend
System.Double[]	cellBackgroundColor

SetRangeBordersProperty(Int32, Int32, Int32, Int32, Int32, Double[], BorderLineStyleT)

Declaration

public void SetRangeBordersProperty(int worksheet, int rowstart, int colstart, int rowend, int colend, double[] cellBorderColor, BorderLineStyleT borderLineStyle)

Parameters

Type	Name	Description
System.Int32	worksheet
System.Int32	rowstart
System.Int32	colstart
System.Int32	rowend
System.Int32	colend
System.Double[]	cellBorderColor
BorderLineStyleT	borderLineStyle

SetRangeFontProperty(Int32, Int32, Int32, Int32, Int32, String, Int32, Double[], Boolean, Boolean, UnderlineStyleT, Boolean, Boolean, Boolean)

Declaration

public void SetRangeFontProperty(int worksheet, int rowstart, int colstart, int rowend, int colend, string fontName, int fontSize, double[] cellFontColor, bool bold, bool italic, UnderlineStyleT underline, bool strikethrough, bool superscript, bool subscript)

Parameters

Type	Name	Description
System.Int32	worksheet
System.Int32	rowstart
System.Int32	colstart
System.Int32	rowend
System.Int32	colend
System.String	fontName
System.Int32	fontSize
System.Double[]	cellFontColor
System.Boolean	bold
System.Boolean	italic
UnderlineStyleT	underline
System.Boolean	strikethrough
System.Boolean	superscript
System.Boolean	subscript

SetSheetTabBackgroundColor(Int32, Double[])

Declaration

public void SetSheetTabBackgroundColor(int worksheet, double[] tabBackgroundColor)

Parameters

Type	Name	Description
System.Int32	worksheet
System.Double[]	tabBackgroundColor

SetWorksheetName(Int32, String)

Declaration

public void SetWorksheetName(int worksheet, string sheetname)

Parameters

Type	Name	Description
System.Int32	worksheet
System.String	sheetname

WriteRange(SpreadsheetCellData[])

Declaration

public void WriteRange(SpreadsheetCellData[] data)

Parameters

Type	Name	Description
SpreadsheetCellData[]	data

WriteSpreadsheetRange(Int32, Int32, Int32, Int32, Int32, SpreadsheetCellData[])

Declaration

public void WriteSpreadsheetRange(int worksheet, int rowstart, int colstart, int rowend, int colend, SpreadsheetCellData[] data)

Parameters

Type	Name	Description
System.Int32	worksheet
System.Int32	rowstart
System.Int32	colstart
System.Int32	rowend
System.Int32	colend
SpreadsheetCellData[]	data

Implements

System.Runtime.Remoting.Messaging.IMessageSink

System.IDisposable