-/*******************************************************************************\r
- * Copyright (c) 2007, 2010 Association for Decentralized Information Management\r
- * in Industry THTH ry.\r
- * All rights reserved. This program and the accompanying materials\r
- * are made available under the terms of the Eclipse Public License v1.0\r
- * which accompanies this distribution, and is available at\r
- * http://www.eclipse.org/legal/epl-v10.html\r
- *\r
- * Contributors:\r
- * VTT Technical Research Centre of Finland - initial API and implementation\r
- *******************************************************************************/\r
-package org.simantics.spreadsheet.graph;\r
-\r
-import java.util.UUID;\r
-\r
-import org.simantics.db.Resource;\r
-import org.simantics.db.common.utils.Logger;\r
-import org.simantics.excel.Excel;\r
-import org.simantics.spreadsheet.ClientModel;\r
-import org.simantics.spreadsheet.Range;\r
-import org.simantics.spreadsheet.common.client.ClientModelListenerAdapter;\r
-import org.simantics.spreadsheet.common.exception.CellParseException;\r
-import org.simantics.spreadsheet.util.SpreadsheetUtils;\r
-import org.simantics.utils.datastructures.Pair;\r
-\r
-public class ExcelLink extends ClientModelListenerAdapter {\r
-\r
- final private ClientModel model;\r
- final private String name;\r
- final private String prefix;\r
- final private Excel excel;\r
- private int handle;\r
- \r
- public ExcelLink(ClientModel model, Resource spreadsheet, String prefix) {\r
- \r
- this.handle = 0;\r
- this.model = model;\r
- this.name = "" + spreadsheet.getResourceId();\r
- this.prefix = prefix;\r
- this.excel = Excel.getInstance(System.out);\r
- model.addListener(this);\r
- \r
- }\r
- \r
-// public <T> void load(final Resource spreadsheet) {\r
-//\r
-// Excel e = null;\r
-// try {\r
-// e = Excel.getInstance(System.out); \r
-// } catch (Throwable t) {\r
-// t.printStackTrace();\r
-// }\r
-// excel = e;\r
-// handle = excel.open_(excel.getFile(name + ".xlsx"));\r
-// System.err.println("excel.open " + (name + ".xlsx"));\r
-// \r
-// \r
-// }\r
-\r
- public void dispose() {\r
- model.removeListener(this);\r
- excel.close_(handle);\r
- System.err.println("excel.close " + handle);\r
- }\r
-\r
- @Override\r
- public void propertyChange(String location, String property, Object value) {\r
- \r
- if(ClientModel.LABEL.equals(property) && value != null && value instanceof String) {\r
- \r
- if(handle == 0) return;\r
- Range range = SpreadsheetUtils.decodeCellAbsolute(location);\r
- excel.setString_(handle, range.startRow, range.startColumn, (String)value);\r
-// System.err.println("excel.setString " + value);\r
- \r
- } else if("Excel".equals(location) && "Visible".equals(property) && value instanceof Boolean) {\r
-\r
- Boolean visible = (Boolean)value;\r
- if(visible) {\r
- \r
- try {\r
- if(handle == 0) {\r
- \r
- Excel excel = Excel.getInstance(System.out); \r
- handle = excel.open_(excel.getFile(name + ".xlsx"));\r
-// System.err.println("excel.open " + (name + ".xlsx"));\r
- \r
- for(Pair<String, Object> label : model.listAll(ClientModel.LABEL)) {\r
- try {\r
- Range range = SpreadsheetUtils.decodeCellAbsolute(label.first);\r
- excel.setString_(handle, range.startRow, range.startColumn, (String)label.second);\r
- System.err.println("excel.setString " + label.second);\r
- } catch (CellParseException e) {\r
- }\r
- }\r
- for(Pair<String, Object> label : model.listAll(ClientModel.CONTENT)) {\r
- try {\r
- Range range = SpreadsheetUtils.decodeCellAbsolute(label.first);\r
- //excel.setString_(handle, range.startRow, range.startColumn, (String)label.second);\r
- \r
- String uri = (String)label.second;\r
- if(uri.startsWith(prefix)) {\r
- String rvi = uri.substring(prefix.length()+1).replace("#", "_").replace("(", "_").replace(")", "_").replace("+", "p").replace("-", "m");\r
- excel.setName_(handle, range.startRow, range.startColumn, rvi);\r
- System.err.println("excel.setCellName '" + rvi + "'");\r
- }\r
- \r
- } catch (CellParseException e) {\r
- }\r
- }\r
- \r
- }\r
- } catch (Throwable t) {\r
- Logger.defaultLogError(t);\r
- }\r
- \r
- } else {\r
-\r
- try {\r
- if(handle != 0) {\r
- Excel excel = Excel.getInstance(System.out); \r
- handle = excel.close_(handle);\r
- handle = 0;\r
-// System.err.println("excel.close " + handle);\r
- }\r
- } catch (Throwable t) {\r
- Logger.defaultLogError(t);\r
- }\r
- \r
- }\r
-// excel.setVisible_(handle, (Boolean)value);\r
-// System.err.println("excel.setVisible " + value);\r
- }\r
- }\r
- \r
-// @Override\r
-// public void changed(int row, int column, Cell cell) {\r
-//\r
-// String value = cell != null ? cell.toString() : "";\r
-// if(value == null) value = "...";\r
-// excel.setString_(handle, row, column, value);\r
-// \r
-// }\r
-\r
-}\r
+/*******************************************************************************
+ * Copyright (c) 2007, 2010 Association for Decentralized Information Management
+ * in Industry THTH ry.
+ * All rights reserved. This program and the accompanying materials
+ * are made available under the terms of the Eclipse Public License v1.0
+ * which accompanies this distribution, and is available at
+ * http://www.eclipse.org/legal/epl-v10.html
+ *
+ * Contributors:
+ * VTT Technical Research Centre of Finland - initial API and implementation
+ *******************************************************************************/
+package org.simantics.spreadsheet.graph;
+
+import java.util.UUID;
+
+import org.simantics.db.Resource;
+import org.simantics.db.common.utils.Logger;
+import org.simantics.excel.Excel;
+import org.simantics.spreadsheet.ClientModel;
+import org.simantics.spreadsheet.Range;
+import org.simantics.spreadsheet.common.client.ClientModelListenerAdapter;
+import org.simantics.spreadsheet.common.exception.CellParseException;
+import org.simantics.spreadsheet.util.SpreadsheetUtils;
+import org.simantics.utils.datastructures.Pair;
+
+public class ExcelLink extends ClientModelListenerAdapter {
+
+ final private ClientModel model;
+ final private String name;
+ final private String prefix;
+ final private Excel excel;
+ private int handle;
+
+ public ExcelLink(ClientModel model, Resource spreadsheet, String prefix) {
+
+ this.handle = 0;
+ this.model = model;
+ this.name = "" + spreadsheet.getResourceId();
+ this.prefix = prefix;
+ this.excel = Excel.getInstance(System.out);
+ model.addListener(this);
+
+ }
+
+// public <T> void load(final Resource spreadsheet) {
+//
+// Excel e = null;
+// try {
+// e = Excel.getInstance(System.out);
+// } catch (Throwable t) {
+// t.printStackTrace();
+// }
+// excel = e;
+// handle = excel.open_(excel.getFile(name + ".xlsx"));
+// System.err.println("excel.open " + (name + ".xlsx"));
+//
+//
+// }
+
+ public void dispose() {
+ model.removeListener(this);
+ excel.close_(handle);
+ System.err.println("excel.close " + handle);
+ }
+
+ @Override
+ public void propertyChange(String location, String property, Object value) {
+
+ if(ClientModel.LABEL.equals(property) && value != null && value instanceof String) {
+
+ if(handle == 0) return;
+ Range range = SpreadsheetUtils.decodeCellAbsolute(location);
+ excel.setString_(handle, range.startRow, range.startColumn, (String)value);
+// System.err.println("excel.setString " + value);
+
+ } else if("Excel".equals(location) && "Visible".equals(property) && value instanceof Boolean) {
+
+ Boolean visible = (Boolean)value;
+ if(visible) {
+
+ try {
+ if(handle == 0) {
+
+ Excel excel = Excel.getInstance(System.out);
+ handle = excel.open_(excel.getFile(name + ".xlsx"));
+// System.err.println("excel.open " + (name + ".xlsx"));
+
+ for(Pair<String, Object> label : model.listAll(ClientModel.LABEL)) {
+ try {
+ Range range = SpreadsheetUtils.decodeCellAbsolute(label.first);
+ excel.setString_(handle, range.startRow, range.startColumn, (String)label.second);
+ System.err.println("excel.setString " + label.second);
+ } catch (CellParseException e) {
+ }
+ }
+ for(Pair<String, Object> label : model.listAll(ClientModel.CONTENT)) {
+ try {
+ Range range = SpreadsheetUtils.decodeCellAbsolute(label.first);
+ //excel.setString_(handle, range.startRow, range.startColumn, (String)label.second);
+
+ String uri = (String)label.second;
+ if(uri.startsWith(prefix)) {
+ String rvi = uri.substring(prefix.length()+1).replace("#", "_").replace("(", "_").replace(")", "_").replace("+", "p").replace("-", "m");
+ excel.setName_(handle, range.startRow, range.startColumn, rvi);
+ System.err.println("excel.setCellName '" + rvi + "'");
+ }
+
+ } catch (CellParseException e) {
+ }
+ }
+
+ }
+ } catch (Throwable t) {
+ Logger.defaultLogError(t);
+ }
+
+ } else {
+
+ try {
+ if(handle != 0) {
+ Excel excel = Excel.getInstance(System.out);
+ handle = excel.close_(handle);
+ handle = 0;
+// System.err.println("excel.close " + handle);
+ }
+ } catch (Throwable t) {
+ Logger.defaultLogError(t);
+ }
+
+ }
+// excel.setVisible_(handle, (Boolean)value);
+// System.err.println("excel.setVisible " + value);
+ }
+ }
+
+// @Override
+// public void changed(int row, int column, Cell cell) {
+//
+// String value = cell != null ? cell.toString() : "";
+// if(value == null) value = "...";
+// excel.setString_(handle, row, column, value);
+//
+// }
+
+}