java怎么用map，list从excel中读取表数据

Question

不会写，求高手代码实现！
可以的话，再加一个测试main方法

Answer 1

可参考如下：
public class Test3{
public static void main(String[] args) throws Exception {
Workbook workbook=null;
String columnName[] = {"姓名","年龄","住址"};
for(int i=0;i System.err.print(columnName[i]+"\t");
}
System.out.println();
Sheet sheet=null;
TreeMap map = new TreeMap();
InputStream input=new FileInputStream("D://tt.xls");
workbook =Workbook.getWorkbook(input);
sheet=workbook.getSheet(0);

for (int i = 0; i <sheet.getColumns(); i++) {
String []str=new String[sheet.getRows()];

for (int j = 0; j <sheet.getRows(); j++) {
    Cell cell=sheet.getCell(i,j);
   str[j]=cell.getContents();
  }
  map.put(columnName[i], str);
}

for (int i = 0, j=0; i<map.get(columnName[j]).length; i++) {
for ( j = 0; j < map.size(); j++) {
System.out.print(map.get(columnName[j])[i]+"\t");
}
j=0;
System.out.println();
}
}
}