/*獲取excel表格中的數(shù)據(jù)不能在主線程中調(diào)用   xlsName 為表格的名稱   index 表示第幾張表格   */  public ArrayList<ExcelBean> getExcelData(String xlsName, int index) {    ArrayList<ExcelBean> list = new ArrayList<>();    //獲取文件管理器    AssetManager manager = context.getAssets();    try {      Workbook workbook = Workbook.getWorkbook(manager.open(xlsName));      Sheet sheet = workbook.getSheet(index);      //表格一共有多少行      int sheetRows = sheet.getRows();      //將數(shù)據(jù)添加到集合中      for (int i = 0; i < sheetRows; i++) {        ExcelBean bean = new ExcelBean();        //獲取列的數(shù)據(jù)        bean.setChinese(sheet.getCell(0, i).getContents());        bean.setEnglish(sheet.getCell(1, i).getContents());        bean.setSpell(sheet.getCell(2, i).getContents());        list.add(bean);      }      workbook.close();    } catch (Exception e) {      e.printStackTrace();    }    return list;  }

public class ExcelDataAsyncTask extends AsyncTask<String, Void, ArrayList<ExcelBean>> {  private Context context;  private int index;  private ExcelData excelData;  public ExcelDataAsyncTask(Context context, int index, ExcelData excelData) {    this.context = context;    this.index = index;    this.excelData = excelData;  }  @Override  protected ArrayList<ExcelBean> doInBackground(String... params) {    return getExcelData(params[0], index);  }  @Override  protected void onPostExecute(ArrayList<ExcelBean> excelBeen) {    super.onPostExecute(excelBeen);    if (excelBeen != null && excelBeen.size() > 0) {//      ExcelAdapter adapter=new ExcelAdapter(excelBeen,context);//      lv.setAdapter(adapter);      excelData.getData(excelBeen);    }  }

/利用接口回調(diào),更新UI  public interface ExcelData {    void getData(ArrayList<ExcelBean> list);  }

 new ExcelDataAsyncTask(ExcelSecondActivity.this, mp3Id, new ExcelDataAsyncTask.ExcelData() {      @Override      public void getData(final ArrayList<ExcelBean> list) {        ExcelAdapter adapter = new ExcelAdapter(list, ExcelSecondActivity.this);        lv.setAdapter(adapter);        lv.setOnItemClickListener(new AdapterView.OnItemClickListener() {          @Override          public void onItemClick(AdapterView<?> parent, View view, int position, long id) {             }        });      }    }).execute("excel.xls");