Android 本地assets文件夹中放xls 表单数据然后读取显示。按拼音分组显示，最后再模糊检索显示

按照字母分组显示

1、用到第三方的两个类库， 读取xls类库和按照拼音排列分组显示类库导入gradle,

    implementation 'cc.solart:turbo-recyclerview-helper:1.0.3-beta'
    implementation 'se.emilsjolander:stickylistheaders:2.7.0'
    implementation 'com.github.rey5137:material:1.3.1'
    implementation 'com.belerweb:pinyin4j:2.5.1'   //按照拼音排列分组显示类库
    implementation 'net.sourceforge.jexcelapi:jxl:2.6.12'  //读取xls类库
 

2、自定义一个实体类 UniversitiesModel 实现Comparable类的接口，

/**
 * @ClassName UniversitiesModel
 * @Description TODO
 * @Author SeanLim
 * @Date 2021-9-17 10:04
 * @E-mail linlin.1016@qq.com
 * @Version 1.0
 */
public class UniversitiesModel implements Comparable<UniversitiesModel> {
    private String universitiesName;
    private String pinyin;
    private String firstLetter;
    public UniversitiesModel(String UniversitiesName) {
        this.universitiesName = UniversitiesName;
        pinyin = PYHelper.getPinYin(UniversitiesName); // 学校名拼音
        firstLetter = pinyin.substring(0, 1).toUpperCase(); // 获取拼音首字母并转成大写
        if (!firstLetter.matches("[A-Z]")) { // 如果不在A-Z中则默认为“#”
            firstLetter = "#";
        }
    }

    public String getUniversitiesName() {
        return universitiesName;
    }

    public String getPinyin() {
        return pinyin;
    }

    public String getFirstLetter() {
        return firstLetter;
    }

    @Override
    public int compareTo(UniversitiesModel another) {
        if (firstLetter.equals("#") && !another.getFirstLetter().equals("#")) {
            return 1;
        } else if (!firstLetter.equals("#") && another.getFirstLetter().equals("#")){
            return -1;
        } else {
            return pinyin.compareToIgnoreCase(another.getPinyin());
        }
    }
}

3、用线程获取xls里数据填充到RecyclerView 列表中

 /**
         * 线程获取xls学校数据
         */
        new Thread(() -> {
            AssetManager localAssetManager = getAssets();
            try {
                Workbook localWorkbook = Workbook.getWorkbook(localAssetManager.open("universities.xls"));
                Sheet localSheet = localWorkbook.getSheet(0);    //下游标取值
                int j = localSheet.getRows();
                for (int m = 0; m < j; m++) {
                    universitiesModels.add(new UniversitiesModel(localSheet.getCell(1, m).getContents() + "id" + localSheet.getCell(0, m).getContents()));
                }
                localWorkbook.close();
            } catch (Exception localException) {
            }

            // 获取完之后更新UI界面
            runOnUiThread(() -> {
                Collections.sort(universitiesModels);
                schoolAdapter = new SchoolAdapter(this, universitiesModels);
                listView.setDivider(null);
                listView.setAdapter(schoolAdapter);
                loadingProgress.setVisibility(View.GONE);
            });
        }).start();

4、最后就是模糊搜索数据，从xls获取到的数据 List 去对比找学校名称,return results得到的就是从List 索引到的全部数据。

 /**
     * 模糊搜索数据
     */
    public List search(String name, List list) {
        List results = new ArrayList();
        Pattern pattern = Pattern.compile(name);
        for (int i = 0; i < list.size(); i++) {
            Matcher matcher = pattern.matcher(universitiesModels.get(i).getUniversitiesName());
            if (matcher.find()) {
                results.add(list.get(i));
            }
        }
        searchModels.addAll(results);
        return results;
    }

微信图片_20210918222914.jpg 搜索后结果

最后就完成从xls 表格中读取数据，按照字母排序显示和搜索显示。