NXOpen .NET Reference Guide
1899
|
Represents a class for internal spreadsheet. More...
Public Member Functions | |
unsafe void | Clear () |
Clears the contents of the current worksheet. More... | |
unsafe void | Delete (int start1, int end1, int sheet, int operation) |
Deletes (clears) one or more rows/columns of data from a worksheet. More... | |
unsafe void | DeleteSheets (int sheet, int count) |
Deletes specified number of sheets beginning with the specified sheet (from the current worksheet, if no sheet is specified). More... | |
unsafe void | EraseRange (int row0, int col0, int row1, int col1, int sheet0, int sheet1) |
Clears the contents of the specified range More... | |
unsafe NXOpen.SpreadsheetCellData | EvaluateCell (int row, int col, int sheet) |
Returns the evaluated value of a cell. More... | |
unsafe NXOpen.SpreadsheetCellData | GetFormula (int row, int col, int sheet) |
Retrieves a formula from a cell. More... | |
unsafe void | GetNamedRange (string rangename, out int[] namedrange) |
Resolves the named reference and returns the range of cells that are named This method returns a list, of the following format: Start Row, Start Column, End Row, End Column, Start Sheet Number, End Sheet Number of the named reference. More... | |
unsafe NXOpen.SpreadsheetCellData | GetNumber (int row, int col, int sheet) |
Retrieves a numeric value from a cell. More... | |
unsafe int | GetNumberOfSheets () |
Returns the total number of sheets in the spreadsheet More... | |
unsafe void | GetSheetNames (out string[] sheetnames) |
Returns list of existing sheet names in the spreadsheet. More... | |
unsafe int | GetSheetNumber () |
Returns the current work sheet number of the spreadsheet. More... | |
unsafe int | GetSheetNumberOfName (string sheetname) |
Returns sheet number of the sheet with given name. More... | |
unsafe NXOpen.SpreadsheetCellData | GetString (int row, int col, int sheet) |
Returns the String in the cell More... | |
unsafe NXOpen.SpreadsheetCellData | GetValue (int row, int col, int sheet) |
Returns a number, string or formula depending on the contents of the cell. More... | |
unsafe void | InsertSheets (int sheet, int count) |
Inserts specified number of sheets before the specified sheet (or the current work sheet if no sheet is specified). More... | |
unsafe void | Recalculate () |
Recalculates the spreadsheet. More... | |
unsafe void | Save () |
Saves the spreadsheet in the part file. More... | |
unsafe void | SetFormula (int row, int col, NXOpen.SpreadsheetCellData cellvalue, int sheet) |
Stores a formula into a cell. More... | |
unsafe void | SetNamedRange (string rangename, int row0, int col0, int row1, int col1, int sheet) |
Defines a name for the Range of cells. More... | |
unsafe void | SetNumber (int row, int col, NXOpen.SpreadsheetCellData cellvalue, int sheet) |
Stores a numeric value in the specified cell of the worksheet. More... | |
unsafe void | SetSheetNumber (int sheet) |
Sets the worksheet with specified index as current worksheet More... | |
unsafe void | SetString (int row, int col, NXOpen.SpreadsheetCellData cellvalue, int sheet) |
Sets the string in the cell. More... | |
unsafe void | Terminate () |
Terminates excel sheet for opened part. More... | |
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... | |
Public Member Functions inherited from NXOpen.Utilities.NXRemotableObject | |
IMessageCtrl | AsyncProcessMessage (IMessage msg, IMessageSink replySink) |
Asynchronously processes the given message. More... | |
IMessage | SyncProcessMessage (IMessage msg) |
Synchronously processes the given message. More... | |
Protected Member Functions | |
override void | FreeResource () |
Free resources associated with the instance. More... | |
Additional Inherited Members | |
Properties inherited from NXOpen.TransientObject | |
IntPtr | Handle [get] |
Handle of the internal object represented by this object. More... | |
Represents a class for internal spreadsheet.
To call functions from this class, use Spreadsheet object returned by NXOpen.SpreadsheetManager.Open .
Usable only on Windows
Created in NX11.0.0
|
inline |
Clears the contents of the current worksheet.
Created in NX11.0.0
License requirements: None.
|
inline |
Deletes (clears) one or more rows/columns of data from a worksheet.
Created in NX11.0.0
License requirements: None.
start1 | From where the deletion should start |
end1 | Upto where the rows should be deleted |
sheet | The sheet in which deletion should take place.(Current sheet, if no sheet is specified) |
operation | 1 for row deletion and 2 for column deletion. |
|
inline |
Deletes specified number of sheets beginning with the specified sheet (from the current worksheet, if no sheet is specified).
Created in NX11.0.0
License requirements: None.
sheet | Sheet Number, starting from which sheets are to be deleted. |
count | Number of sheets to be deleted |
|
inline |
Clears the contents of the specified range
Created in NX11.0.0
License requirements: None.
row0 | Starting row for range |
col0 | Starting column for range |
row1 | Ending row for range |
col1 | Ending column for range |
sheet0 | Sheet number for start of the range |
sheet1 | Sheet number for end of the range |
|
inline |
Returns the evaluated value of a cell.
Created in NX11.0.0
License requirements: None.
row | Row index of the cell |
col | Column index of the cell |
sheet | Sheet index (current worksheet, if zero is specified). |
|
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.
|
inline |
Retrieves a formula from a cell.
Created in NX11.0.0
License requirements: None.
row | Row index of the cell |
col | Column index of the cell |
sheet | Sheet index (current worksheet, if zero is specified) |
|
inline |
Resolves the named reference and returns the range of cells that are named This method returns a list, of the following format: Start Row, Start Column, End Row, End Column, Start Sheet Number, End Sheet Number of the named reference.
Created in NX11.0.0
License requirements: None.
rangename | Range name |
namedrange | The range of cells for given range name |
|
inline |
Retrieves a numeric value from a cell.
Created in NX11.0.0
License requirements: None.
row | Row index of the cell |
col | Column index of the cell |
sheet | Sheet index (current worksheet, if zero is specified) |
|
inline |
Returns the total number of sheets in the spreadsheet
Created in NX11.0.0
License requirements: None.
|
inline |
Returns list of existing sheet names in the spreadsheet.
Created in NX11.0.0
License requirements: None.
sheetnames | List of sheet names from specified spreadsheet |
|
inline |
Returns the current work sheet number of the spreadsheet.
Created in NX11.0.0
License requirements: None.
|
inline |
Returns sheet number of the sheet with given name.
Created in NX11.0.0
License requirements: None.
sheetname | Sheet name |
|
inline |
Returns the String in the cell
Created in NX11.0.0
License requirements: None.
row | Row index of the cell |
col | Column index of the cell |
sheet | Sheet index of the cell (current worksheet, if zero is specified). |
|
inline |
Returns a number, string or formula depending on the contents of the cell.
Created in NX11.0.0
License requirements: None.
row | Row index of the cell |
col | Column index of the cell |
sheet | Sheet index of the cell (current worksheet, if zero is specified). |
|
inline |
Inserts specified number of sheets before the specified sheet (or the current work sheet if no sheet is specified).
Created in NX11.0.0
License requirements: None.
sheet | Sheet number, before which the sheets are to be inserted. |
count | Number of sheets to be inserted. |
|
inline |
Recalculates the spreadsheet.
Created in NX11.0.0
License requirements: None.
|
inline |
Saves the spreadsheet in the part file.
Created in NX11.0.0
License requirements: None.
|
inline |
Stores a formula into a cell.
Created in NX11.0.0
License requirements: None.
row | Row index of the cell |
col | Column index of the cell |
cellvalue | |
sheet | Sheet index of the cell (current worksheet, if zero is specified). |
|
inline |
Defines a name for the Range of cells.
Created in NX11.0.0
License requirements: None.
rangename | Name to be given to the range |
row0 | Starting row of the table, which is being named |
col0 | Starting column of the table, which is being named |
row1 | Row of the table, upto which the name will apply |
col1 | Column of the table, upto which the name will apply |
sheet | Sheet index of the table (current worksheet, if zero is specified). |
|
inline |
Stores a numeric value in the specified cell of the worksheet.
Created in NX11.0.0
License requirements: None.
row | Row index of the cell |
col | Column index of the cell |
cellvalue | Numeric value to be set in the cell. |
sheet | Sheet index (current worksheet, if zero is specified). |
|
inline |
Sets the worksheet with specified index as current worksheet
Created in NX11.0.0
License requirements: None.
sheet | The number to which the current work sheet is to be set. |
|
inline |
Sets the string in the cell.
Created in NX11.0.0
License requirements: None.
row | Row index of the cell. |
col | Column index of the cell. |
cellvalue | String to be stored in this cell. |
sheet | Sheet index (current worksheet, if zero is specified). |
|
inline |
Terminates excel sheet for opened part.
Created in NX11.0.0
License requirements: None.