public interface SpreadsheetManager extends Remote
Spreadsheet
object returned by open(nxopen.SpreadsheetManager.Sheettype, java.lang.String)
For interacting with external spreadsheet, use Spreadsheet
object returned by openFile(java.lang.String, nxopen.SpreadsheetManager.OpenMode)
. Session
Modifier and Type | Interface and Description |
---|---|
static class |
SpreadsheetManager.LookupMode
Modes of lookup in the table.
|
static class |
SpreadsheetManager.OpenMode
Sheet types to open spreadsheet.
|
static class |
SpreadsheetManager.Sheettype
Sheet types to open spreadsheet.
|
Modifier and Type | Method and Description |
---|---|
SpreadsheetCellData |
createCellData()
Creates SpreadsheetCellData object.
|
String |
exportFile(String partnum)
In NX/MGR mode, export an Excel spreadsheet file from the dataset file stored in
the Teamcenter database to the native file system.
|
SpreadsheetCellData |
horizontalLookup(String file,
String target,
String range,
int offset,
SpreadsheetManager.LookupMode mode)
Reads the value from a given spreadsheet using a horizontal table lookup.
|
Spreadsheet |
open(SpreadsheetManager.Sheettype sheettype,
String partfile)
Opens excel sheet associated with given part file.
|
SpreadsheetExternal |
openFile(String sheet,
SpreadsheetManager.OpenMode mode)
Opens an Excel spreadsheet file.
|
SpreadsheetCellData |
readAny(String filename,
String cell)
Reads value in a given cell, from a given spreadsheet.
|
SpreadsheetCellData |
readCell(String filename,
String cell)
Reads value in a given cell, from a given spreadsheet.
|
SpreadsheetCellData |
verticalLookup(String file,
String target,
String range,
int offset,
SpreadsheetManager.LookupMode mode)
Reads the value from a given spreadsheet using a vertical table lookup.
|
SpreadsheetCellData readCell(String filename, String cell) throws NXException, RemoteException
filename
- File name with full pathcell
- Cell number can contain the worksheet along with the cell number
by separating the two fields with an exclamation mark. For example: Sheet1!A1NXException
RemoteException
SpreadsheetCellData readAny(String filename, String cell) throws NXException, RemoteException
filename
- File name with full pathcell
- Cell number can contain the worksheet along with the cell number
by separating the two fields with an exclamation mark. For example: Sheet1!A1NXException
RemoteException
SpreadsheetCellData horizontalLookup(String file, String target, String range, int offset, SpreadsheetManager.LookupMode mode) throws NXException, RemoteException
file
- File name with full pathtarget
- Lookup targetrange
- Table rangeoffset
- The offset to the data cell.mode
- The mode of lookup in the table.NXException
RemoteException
SpreadsheetCellData verticalLookup(String file, String target, String range, int offset, SpreadsheetManager.LookupMode mode) throws NXException, RemoteException
file
- File name with full pathtarget
- Lookup targetrange
- Table rangeoffset
- The offset to the data cell.mode
- The mode of lookup in the table.NXException
RemoteException
SpreadsheetExternal openFile(String sheet, SpreadsheetManager.OpenMode mode) throws NXException, RemoteException
sheet
- An external Excel file namemode
- Mode read/writeSpreadsheetExternal
object to be used to access the external spreadsheet.NXException
RemoteException
String exportFile(String partnum) throws NXException, RemoteException
partnum
- A part number containing a MsExcel dataset.NXException
RemoteException
Spreadsheet open(SpreadsheetManager.Sheettype sheettype, String partfile) throws NXException, RemoteException
Spreadsheet
object.
sheettype
- Sheet typepartfile
- Part fileSpreadsheet
object to be used to access the spreadsheet.NXException
RemoteException
SpreadsheetCellData createCellData() throws NXException, RemoteException
NXException
RemoteException
Copyright 2017 Siemens Product Lifecycle Management Software Inc. All Rights Reserved.