java 解析xls excel格式文件

[java]代码库

/**
     * 解析DBF文件
     * @param in
     * @return List<Map<String,String>> columns通过AMF编码之后的字符串
     * @throws Exception
     */
    public static String parseDbf2Map(InputStream in)throws Exception {

        DBFReader dbfreader = new DBFReader(in);
        dbfreader.setCharactersetName("GB2312");

        List<Map<String,String>> columns = new ArrayList<Map<String,String>>();
        Map<String,String> head = new HashMap<String,String>();
        //解析DBF表头的信息
        Map dataType = new HashedMap();
        for(int i = 0; i < dbfreader.getFieldCount(); i++) {
            DBFField field = dbfreader.getField(i);
            byte type = field.getDataType();
            int decimal = 0;
            int length = 0;
            String formatString = "";
            if(DBFField.FIELD_TYPE_N == type || DBFField.FIELD_TYPE_F == type){
                 decimal = field.getDecimalCount();
                 length = field.getFieldLength();
                 for (int j = 0; j < (length - decimal); j++) {
                     formatString +="#";
                 }
                 if(decimal != 0){
                     formatString = formatString + "0.";
                 }
                 for (int jj = 0; jj < decimal; jj++) {
                     formatString +="0";
                }
                 dataType.put(""+i, formatString);
            }
            if(DBFField.FIELD_TYPE_D == type){
                formatString = "yyyy/MM/dd";
                dataType.put(""+i, formatString);
            }

            String name = field.getName();

            head.put(""+i, name);
        }
        columns.add(head);
        Object[] rowObj = null;
        int k = 1;
        while ((rowObj = dbfreader.nextRecord()) != null) {
            Map<String,String> data = new HashMap<String,String>();
            for (int i = 0; i < rowObj.length; i++) {
                Object temp = rowObj[i];
                String dataTypeFormat = (String)dataType.get(""+i);
                if(dataTypeFormat != null){
                    if(dataTypeFormat.indexOf("yyyy") !=-1){
                        SimpleDateFormat format = new SimpleDateFormat(dataTypeFormat);
                        temp = format.format((Date)temp);
                    }else {
                        DecimalFormat format = new DecimalFormat(dataTypeFormat);
                        temp = format.format(temp);
                    }
                }
                data.put(dbfreader.getField(i).getName(), temp.toString());
            }
            columns.add(data);
            k++;
        }

        //编码：
        AmfSerializer amfSerializer = new AmfSerializer();
        String str = amfSerializer.toAmf(columns);
        return str;
    }

//源代码片段来自云代码http://yuncode.net