Package | Description |
---|---|
nxopen |
Provides classes and interfaces for the NX Open Common API.
|
Modifier and Type | Method and Description |
---|---|
SpreadsheetCellData |
SpreadsheetManager.createCellData()
Creates SpreadsheetCellData object.
|
SpreadsheetCellData |
Spreadsheet.evaluateCell(int row,
int col,
int sheet)
Returns the evaluated value of a cell.
|
SpreadsheetCellData |
Spreadsheet.getFormula(int row,
int col,
int sheet)
Retrieves a formula from a cell.
|
SpreadsheetCellData |
Spreadsheet.getNumber(int row,
int col,
int sheet)
Retrieves a numeric value from a cell.
|
SpreadsheetCellData |
Spreadsheet.getString(int row,
int col,
int sheet)
Returns the String in the cell
License requirements: None. |
SpreadsheetCellData |
Spreadsheet.getValue(int row,
int col,
int sheet)
Returns a number, string or formula depending on the contents of the cell.
|
SpreadsheetCellData |
SpreadsheetManager.horizontalLookup(String file,
String target,
String range,
int offset,
SpreadsheetManager.LookupMode mode)
Reads the value from a given spreadsheet using a horizontal table lookup.
|
SpreadsheetCellData |
SpreadsheetManager.readAny(String filename,
String cell)
Reads value in a given cell, from a given spreadsheet.
|
SpreadsheetCellData |
SpreadsheetManager.readCell(String filename,
String cell)
Reads value in a given cell, from a given spreadsheet.
|
SpreadsheetCellData[] |
SpreadsheetExternal.readNamedRange(int worksheet,
String rangename)
Reads a named range.
|
SpreadsheetCellData[] |
SpreadsheetExternal.readRange(int worksheet,
int rowstart,
int colstart,
int rowend,
int colend)
Reads the spreadsheet file and returns the data in the specified ranges
of the cells.
|
SpreadsheetCellData |
SpreadsheetManager.verticalLookup(String file,
String target,
String range,
int offset,
SpreadsheetManager.LookupMode mode)
Reads the value from a given spreadsheet using a vertical table lookup.
|
Modifier and Type | Method and Description |
---|---|
void |
SpreadsheetExternal.appendRow(int worksheet,
SpreadsheetCellData[] data)
Appends a new row of data to the Excel file.
|
void |
Spreadsheet.setFormula(int row,
int col,
SpreadsheetCellData cellvalue,
int sheet)
Stores a formula into a cell.
|
void |
Spreadsheet.setNumber(int row,
int col,
SpreadsheetCellData cellvalue,
int sheet)
Stores a numeric value in the specified cell of the worksheet.
|
void |
Spreadsheet.setString(int row,
int col,
SpreadsheetCellData cellvalue,
int sheet)
Sets the string in the cell.
|
void |
SpreadsheetExternal.writeRange(SpreadsheetCellData[] data)
Writes the data to the specified range of the spreadsheet.
|
Copyright 2017 Siemens Product Lifecycle Management Software Inc. All Rights Reserved.