将Excel指定位置的信息读取出来
步骤
建立File文件获取相应文件建立Workbook文件获取相应table循环遍历文件内容
public void display(String name){
File file =
new File(
"/data/aa"+name+
".xls");
try{
Workbook book = Workbook.getWorkbook(file);
Sheet sheet = book.getSheet(
0);
for(
int i =
0;i < sheet.getColumns();i++){
System.out.print(sheet.getCell(i,
0).getContents()+
"\t");
}
System.out.println();
for(
int i =
6;i < sheet.getRows(); i++){
for(
int j =
0; j < sheet.getColumns(); j++){
System.out.print(sheet.getCell(j, i).getContents()+
"\t");
}
System.out.println();
}
}
catch(Exception e){
e.printStackTrace();
}
}
