--- /dev/null
+/*******************************************************************************\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