Android 读取excel（支持 xls）和 xml

最新推荐文章于 2025-06-14 11:40:48 发布

原创最新推荐文章于 2025-06-14 11:40:48 发布 · 4.1k 阅读

13 ·

CC 4.0 BY-SA版权

文章标签：

#excel #xml

android 专栏收录该内容

50 篇文章

订阅专栏

本文介绍如何在Android应用中使用jxl库读取Excel文件，并利用XmlPullParser解析XML资源文件。通过具体代码示例展示了从assets文件夹加载文件的过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

一、使用jxl 读取excel文件

1.build.gradle的dependencies中加入

implementation 'net.sourceforge.jexcelapi:jxl:2.6.12'

2.将xls文件复制到assets文件夹

3.读取文件内容：

public static List<ContentBean> readExcelToAssets(Context context) {
        List<ContentBean> contentBeans = new ArrayList<>();
        try {
            InputStream is = context.getAssets().open("App.xls");
            Workbook book = Workbook.getWorkbook(is);
            book.getNumberOfSheets();
            Sheet sheet = book.getSheet(0);
            int Rows = sheet.getRows();

            for (int i = 1; i < Rows; ++i) {
                String key = (sheet.getCell(0, i)).getContents();
                List<String> values = new ArrayList<>();
                String value1 = (sheet.getCell(1, i)).getContents();
                values.add(value1);
                String value2 = (sheet.getCell(2, i)).getContents();
                values.add(value2);
                String value3 = (sheet.getCell(3, i)).getContents();
                values.add(value3);
                String value4 = (sheet.getCell(4, i)).getContents();
                values.add(value4);
                String value5 = (sheet.getCell(5, i)).getContents();
                values.add(value5);
                contentBeans.add(new ContentBean(key, values));
                Log.e("FileUtil", "第" + i + "行数据=\n" + key + "," + value1 + "," + value2 + "," + value3 + "," + value4 + "," + value5);

            }
            book.close();

        } catch (Exception e) {

            Log.e("FileUtil", "e" + e);
        }
        return contentBeans;
    }

二、使用XmlPullParser读取xml文件

1.将xml文件复制到assets文件夹

2.读取文件内容：

/**
     * 获取XML中所有的指令信息
     * xml文件内容：
     * <resources>
     *     <string name="app_name">APP</string>
     * </resources>
     */
    public static List<LanguageBean> parseDateSource(Context context) {
        List<LanguageBean> languageBeans = new ArrayList<>();
        try {
            InputStream inputStream = context.getAssets().open("strings.xml");
            XmlPullParser parse = Xml.newPullParser();
            parse.setInput(inputStream, "utf-8");
            int event = parse.getEventType();
            while (event != XmlPullParser.END_DOCUMENT) {
                switch (event) {
                    case XmlPullParser.START_DOCUMENT:
                        Log.e("FileUtil", "parseDateSource 初始化指令集合");
                        break;
                    case XmlPullParser.START_TAG:
                        String keys = parse.getName();
                        // <string name="app_name">APP</string>
                        // 读取string标签下的值，key = app_name,value = APP
                        if (keys.equals("string")) {
                            String key = parse.getAttributeValue(null, "name");
                            String value = parse.nextText();
                            Log.e("FileUtil", "START_TAG " + key + "," + value);
                            languageBeans.add(new LanguageBean(key, value));
                        } else {
                            Log.e("FileUtil", "START_TAG keys " + keys);
                        }
                        break;
                    case XmlPullParser.END_TAG:
                        Log.e("FileUtil", "END_TAG");
                        break;
                    default:
                        break;
                }
                event = parse.next();// 进入到下一个元素并触发相应事件
            }
        } catch (IOException e) {
            e.printStackTrace();
        } catch (XmlPullParserException e) {
            e.printStackTrace();
        }
        return languageBeans;
    }

完整的FileUtil工具类：

package com.file.util.file;

import android.content.Context;
import android.os.Build;
import android.os.Environment;
import android.text.TextUtils;
import android.util.Log;
import android.util.Xml;

import androidx.annotation.RequiresApi;

import com.file.util.MainActivity;
import com.file.util.bean.ContentBean;
import com.file.util.bean.LanguageBean;

import org.xmlpull.v1.XmlPullParser;
import org.xmlpull.v1.XmlPullParserException;

import java.io.BufferedWriter;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStreamWriter;
import java.util.ArrayList;
import java.util.List;

import jxl.Sheet;
import jxl.Workbook;

/**
 * @Author: Jin
 * @Description:
 * @CreateDate: 2022/11/17  16:34
 */
public class FileUtil {

    public static void readExcel(Context context) {
        String logFilePath = Environment.getExternalStorageDirectory() + File.separator + "Visitor";
        File file = new File(logFilePath, "test.xls");
        Log.e("FileUtil", "file=" + file.getAbsolutePath());
        try {
            InputStream is = new FileInputStream(file);
            Workbook book = Workbook.getWorkbook(is);
            book.getNumberOfSheets();
            Sheet sheet = book.getSheet(0);
            int Rows = sheet.getRows();

            for (int i = 1; i < Rows; ++i) {
                String name = (sheet.getCell(0, i)).getContents();
                String department = (sheet.getCell(1, i)).getContents();
                String company = (sheet.getCell(2, i)).getContents();
                String phone = (sheet.getCell(3, i)).getContents();

                Log.e("FileUtil", "第" + i + "行数据=" + name + "," + department + "," + company + "," + phone);

            }
            book.close();

        } catch (Exception e) {

            Log.e("FileUtil", "e" + e);
        }
    }

