android excel读取文件名,如何从XLS(Excel)文件中读取数据[Java,Android]

嗨,你只需要包含一个外部jxl jar,你可以通过同一个教程,这将帮助您了解阅读excel文件的过程..为了您的参考我粘贴一些参考.代码读取第一页excel并创建一个结果集.

public List read(String key) throws IOException {

List resultSet = new ArrayList();

File inputWorkbook = new File(inputFile);

if(inputWorkbook.exists()){

Workbook w;

try {

w = Workbook.getWorkbook(inputWorkbook);

// Get the first sheet

Sheet sheet = w.getSheet(0);

// Loop over column and lines

for (int j = 0; j < sheet.getRows(); j++) {

Cell cell = sheet.getCell(0, j);

if(cell.getContents().equalsIgnoreCase(key)){

for (int i = 0; i < sheet.getColumns(); i++) {

Cell cel = sheet.getCell(i, j);

resultSet.add(cel.getContents());

}

}

continue;

}

} catch (BiffException e) {

e.printStackTrace();

} catch (Exception e) {

e.printStackTrace();

}

}

else

{

resultSet.add("File not found..!");

}

if(resultSet.size()==0){

resultSet.add("Data not found..!");

}

return resultSet;

}