Android利用JXL框架读取excel

来源：互联网发布：git ignore mac 编辑：程序博客网时间：2024/06/06 00:35

1、近期要用到读取Excel文档的工具

2、我先是用了POI框架，干到最后，发现不支持Android平台，一直报ClassNotFoundExcepiton，差点把兄弟坑死。

3、最后用了JXL框架，这个框架用起来也挺简单，excel文件->输入字节流->生成封装Excel对象->找到每一个Sheet->再找到一行一列的值，用起来还是很简单的，缺点就是仅支持97-2003的excel格式，即xls格式………………

我这个工具类比较low啊，只是读取了每行的第一列的值，然后存储的List中……………………………………………………没办法需求就是这么简单啊！

public class ReadExcel {    private static final String TAG = "ReadExcel";    private Workbook mWorkbook;    private Sheet mSheet1;    private InputStream mInputStream;    private Context context;    private List<String> mUrls;    public ReadExcel(Context context) {        this.context = context;        init();    }    private void init() {        mUrls = new ArrayList<>();    }    public List<String> readFirstCell(int rawId) {        try {            mInputStream = context.getResources().openRawResource(rawId);            mWorkbook = Workbook.getWorkbook(mInputStream);            Log.d(TAG, "mInputStream = " + mInputStream);            mSheet1 = mWorkbook.getSheet(0);        } catch (BiffException e) {            e.printStackTrace();        } catch (IOException e) {            e.printStackTrace();        } finally {            try {                mInputStream.close();            } catch (IOException e) {                e.printStackTrace();            }        }        for (int i = 0; i < mSheet1.getRows(); i++) {            Cell everyCell = mSheet1.getCell(0, i);            String temp = everyCell.getContents();            Log.d(TAG, "temp = " + temp);            mUrls.add(temp);        }        return mUrls;    }}

1 0