private void IncludingData() {
Workbook workbook= null;
InputStream open = null;
try {
//这是安卓获取SD卡的文件
File file = new File(Environment.getExternalStorageDirectory().getAbsolutePath()+"/测试.xls");
open=new FileInputStream(file);
workbook=Workbook.getWorkbook(open);
workbook.getSheets();//获取表格的每一个Sheet
Sheet sheet = workbook.getSheet(0);//获取第一个Sheet
int rows = sheet.getRows();//获取表格行数
for(int i=0;i<rows;i++){
Cell[] sheetRow=sheet.getRow(i);
for(int j=0;j<sheetRow.length;j++){
String contents = sheetRow[j].getContents();//每行的数据
Log.d("biaoges",contents);
}
}
} catch (IOException e) {
e.printStackTrace();
} catch (BiffException e) {
e.printStackTrace();
}
}
xls表格
解析出来的数据