Class SpreadsheetExternal

Inheritance

object

MarshalByRefObject

NXRemotableObject

TransientObject

SpreadsheetExternal

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

Constructors

SpreadsheetExternal(nint)

Declaration

protected SpreadsheetExternal(nint ptr)

Parameters

Type	Name	Description
nint	ptr

Methods

AddWorksheet(string)

Declaration

public int AddWorksheet(string sheetname)

Parameters

Type	Name	Description
string	sheetname

Returns

Type	Description
int

AppendRow(int, SpreadsheetCellData[])

Declaration

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

Parameters

Type	Name	Description
int	worksheet
SpreadsheetCellData[]	data

AutofitColumns(int, int, int)

Declaration

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

Parameters

Type	Name	Description
int	worksheet
int	colstart
int	colend

CloseFile(bool)

Declaration

public void CloseFile(bool save)

Parameters

Type	Name	Description
bool	save

DeleteColumn(int, int)

Declaration

public void DeleteColumn(int worksheet, int columnnumber)

Parameters

Type	Name	Description
int	worksheet
int	columnnumber

DeleteRange(int, int, int, int, int)

Declaration

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

Parameters

Type	Name	Description
int	worksheet
int	columnstart
int	columnend
int	rowstart
int	rowend

DeleteRow(int, int)

Declaration

public void DeleteRow(int worksheet, int rownumber)

Parameters

Type	Name	Description
int	worksheet
int	rownumber

FreeResource()

Declaration

protected override void FreeResource()

Overrides

TransientObject.FreeResource()

GetNumberofsheets()

Declaration

public int GetNumberofsheets()

Returns

Type	Description
int

GetWorksheetIndex(string)

Declaration

public int GetWorksheetIndex(string sheetname)

Parameters

Type	Name	Description
string	sheetname

Returns

Type	Description
int

GetWorksheetNames(out string[])

Declaration

public void GetWorksheetNames(out string[] sheetnames)

Parameters

Type	Name	Description
string[]	sheetnames

InsertImage(int, int, int, int, int, string)

Declaration

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

Parameters

Type	Name	Description
int	worksheet
int	rowstart
int	colstart
int	rowend
int	colend
string	imagepath

MergeCellRange(int, int, int, int, int)

Declaration

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

Parameters

Type	Name	Description
int	worksheet
int	rowstart
int	colstart
int	rowend
int	colend

ReadNamedRange(int, string, out SpreadsheetCellData[])

Declaration

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

Parameters

Type	Name	Description
int	worksheet
string	rangename
SpreadsheetCellData[]	v2

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

Declaration

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

Parameters

Type	Name	Description
int	worksheet
int	rowstart
int	colstart
int	rowend
int	colend
SpreadsheetCellData[]	v2

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

Declaration

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

Parameters

Type	Name	Description
int	worksheet
int	rowstart
int	colstart
int	rowend
int	colend
SpreadsheetCellData[]	v2

SaveAs(int, string, ExcelFileFormatT)

Declaration

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

Parameters

Type	Name	Description
int	worksheet
string	fileName
ExcelFileFormatT	fileFormat

SetRangeAlignment(int, int, int, int, int, AlignmentStyleT, TextAlignmentModeT)

Declaration

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

Parameters

Type	Name	Description
int	worksheet
int	rowstart
int	colstart
int	rowend
int	colend
AlignmentStyleT	alignStyle
TextAlignmentModeT	alignMode

SetRangeBackgroundColor(int, int, int, int, int, double[])

Declaration

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

Parameters

Type	Name	Description
int	worksheet
int	rowstart
int	colstart
int	rowend
int	colend
double[]	cellBackgroundColor

SetRangeBordersProperty(int, int, int, int, int, double[], BorderLineStyleT)

Declaration

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

Parameters

Type	Name	Description
int	worksheet
int	rowstart
int	colstart
int	rowend
int	colend
double[]	cellBorderColor
BorderLineStyleT	borderLineStyle

SetRangeFontProperty(int, int, int, int, int, string, int, double[], bool, bool, UnderlineStyleT, bool, bool, bool)

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
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

SetSheetTabBackgroundColor(int, double[])

Declaration

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

Parameters

Type	Name	Description
int	worksheet
double[]	tabBackgroundColor

SetWorksheetName(int, string)

Declaration

public void SetWorksheetName(int worksheet, string sheetname)

Parameters

Type	Name	Description
int	worksheet
string	sheetname

WriteRange(SpreadsheetCellData[])

Declaration

public void WriteRange(SpreadsheetCellData[] data)

Parameters

Type	Name	Description
SpreadsheetCellData[]	data

WriteSpreadsheetRange(int, int, int, int, int, SpreadsheetCellData[])

Declaration

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

Parameters

Type	Name	Description
int	worksheet
int	rowstart
int	colstart
int	rowend
int	colend
SpreadsheetCellData[]	data

Implements

System.Runtime.Remoting.Messaging.IMessageSink

IDisposable