Migrated source code from Simantics SVN

[simantics/platform.git] / bundles / org.simantics.spreadsheet.graph / src / org / simantics / spreadsheet / graph / ExcelLink.java.keep

diff --git a/bundles/org.simantics.spreadsheet.graph/src/org/simantics/spreadsheet/graph/ExcelLink.java.keep b/bundles/org.simantics.spreadsheet.graph/src/org/simantics/spreadsheet/graph/ExcelLink.java.keep
new file mode 100644 (file)
index 0000000..2feac27
--- /dev/null
+++ b/bundles/org.simantics.spreadsheet.graph/src/org/simantics/spreadsheet/graph/ExcelLink.java.keep
@@ -0,0 +1,145 @@
+/*******************************************************************************\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