java - 使用jxl进行Excel解析

我使用jxl读取.xls文件，以下是解析xls文件的代码。它工作正常，但问题是当我插入日期字段时，它仅读取年份的最后两位数字。例如，如果我输入12/13/2088和12/13/1988。两者都将显示为12/13/88。有没有解决这个问题的办法。我可以格式化Excel单元格或更改当前代码吗？

ArrayList listDet=new ArrayList();
    HashMap mapDet=null;
    HashMap primeDetails=new HashMap();

    WorkbookSettings ws = null;
    Workbook workbook = null;
    Sheet s = null;
    Cell rowData[] = null;
    int rowCount = '0';
    int columnCount1 = '0';
    int columnCount = '0';
    DateCell dc = null;
    int totalSheet = 0;

    try {
        ws = new WorkbookSettings();
        ws.setLocale(new Locale("en", "EN"));
        ws.setCellValidationDisabled(true);

        workbook = Workbook.getWorkbook(fileInputStream, ws);

        totalSheet = workbook.getNumberOfSheets();
        //Getting Default Sheet i.e. 0
        s = workbook.getSheet(0);

        //Total Total No Of Rows in Sheet, will return you no of rows that are occupied with some data
        System.out.println("Total Rows inside Sheet:" + s.getRows());
        rowCount = s.getRows();

        //Total Total No Of Columns in Sheet
        System.out.println("Total Column inside Sheet:" + s.getColumns());
        columnCount = s.getColumns();


        //Reading Individual Row Content
        for (int i = 0; i <rowCount ; i++) {
            //Get Individual Row
            rowData = s.getRow(i);
                mapDet=new HashMap();
                mapDet.put("col1",rowData[0].getContents());
                mapDet.put("col2",rowData[1].getContents());
                mapDet.put("col3",rowData[2].getContents());
                mapDet.put("col4",rowData[3].getContents());
                mapDet.put("col5",rowData[4].getContents());
                mapDet.put("col6",rowData[5].getContents());
                mapDet.put("col7",rowData[6].getContents());
                mapDet.put("col8",rowData[7].getContents());
                mapDet.put("col9",rowData[8].getContents());

                listDet.add(mapDet);



    }
        workbook.close();
    } catch (IOException e) {
        e.printStackTrace();
    } catch (BiffException e) {
        e.printStackTrace();
    }
    catch(Exception exp)
    {

        exp.printStackTrace();
    }

最佳答案

根据javadocs/2_6_10/docs/jxl/Cell的方法:
getContents()是一个
“快速而肮脏的函数以字符串形式返回此单元格的内容。”

由于 getContents()不允许完全控制格式，
您可以定义自己的函数来控制CellType.DATE的格式；
例如:

 private String getContents(Cell cell) {
    DateCell dCell=null;
    if(cell.getType() == CellType.DATE)
    {
      dCell = (DateCell)cell;
      // System.out.println("Value of Date Cell is: " + dCell.getDate());
      // ==> Value of Date Cell is: Thu Apr 22 02:00:00 CEST 2088
      SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");
      // System.out.println(sdf.format(dCell.getDate()));
      // ==> 2088-04-22
      return sdf.format(dCell.getDate());
    }
    // possibly manage other types of cell in here if needed for your goals
    // read more: http://www.quicklyjava.com/reading-excel-file-in-java-datatypes/#ixzz2fYIkHdZP
    return cell.getContents();
}

那么您只需要根据调用自己的私有函数来更改代码即可:

mapDet.put("col1", getContents(rowData[0]));
mapDet.put("col2", getContents(rowData[1]));
mapDet.put("col3", getContents(rowData[2]));
mapDet.put("col4", getContents(rowData[3]));
mapDet.put("col5", getContents(rowData[4]));
mapDet.put("col6", getContents(rowData[5]));
mapDet.put("col7", getContents(rowData[6]));
mapDet.put("col8", getContents(rowData[7]));
mapDet.put("col9", getContents(rowData[8]));

代替

mapDet.put("col1",rowData[0].getContents());
...
mapDet.put("col9",rowData[8].getContents());

关于java - 使用jxl进行Excel解析，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/13506015/