Android读取excel文件内容

/**
     * 读取excel文件内容
     * @throws Exception
     */
    public void readExcel() throws Exception 
    {
        try {
            Workbook book = Workbook.getWorkbook(getAssets().open("target.xls"));
            try 
            {
                Sheet sheet = book.getSheet(0);
                int rows = sheet.getRows();
                int columns = 4;
                for (int i = 2; i < rows; i++) 
                {
                    Addr addr = new AddressBean().new Addr();
                    for (int j = 0; j < columns; j++) 
                    {
                        String cell = sheet.getCell(j, i).getContents(); 
                        switch (j) 
                        {
                            case 0:
                                addr.setId(cell);
                                break;

                            case 1:
                                addr.setpId(cell);
                                break;

                            case 2:
                                addr.setGrade(cell);
                                break;

                            case 3:
                                addr.setName(cell);
                                break;
                        }
                    }
                    addrs.add(addr);
                }
                AddressBean bean = new AddressBean();
                bean.setAddrs(addrs);
                String json = GsonUtil.bean2json(bean);
                PrefUtils.putString(instance, "target", json);
            } 
            finally 
            {
                if (book != null) 
                {
                    book.close();
                }
            }

        } catch (BiffException e) {
            System.err.println(e + "");
        } catch (IOException e) {
            System.err.println(e + "文件读取错误");
        }
    }

需要导入第三方包:jxl-2.6.jar