Examples of ExcelReader

Examples of org.g4studio.core.web.report.excel.ExcelReader

71
72
73
74
75
76
77
78
79
80
81
  public ActionForward importExcel(ActionMapping mapping, ActionForm form, HttpServletRequest request,
      HttpServletResponse response) throws Exception {
    BaseActionForm actionForm = (BaseActionForm) form;
    FormFile theFile = actionForm.getTheFile();
    String metaData = "xmid,xmmc,xmrj,gg,dw,jx,zfbl,cd,ggsj";
    ExcelReader excelReader = new ExcelReader(metaData, theFile.getInputStream());
    List list = excelReader.read(3, 1);
    super.setSessionAttribute(request, "importExcelList", list);
    setOkTipMsg("导入成功", response);
    return mapping.findForward(null);
  }
View Full Code Here

Examples of org.molgenis.io.excel.ExcelReader

54
55
56
57
58
59
60
61
62
63
64
65
    try
    {
      excelExporter.export(new FileOutputStream(xlsFile));

      // check output
      ExcelReader excelReader = new ExcelReader(xlsFile);
      ExcelSheetReader sheetReader = excelReader.getSheet("Sheet1");
      try
      {
        Iterator<Tuple> it = sheetReader.iterator();
        assertTrue(it.hasNext());
        Tuple tuple1 = it.next();
View Full Code Here

Examples of org.molgenis.io.excel.ExcelReader

114
115
116
117
118
119
120
121
122
123
124
125
    try
    {
      excelExporter.export(new FileOutputStream(xlsFile));

      // check output
      ExcelReader excelReader = new ExcelReader(xlsFile);
      ExcelSheetReader sheetReader = excelReader.getSheet("Sheet1");
      try
      {
        Iterator<Tuple> it = sheetReader.iterator();
        assertTrue(it.hasNext());
        Tuple tuple1 = it.next();
View Full Code Here

Examples of org.molgenis.io.excel.ExcelReader

54
55
56
57
58
59
60
61
62
63
64
      String tableName = FilenameUtils.getBaseName(name);
      return new SingleTableReader(new CsvReader(file, '\t'), tableName);
    }
    else if (name.endsWith(".xls") || name.endsWith(".xlsx"))
    {
      return new ExcelReader(file);
    }
    else if (name.endsWith(".zip"))
    {
      return new ZipTableReader(new ZipFile(file));
    }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.