bundles/org.simantics.spreadsheet.graph/src/org/simantics/spreadsheet/graph/ExcelLink.java.keep

   1 /*******************************************************************************\r
   2  * Copyright (c) 2007, 2010 Association for Decentralized Information Management\r
   3  * in Industry THTH ry.\r
   4  * All rights reserved. This program and the accompanying materials\r
   5  * are made available under the terms of the Eclipse Public License v1.0\r
   6  * which accompanies this distribution, and is available at\r
   7  * http://www.eclipse.org/legal/epl-v10.html\r
   8  *\r
   9  * Contributors:\r
  10  *     VTT Technical Research Centre of Finland - initial API and implementation\r
  11  *******************************************************************************/\r
  12 package org.simantics.spreadsheet.graph;\r
  13 \r
  14 import java.util.UUID;\r
  15 \r
  16 import org.simantics.db.Resource;\r
  17 import org.simantics.db.common.utils.Logger;\r
  18 import org.simantics.excel.Excel;\r
  19 import org.simantics.spreadsheet.ClientModel;\r
  20 import org.simantics.spreadsheet.Range;\r
  21 import org.simantics.spreadsheet.common.client.ClientModelListenerAdapter;\r
  22 import org.simantics.spreadsheet.common.exception.CellParseException;\r
  23 import org.simantics.spreadsheet.util.SpreadsheetUtils;\r
  24 import org.simantics.utils.datastructures.Pair;\r
  25 \r
  26 public class ExcelLink extends ClientModelListenerAdapter {\r
  27 \r
  28     final private ClientModel model;\r
  29     final private String name;\r
  30     final private String prefix;\r
  31     final private Excel excel;\r
  32     private int handle;\r
  33     \r
  34     public ExcelLink(ClientModel model, Resource spreadsheet, String prefix) {\r
  35         \r
  36         this.handle = 0;\r
  37         this.model = model;\r
  38         this.name = "" + spreadsheet.getResourceId();\r
  39         this.prefix = prefix;\r
  40         this.excel = Excel.getInstance(System.out);\r
  41         model.addListener(this);\r
  42         \r
  43     }\r
  44     \r
  45 //    public <T> void load(final Resource spreadsheet) {\r
  46 //\r
  47 //        Excel e = null;\r
  48 //        try {\r
  49 //            e = Excel.getInstance(System.out); \r
  50 //        } catch (Throwable t) {\r
  51 //            t.printStackTrace();\r
  52 //        }\r
  53 //        excel = e;\r
  54 //        handle = excel.open_(excel.getFile(name + ".xlsx"));\r
  55 //        System.err.println("excel.open " + (name + ".xlsx"));\r
  56 //        \r
  57 //        \r
  58 //    }\r
  59 \r
  60     public void dispose() {\r
  61         model.removeListener(this);\r
  62         excel.close_(handle);\r
  63         System.err.println("excel.close " + handle);\r
  64     }\r
  65 \r
  66         @Override\r
  67         public void propertyChange(String location, String property, Object value) {\r
  68                 \r
  69                 if(ClientModel.LABEL.equals(property) && value != null && value instanceof String) {\r
  70                         \r
  71                         if(handle == 0) return;\r
  72                         Range range = SpreadsheetUtils.decodeCellAbsolute(location);\r
  73                         excel.setString_(handle, range.startRow, range.startColumn, (String)value);\r
  74 //                      System.err.println("excel.setString " + value);\r
  75                         \r
  76                 } else if("Excel".equals(location) && "Visible".equals(property) && value instanceof Boolean) {\r
  77 \r
  78                         Boolean visible = (Boolean)value;\r
  79                         if(visible) {\r
  80                                 \r
  81                         try {\r
  82                                 if(handle == 0) {\r
  83                                         \r
  84                                         Excel excel = Excel.getInstance(System.out); \r
  85                                         handle = excel.open_(excel.getFile(name + ".xlsx"));\r
  86 //                                      System.err.println("excel.open " + (name + ".xlsx"));\r
  87                                         \r
  88                                                 for(Pair<String, Object> label : model.listAll(ClientModel.LABEL)) {\r
  89                                                         try {\r
  90                                                                 Range range = SpreadsheetUtils.decodeCellAbsolute(label.first);\r
  91                                                                 excel.setString_(handle, range.startRow, range.startColumn, (String)label.second);\r
  92                                                                 System.err.println("excel.setString " + label.second);\r
  93                                                         } catch (CellParseException e) {\r
  94                                                         }\r
  95                                                 }\r
  96                                                 for(Pair<String, Object> label : model.listAll(ClientModel.CONTENT)) {\r
  97                                                         try {\r
  98                                                                 Range range = SpreadsheetUtils.decodeCellAbsolute(label.first);\r
  99                                                                 //excel.setString_(handle, range.startRow, range.startColumn, (String)label.second);\r
 100                                                                 \r
 101                                                                 String uri = (String)label.second;\r
 102                                                                 if(uri.startsWith(prefix)) {\r
 103                                                                         String rvi = uri.substring(prefix.length()+1).replace("#", "_").replace("(", "_").replace(")", "_").replace("+", "p").replace("-", "m");\r
 104                                                                         excel.setName_(handle, range.startRow, range.startColumn, rvi);\r
 105                                                                         System.err.println("excel.setCellName '" + rvi + "'");\r
 106                                                                 }\r
 107                                                                 \r
 108                                                         } catch (CellParseException e) {\r
 109                                                         }\r
 110                                                 }\r
 111                                                 \r
 112                                 }\r
 113                         } catch (Throwable t) {\r
 114                                 Logger.defaultLogError(t);\r
 115                         }\r
 116                                 \r
 117                         } else {\r
 118 \r
 119                         try {\r
 120                                 if(handle != 0) {\r
 121                                         Excel excel = Excel.getInstance(System.out); \r
 122                                         handle = excel.close_(handle);\r
 123                                         handle = 0;\r
 124 //                                      System.err.println("excel.close " + handle);\r
 125                                 }\r
 126                         } catch (Throwable t) {\r
 127                                 Logger.defaultLogError(t);\r
 128                         }\r
 129                                 \r
 130                         }\r
 131 //                      excel.setVisible_(handle, (Boolean)value);\r
 132 //                      System.err.println("excel.setVisible " + value);\r
 133                 }\r
 134         }\r
 135     \r
 136 //    @Override\r
 137 //    public void changed(int row, int column, Cell cell) {\r
 138 //\r
 139 //        String value = cell != null ? cell.toString() : "";\r
 140 //        if(value == null) value = "...";\r
 141 //        excel.setString_(handle, row, column, value);\r
 142 //        \r
 143 //    }\r
 144 \r
 145 }\r