Android创建Excel表格

原创

已于 2022-12-02 15:14:08 修改 · 2.8k 阅读

7 ·

CC 4.0 BY-SA版权

文章标签：

#android #excel

于 2022-12-02 15:02:47 首次发布

在Android开发中有时候我们需要将数据直接生成Excel表格并导出，

方法如下：
1.下载jxl-2.6.12.jar包：放置到Android项目的libs文件夹下，并引用依赖
2.将自己要存入表格的数据，抽象成一个实体类，例如：FaceTestEntity
3.调用jxl这个jar包的Api，生成表格，设置样式，写入数据，导出表格。

我将生成表格的代码封装成了工具类，需要的同学可以拿到直接使用，或根据自身需求修改样式参数：


public class ExcelUtil {

    private static WritableFont arial14font = null;

    private static WritableCellFormat arial14format = null;
    private static WritableFont arial10font = null;
    private static WritableCellFormat arial10format = null;
    private static WritableFont arial12font = null;
    private static WritableCellFormat arial12format = null;
    private final static String UTF8_ENCODING = "UTF-8";

    /**
     * 单元格的格式设置 字体大小 颜色 对齐方式、背景颜色等...
     */
    private static void format() {
        try {
            arial14font = new WritableFont(WritableFont.ARIAL, 14, WritableFont.BOLD);
            arial14font.setColour(jxl.format.Colour.LIGHT_BLUE);
            arial14format = new WritableCellFormat(arial14font);
            arial14format.setAlignment(jxl.format.Alignment.CENTRE);
            arial14format.setBorder(jxl.format.Border.ALL, jxl.format.BorderLineStyle.THIN);
            arial14format.setBackground(jxl.format.Colour.VERY_LIGHT_YELLOW);

            arial10font = new WritableFont(WritableFont.ARIAL, 10, WritableFont.BOLD);
            arial10font.setColour(Colour.DARK_BLUE);
            arial10format = new WritableCellFormat(arial10font);
            arial10format.setAlignment(jxl.format.Alignment.CENTRE);
            arial10format.setBorder(jxl.format.Border.ALL, jxl.format.BorderLineStyle.THIN);
            arial10format.setBackground(Colour.GRAY_25);

            arial12font = new WritableFont(WritableFont.ARIAL, 10);
            //设置字体颜色

            arial12format = new WritableCellFormat(arial12font);
            //对齐格式
            arial12font.setColour(Colour.BLACK);
            arial12font.setPointSize(10);
            //设置边框
            arial12format.setBorder(Border.ALL, BorderLineStyle.THIN);
            arial12format.setAlignment(jxl.format.Alignment.CENTRE);
        } catch (WriteException e) {
            e.printStackTrace();
        }
    }

    public static WritableCellFormat getHeader() {
        WritableFont font = new WritableFont(WritableFont.TIMES, 12,
                WritableFont.BOLD);// 定义字体
        try {
            font.setColour(Colour.BLUE);// 蓝色字体
        } catch (WriteException e1) {
            e1.printStackTrace();
        }
        WritableCellFormat format