读取excel2

/**
* 是否有下一行
*/
@Override
public boolean hasNext() {
if (this.rowNum == 0 || this.curRowNo >= this.rowNum) {
book.close();
return false;
}
if (this.singleline > 0 && this.curRowNo > this.singleline) {
book.close();
return false;
}


return true;
}


/**
* 得到下一行
*/
@Override
public Object[] next() {
Cell[] c = sheet.getRow(this.curRowNo);
Map<String, Object> s = new LinkedHashMap<String, Object>();


for (int i = 0; i < this.columnNum; i++) {
String data = c[i].getContents().toString();
if (data.trim().endsWith("}}]]") && data.trim().startsWith("[[{{"))
s.put(this.columnnName[i], getSubTable(data.trim()));
else
s.put(this.columnnName[i], data);
}
this.curRowNo++;
return new Object[] { s };
}


/**
* 不使用remove，未实现
*/
@Override
public void remove() {
throw new UnsupportedOperationException("remove unsupported.");
}


@SuppressWarnings("unchecked")
private List<?> getSubTable(String key) {
List<Object> list = new LinkedList<Object>();
String classname = "";
String sheetname = "";
String id = "";
try {


String str = key.substring(4, key.length() - 4);


for (String s : str.split(",")) {
String[] keyValueStrings = s.split(":");
if (keyValueStrings.length == 2) {
int beginF = keyValueStrings[0].indexOf("\"") + 1;
int endF = keyValueStrings[0].lastIndexOf("\"");
if (endF > beginF) {
String subkey = keyValueStrings[0].substring(beginF, endF);
beginF = keyValueStrings[1].indexOf("\"") + 1;
endF = keyValueStrings[1].lastIndexOf("\"");
if (subkey.equalsIgnoreCase("classname") && endF > beginF) {
classname = keyValueStrings[1].substring(beginF, endF);
}
if (subkey.equalsIgnoreCase("sheetname") && endF > beginF) {
sheetname = keyValueStrings[1].substring(beginF, endF);
}
if (subkey.equalsIgnoreCase("id") && endF > beginF) {
id = keyValueStrings[1].substring(beginF, endF);
}
}
}


}
if (sheetname.length() < 1) {
throw new Exception("无法获取sheetname");


}
if (sheetname.length() < 1) {
throw new Exception("无法获取id");
}


// JSONArray jsonObjArray = new JSONArray("[{" + key.substring(4, key.length() - 4) + "}]");
// JSONObject jsonObj = jsonObjArray.optJSONObject(0);
// if (checkKey(jsonObj, "classname"))
// classname = jsonObj.getString("classname");
// id = jsonObj.getString("id");
// sheetname = jsonObj.getString("sheetname");
} catch (Exception ex) {
LOG4J_LOGGER.error("数据异常", ex);
return list;
}


SubTableProvider subTableProvider = new SubTableProvider(book.getSheet(sheetname));


while (subTableProvider.hasNext()) {
Object[] d = subTableProvider.next();
if (d[0].toString().trim().equals(id)) {
if (classname == null || classname.trim().length() == 0) {
list.addAll((List<Map<String, String>>) d[1]);
} else {
for (Map<String, String> tempMap : (List<Map<String, String>>) d[1]) {
Object bean;
try {
bean = (Class.forName(classname)).newInstance();
BeanUtils.populate(bean, tempMap);
list.add(bean);
} catch (Exception ex) {
LOG4J_LOGGER.error("数据异常转换", ex);
return list;
}
}
}
break;
}
}
return list;
}


// private boolean checkKey(JSONObject jsonObj, String key) {
//
// for (String s : JSONObject.getNames(jsonObj))
// if (key.equals(s))
// return true;
// return false;
// }


private Method locateTestMethod(Object objectname, String methodname) {
try {
Method[] arrayOfMethod1 = objectname.getClass().getDeclaredMethods();
Method[] arrayOfMethod2 = arrayOfMethod1;
int j = arrayOfMethod2.length;
int k = 0;
while (k < j) {
Method localMethod = arrayOfMethod2[k];


if (localMethod.getName().equals(methodname)) {
return localMethod;
}
++k;
}
} catch (Throwable ex) {
LOG4J_LOGGER.error("不正确的方法名", ex);
}
return null;
}


class SubTableProvider implements Iterator<Object[]> {


private Sheet subSheet = null;
private int subSheetRowNum = 0;
private int curPhysicalRowNo = 0;
private final String[] subSheetColumnnName;


public SubTableProvider(Sheet sheet) {
this.subSheet = sheet;
this.subSheetRowNum = sheet.getRows();
Cell[] c = sheet.getRow(0);
subSheetColumnnName = new String[c.length];
for (int i = 0; i < c.length; i++) {
subSheetColumnnName[i] = c[i].getContents().toString().replace("\n", "");
}
this.curPhysicalRowNo++;
}


@Override
public boolean hasNext() {
if (this.subSheetRowNum == 0 || this.curPhysicalRowNo >= this.subSheetRowNum) {
return false;
}
return true;
}


@Override
public Object[] next() {
Object r[] = new Object[2];
List<HashMap<String, String>> list = new ArrayList<HashMap<String, String>>();
int RangeRow = 1;
boolean ThisIsRange = false;
jxl.Range[] ranges = subSheet.getMergedCells();
// 首先要确定第一列占了几行，要区分 Range 还是 Row
for (jxl.Range space : ranges) {
if (space.getTopLeft().getColumn() == 0 && space.getBottomRight().getColumn() == 0
&& space.getTopLeft().getRow() == this.curPhysicalRowNo) {
RangeRow = space.getBottomRight().getRow() - space.getTopLeft().getRow() + 1;
ThisIsRange = true;
break;
}
}
// 获取第一列的值
String key = "";
if (ThisIsRange) {
key = subSheet.getRow(this.curPhysicalRowNo)[0].getContents().toString();
} else {
key = subSheet.getRow(this.curPhysicalRowNo)[0].getContents().toString();
}
// 从第二列开始转换为list<map>
if (ThisIsRange) {
for (int j = 0; j < RangeRow; j++) {
Map<String, String> tempMap = new HashMap<String, String>();
for (int i = 1; i < this.subSheetColumnnName.length; i++) {
tempMap.put(this.subSheetColumnnName[i], subSheet.getRow(this.curPhysicalRowNo + j)[i].getContents().toString());
}
list.add((HashMap<String, String>) tempMap);
}


} else {
Map<String, String> tempMap = new HashMap<String, String>();
for (int i = 1; i < this.subSheetColumnnName.length; i++) {
tempMap.put(this.subSheetColumnnName[i], subSheet.getRow(this.curPhysicalRowNo)[i].getContents().toString());
}
list.add((HashMap<String, String>) tempMap);
}


r[0] = key;
r[1] = list;
this.curPhysicalRowNo = this.curPhysicalRowNo + RangeRow;
return r;
}


@Override
public void remove() {
throw new UnsupportedOperationException("remove unsupported.");
}


}


// String中截取数字
private String getNumbers(String content) {
Pattern pattern = Pattern.compile("\\d+");
Matcher matcher = pattern.matcher(content);
while (matcher.find()) {
return matcher.group(0);
}
return "";
}


public String[] getFileName(String path) {
File file = new File(path);
String[] fileName = file.list();
return fileName;
}
}