@Override
public void run(TaskMonitor tm) throws Exception {
tm.setTitle("Loading network from table");
tm.setProgress(0.0);
tm.setStatusMessage("Loading network...");
Workbook workbook = null;
// Load Spreadsheet data for preview.
if (fileType != null
&& (fileType.equalsIgnoreCase(SupportedFileType.EXCEL.getExtension())
|| fileType.equalsIgnoreCase(SupportedFileType.OOXML.getExtension()))
&& workbook == null) {
try {
workbook = WorkbookFactory.create(is);
} catch (InvalidFormatException e) {
throw new IllegalArgumentException(
"Could not read Excel file. Maybe the file is broken?", e);
} finally {
if (is != null) is.close();
}
}
try {
if (this.fileType.equalsIgnoreCase(SupportedFileType.EXCEL.getExtension())
|| this.fileType.equalsIgnoreCase(SupportedFileType.OOXML.getExtension())) {
String networkName = ntmp.getName();
if (networkName == null) networkName = workbook.getSheetName(0);
final Sheet sheet = workbook.getSheet(networkName);
reader =
new ExcelNetworkSheetReader(
networkName, sheet, ntmp, nMap, rootNetwork, serviceRegistrar);
} else {
reader = new NetworkTableReader(inputName, is, ntmp, nMap, rootNetwork, serviceRegistrar);
}
} catch (Exception ioe) {
tm.showMessage(TaskMonitor.Level.ERROR, "Unable to read table: " + ioe.getMessage());
return;
}
loadNetwork(tm);
tm.setProgress(1.0);
}
