如何从XLS（Excel）文件中读取数据[Java，Android] [英] How to read data from XLS (Excel) file [Java, Android]

问题描述

我搜索过stackoverflow但是我找不到明确的答案。如何从XLS文件的特定行和列中读取数据到我的Android应用程序？我怎样才能读取XLS文件？我不想将其转换为CSV，因为当我尝试转换它时会出现错误。

I have searched stackoverflow but I didn't find a clear answer. How can I read data from particular rows and columns of XLS file to my Android application? How can I read XLS file? I don't want to convert it to CSV because I get errors when I try to convert them.

也许我可以使用这个 http ：//www.andykhan.com/jexcelapi/tutorial.html#reading 但我甚至不知道如何将其导入我的项目中。请帮助。

Maybe I could use this http://www.andykhan.com/jexcelapi/tutorial.html#reading but I even don't know how could I import it into my project. Please help.

推荐答案

您只需要包含一个外部jxl jar，您可以通过相同的教程来帮助您了解阅读excel文件的过程..为了你的回复，我正在粘贴一些参考文献。代码，它读取第一张excel表并创建结果集。

Hi you just need to include an external jxl jar and you can go through the same tutorial which will help you understand the process of reading excel files.. for your referance i am pasting some ref. code which reads very first sheet of excel and creates a resultset.

    public List<String> read(String key) throws IOException  {
    List<String> resultSet = new ArrayList<String>();

    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;
}

这篇关于如何从XLS（Excel）文件中读取数据[Java，Android]的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！