public interface SpreadsheetExternal extends TransientObject
SpreadsheetExternal
object returned by SpreadsheetManager.openFile(java.lang.String, nxopen.SpreadsheetManager.OpenMode)
.
Modifier and Type | Method and Description |
---|---|
void |
appendRow(int worksheet,
SpreadsheetCellData[] data)
Appends a new row of data to the Excel file.
|
void |
closeFile(boolean save)
Closes an excel file with an option to save the file before close.
|
int |
getWorksheetIndex(String sheetname)
Returns worksheet ID.
|
SpreadsheetCellData[] |
readNamedRange(int worksheet,
String rangename)
Reads a named range.
|
SpreadsheetCellData[] |
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.
|
void |
writeRange(SpreadsheetCellData[] data)
Writes the data to the specified range of the spreadsheet.
|
_value, dispose, printTestData, printTestData
void closeFile(boolean save) throws NXException, RemoteException
save
- If true, the file will be saved. If false, the file will not be saved.NXException
RemoteException
int getWorksheetIndex(String sheetname) throws NXException, RemoteException
sheetname
- Sheet name to get IndexNXException
RemoteException
SpreadsheetCellData[] readNamedRange(int worksheet, String rangename) throws NXException, RemoteException
worksheet
- worksheet IDrangename
- Range nameNXException
RemoteException
SpreadsheetCellData[] readRange(int worksheet, int rowstart, int colstart, int rowend, int colend) throws NXException, RemoteException
worksheet
- Worksheet IDrowstart
- Starting row of the rangecolstart
- Starting column of the rangerowend
- Ending row of the rangecolend
- Ending column of the rangeNXException
RemoteException
void appendRow(int worksheet, SpreadsheetCellData[] data) throws NXException, RemoteException
worksheet
- Worksheet IDdata
- The append data list.NXException
RemoteException
void writeRange(SpreadsheetCellData[] data) throws NXException, RemoteException
data
- The data list to be written to external Excel worksheet.NXException
RemoteException
Copyright 2017 Siemens Product Lifecycle Management Software Inc. All Rights Reserved.