    public static List<ContentBean> readExcelToAssets(Context context) {
        List<ContentBean> contentBeans = new ArrayList<>();
        try {
            InputStream is = context.getAssets().open("App.xls");
            Workbook book = Workbook.getWorkbook(is);
            book.getNumberOfSheets();
            Sheet sheet = book.getSheet(0);
            int Rows = sheet.getRows();

            for (int i = 1; i < Rows; ++i) {
                String key = (sheet.getCell(0, i)).getContents();
                List<String> values = new ArrayList<>();
                String value1 = (sheet.getCell(1, i)).getContents();
                values.add(value1);
                String value2 = (sheet.getCell(2, i)).getContents();
                values.add(value2);
                String value3 = (sheet.getCell(3, i)).getContents();
                values.add(value3);
                String value4 = (sheet.getCell(4, i)).getContents();
                values.add(value4);
                String value5 = (sheet.getCell(5, i)).getContents();
                values.add(value5);
                contentBeans.add(new ContentBean(key, values));
                Log.e("FileUtil", "第" + i + "行数据=\n" + key + "," + value1 + "," + value2 + "," + value3 + "," + value4 + "," + value5);

            }
            book.close();

        } catch (Exception e) {

            Log.e("FileUtil", "e" + e);
        }
        return contentBeans;
    }

    /**
     * 获取XML中所有的指令信息
     * xml文件内容：
     * <resources>
     *     <string name="app_name">APP</string>
     * </resources>
     */
    public static List<LanguageBean> parseDateSource(Context context) {
        List<LanguageBean> languageBeans = new ArrayList<>();
        try {
            InputStream inputStream = context.getAssets().open("strings.xml");
            XmlPullParser parse = Xml.newPullParser();
            parse.setInput(inputStream, "utf-8");
            int event = parse.getEventType();
            while (event != XmlPullParser.END_DOCUMENT) {
                switch (event) {
                    case XmlPullParser.START_DOCUMENT:
                        Log.e("FileUtil", "parseDateSource 初始化指令集合");
                        break;
                    case XmlPullParser.START_TAG:
                        String keys = parse.getName();
                        // <string name="app_name">APP</string>
                        // 读取string标签下的值，key = app_name,value = APP
                        if (keys.equals("string")) {
                            String key = parse.getAttributeValue(null, "name");
                            String value = parse.nextText();
                            Log.e("FileUtil", "START_TAG " + key + "," + value);
                            languageBeans.add(new LanguageBean(key, value));
                        } else {
                            Log.e("FileUtil", "START_TAG keys " + keys);
                        }
                        break;
                    case XmlPullParser.END_TAG:
                        Log.e("FileUtil", "END_TAG");
                        break;
                    default:
                        break;
                }
                event = parse.next();// 进入到下一个元素并触发相应事件
            }
        } catch (IOException e) {
            e.printStackTrace();
        } catch (XmlPullParserException e) {
            e.printStackTrace();
        }
        return languageBeans;
    }

    public static List<String> makeContent(Context context, int type) {
        List<String> contents = new ArrayList<>();
        List<LanguageBean> languageBeans = FileUtil.parseDateSource(context);
        List<ContentBean> contentBeans = FileUtil.readExcelToAssets(context);
        // 寻找语言
        for (LanguageBean languageBean : languageBeans) {
            for (ContentBean contentBean : contentBeans) {
                if (TextUtils.equals(languageBean.getValue(), contentBean.getKey())) {
                    if (contentBean.getValues().size() > type) {
                        languageBean.setValue(contentBean.getValues().get(type));
                    }
                    break;
                }
            }
        }
        // 组装结果
        for (LanguageBean languageBean : languageBeans) {
            String content = "<string name=\"" + languageBean.getKey() + "\">" + languageBean.getValue() + "</string>";
            Log.i("FileUtil", "makeContent " + content);
            contents.add(content);
        }
        return contents;
    }

    @RequiresApi(api = Build.VERSION_CODES.KITKAT)
    public static void saveXML(Context context, int type) {
        File file = Environment.getExternalStoragePublicDirectory(Environment.DIRECTORY_DOCUMENTS + "/RedKey/language/");
        if (!file.exists()) {
            file.mkdirs();
        }

        BufferedWriter out = null;
        try {
            out = new BufferedWriter(new OutputStreamWriter(new FileOutputStream(file.getAbsoluteFile() + "/" + "language_" + getLanguageName(type) + ".txt", true)));
            List<String> contents = makeContent(context, type);
            for (String content : contents) {
                out.write(content + "\n");
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            try {
                out.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
    }

    private static String getLanguageName(int type) {
        String languageName = "";
        switch (type) {
            case 0:
                languageName = "en";
                break;
            case 1:
                languageName = "ru";
                break;
            case 2:
                languageName = "de";
                break;
            case 3:
                languageName = "fr";
                break;
            case 4:
                languageName = "pl";
                break;
        }
        return languageName;
    }
}