Package loxia.support.excel

Examples of loxia.support.excel.WriteStatus

73
74
75
76
77
78
79
80
81
82
      map.put("floatValue", (i*7+3)/3.0);
      bodyList.add(map);
    }
    beans.put("bodylist", bodyList);
    System.out.println(report1ExcelWriter.getDefinition());
    WriteStatus ws = report1ExcelWriter.write(new FileOutputStream(new File("D:/test.xlsx")), beans);
    for(String str: ExcelKit.getInstance().getWriteStatusMessages(ws, Locale.CHINESE))
      System.out.println(str);
    System.out.println("Done!");
  }
View Full Code Here
98
99
100
101
102
103
104
105
106
107
      map.put("floatValue", (i*7+3)/3.0);
      bodyList.add(map);
    }
    beans.put("bodylist", bodyList);
    System.out.println(report2ExcelWriter.getDefinition());
    WriteStatus ws = report2ExcelWriter.write(new FileOutputStream(new File("D:/test.xlsx")), beans);
    for(String str: ExcelKit.getInstance().getWriteStatusMessages(ws, Locale.CHINESE))
      System.out.println(str);
    System.out.println("Done!");
  }
View Full Code Here
123
124
125
126
127
128
129
130
131
132
      map.put("floatValue", (i*7+3)/3.0);
      bodyList.add(map);
    }
    beans.put("bodylist", bodyList);
    System.out.println(report3ExcelWriter.getDefinition());
    WriteStatus ws = report3ExcelWriter.write(new FileOutputStream(new File("D:/test.xlsx")), beans);
    for(String str: ExcelKit.getInstance().getWriteStatusMessages(ws, Locale.CHINESE))
      System.out.println(str);
    System.out.println("Done!");
  }
View Full Code Here
158
159
160
161
162
163
164
165
166
167
      }
      data.put("monthList", monthList);
      list.add(data);
    }
    beans.put("list", list);
    WriteStatus ws = report4ExcelWriter.write(new FileOutputStream(new File("D:/test.xlsx")), beans);
    for(String str: ExcelKit.getInstance().getWriteStatusMessages(ws, Locale.CHINESE))
      System.out.println(str);
    System.out.println("Done!");
  }
View Full Code Here
170
171
172
173
174
175
176
177
178
179
  public void test5() throws Exception{
    Map<String, Object> beans = new HashMap<String, Object>();
    for(int i=1; i<=14; i++){
      beans.put("v"+i, new BigDecimal(Math.random()*60).setScale(2,BigDecimal.ROUND_HALF_UP));
    }
    WriteStatus ws = report5ExcelWriter.write(new FileOutputStream(new File("D:/test.xlsx")), beans);
    for(String str: ExcelKit.getInstance().getWriteStatusMessages(ws, Locale.CHINESE))
      System.out.println(str);
    System.out.println("Done!");
  }
View Full Code Here
209
210
211
212
213
214
215
216
217
218
      day.put("terms", cc.getSolarTerms());
      oneweek.put("d" + c.get(Calendar.DAY_OF_WEEK), day);
      cc.rollUpOneDay();
      c.add(Calendar.DATE, 1);
    }
    WriteStatus ws = calendarWriter.writePerSheet(new FileOutputStream(new File("D:/calendar.xlsx")), listBeans);
    for(String str: ExcelKit.getInstance().getWriteStatusMessages(ws, Locale.CHINESE))
      System.out.println(str);
    System.out.println("Done!");
  }
View Full Code Here
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
 
  private ExcelManipulatorDefinition definition;
  private byte[] bufferedTemplate;
 
  public WriteStatus write(OutputStream os, Map<String, Object> beans){
    WriteStatus writeStatus = new DefaultWriteStatus();
    writeStatus.setStatus(WriteStatus.STATUS_SUCCESS);
   
    if(bufferedTemplate == null) {
      writeStatus.setStatus(WriteStatus.STATUS_READ_TEMPLATE_FILE_ERROR);
      return writeStatus;
    }
   
    Workbook wb = createWookBook(new ByteArrayInputStream(bufferedTemplate), writeStatus);
   
View Full Code Here
70
71
72
73
74
75
76
77
78
79
80
81
    return writeStatus;
   
  }

  public WriteStatus write(InputStream is, OutputStream os, Map<String, Object> beans) {
    WriteStatus writeStatus = new DefaultWriteStatus();
    writeStatus.setStatus(WriteStatus.STATUS_SUCCESS);
   
    Workbook wb = createWookBook(is, writeStatus);
   
    if(wb != null){     
      writeNative(wb, os, beans, writeStatus);
View Full Code Here
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
    return write(Thread.currentThread().getContextClassLoader()
        .getResourceAsStream(template),os,beans);
  }
 
  public WriteStatus writePerSheet(OutputStream os, List<Map<String, Object>> beansList) {
    WriteStatus writeStatus = new DefaultWriteStatus();
    writeStatus.setStatus(WriteStatus.STATUS_SUCCESS);
   
    if(bufferedTemplate == null) {
      writeStatus.setStatus(WriteStatus.STATUS_READ_TEMPLATE_FILE_ERROR);
      return writeStatus;
    }
   
    Workbook wb = createWookBook(new ByteArrayInputStream(bufferedTemplate), writeStatus);
   
View Full Code Here
152
153
154
155
156
157
158
159
160
161
162
163
    }
    return writeStatus;
  }

  public WriteStatus writePerSheet(InputStream is, OutputStream os, List<Map<String, Object>> beansList) {
    WriteStatus writeStatus = new DefaultWriteStatus();
    writeStatus.setStatus(WriteStatus.STATUS_SUCCESS);
   
    Workbook wb = createWookBook(is, writeStatus);
   
    if(wb != null){
      writePerSheetNative(wb, os, beansList, writeStatus);
View Full Code Here
TOP

Related Classes of loxia.support.excel.WriteStatus

  • loxia.sample.ExcelWriterTest
  • loxia.support.excel.impl.DefaultExcelWriter
    • 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.