Package loxia.utils

Examples of loxia.utils.OgnlStack

58
59
60
61
62
63
64
65
66
67
68
      if(definition.getExcelSheets().size() == 0 ||
        wb.getNumberOfSheets() < definition.getExcelSheets().size()){
        readStatus.setStatus(ReadStatus.STATUS_SETTING_ERROR);
        readStatus.setMessage("No sheet definition found or Sheet Number in definition is more than number in file.");
      }else{
        OgnlStack stack = new OgnlStack(beans);
        for(int i=0; i< definition.getExcelSheets().size(); i++){
          readSheet(wb,i,
              definition.getExcelSheets().get(i), stack, readStatus);
        }
      }
View Full Code Here
91
92
93
94
95
96
97
98
99
100
101
          if(beans.get(key) != null)
            cacheMap.put(key, new ArrayList<Object>());
        }
        for(int i = 0; i< wb.getNumberOfSheets(); i++){
          Map<String, Object> clonedBeans = cloneMap(beans);
          readSheet(wb,i, sheetDefinition, new OgnlStack(clonedBeans), readStatus);
          for(String key: clonedBeans.keySet())
            cacheMap.get(key).add(clonedBeans.get(key));
        }
        for(String key: beans.keySet()){
          if(cacheMap.containsKey(key)){
View Full Code Here
122
123
124
125
126
127
128
129
130
131
132
  }
 
  public ReadStatus readSheet(InputStream is, int sheetNo, Map<String, Object> beans) {
    ReadStatus readStatus = new DefaultReadStatus();
    readStatus.setStatus(ReadStatus.STATUS_SUCCESS);
    OgnlStack stack = new OgnlStack(beans);
    try {
      Workbook wb = WorkbookFactory.create(is);
      readSheet(wb,sheetNo,
          definition.getExcelSheets().iterator().next(),
          stack, readStatus);     
View Full Code Here
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
        }     
      }
      return result;
    }else{
      Object result = blockDefinition.getLoopClass().newInstance();   
      OgnlStack ognlStack = new OgnlStack(result);
      for(ExcelCell cellDefinition: blockDefinition.getCells()){   
        int rowOffSet = cellDefinition.getRow() - blockDefinition.getStartRow();
        Row row = sheet.getRow(startRow + rowOffSet);
        Cell cell = row == null ? null: row.getCell(cellDefinition.getCol());     
        try{
          Object value = getCellValue(cell,evaluator);
          value = checkValue(sheetNo, ExcelUtil.getCellIndex(startRow + rowOffSet ,cellDefinition.getCol()),
              value, cellDefinition,
              getPropertyType(result, cellDefinition));
          logger.debug("{}[Checked]:{}", ExcelUtil.getCellIndex(startRow + rowOffSet ,cellDefinition.getCol()), value);
          ognlStack.setValue(cellDefinition.getDataName(), value);
        }catch(ExcelManipulateException e){
          if(readStatus.getStatus() == ReadStatus.STATUS_SUCCESS)
            readStatus.setStatus(ReadStatus.STATUS_DATA_COLLECTION_ERROR);
          readStatus.addException(e);
        }     
View Full Code Here
117
118
119
120
121
122
123
124
125
126
127
        logger.debug("{} styles found", styleMap.keySet().size());
      }       
      for(int i=0; i< definition.getExcelSheets().size(); i++){
        writeSheet(wb.getSheetAt(i),
            definition.getExcelSheets().get(i),
            new OgnlStack(beans), styleMap, writeStatus);
      }
      reCalculateWorkbook(wb);
      wb.setActiveSheet(0);
      try {
        wb.write(os);
View Full Code Here
190
191
192
193
194
195
196
197
198
199
200
      for(int i=0; i< beansList.size(); i++){
        Sheet newSheet = wb.createSheet("Auto Generated Sheet " + i);
        ExcelUtil.copySheet(wb.getSheetAt(0), newSheet);
      writeSheet(newSheet,
            definition.getExcelSheets().iterator().next(),
            new OgnlStack(beansList.get(i)), styleMap, writeStatus);
      }
      //remove template sheet
      wb.removeSheetAt(0);
      reCalculateWorkbook(wb);
      wb.setActiveSheet(0);
View Full Code Here
TOP

Related Classes of loxia.utils.OgnlStack

  • loxia.support.excel.impl.DefaultExcelReader
  • loxia.support.excel.impl.DefaultExcelWriter
  • ognl.NullHandler
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.