提示:文章写完后,目录可以自动生成,如何生成可参考右边的帮助文档
前言
本文主要是针对列表数据导出excel模板代码
提示:以下是本篇文章正文内容,下面案例可供参考
一、android导出Excel使用什么库
implementation 'net.sourceforge.jexcelapi:jxl:2.6.12'
二、使用步骤
1.封装一个Utils
代码如下(示例):
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(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(Colour.VERY_LIGHT_YELLOW); arial10font = new WritableFont(WritableFont.ARIAL, 10, WritableFont.BOLD); 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); //对齐格式 arial10format.setAlignment(jxl.format.Alignment.CENTRE); //设置边框 arial12format.setBorder(jxl.format.Border.ALL, jxl.format.BorderLineStyle.THIN); } catch (WriteException e) { e.printStackTrace(); } } /** * 初始化Excel表格 * * @param filePath 存放excel文件的路径(path/demo.xls) * @param sheetName Excel表格的表名 * @param colName excel中包含的列名(可以有多个) */ public static void initExcel(String filePath, String sheetName, String[] colName) { format(); WritableWorkbook workbook = null; try { File file = new File(filePath); if (!file.exists()) { file.createNewFile(); } else { return; } workbook = Workbook.createWorkbook(file); //设置表格的名字 WritableSheet sheet = workbook.createSheet(sheetName, 0); //创建标题栏 sheet.addCell((WritableCell) new Label(0, 0, filePath, arial14format)); for (int col = 0; col < colName.length; col++) { sheet.addCell(new Label(col, 0, colName[col], arial10format)); } //设置行高 sheet.setRowView(0, 340); workbook.write(); } catch (Exception e) { e.printStackTrace(); } finally { if (workbook != null) { try { workbook.close(); } catch (Exception e) { e.printStackTrace(); } } } } /** * 将制定类型的List写入Excel中 * * @param objList 待写入的list * @param fileName * @param mContext * @param <T> */ @SuppressWarnings("unchecked") public static <T> void writeObjListToExcel(List<T> objList, String fileName, Context mContext) { if (objList != null && objList.size() > 0) { WritableWorkbook writebook = null; InputStream in = null; try { WorkbookSettings setEncode = new WorkbookSettings(); setEncode.setEncoding(UTF8_ENCODING); in = new FileInputStream(new File(fileName)); Workbook workbook = Workbook.getWorkbook(in); writebook = Workbook.createWorkbook(new File(fileName), workbook); WritableSheet sheet = writebook.getSheet(0); for (int j = 0; j < objList.size(); j++) { StandingBookTable demoBean = (StandingBookTable) objList.get(j); List<String> list = new ArrayList<>(); list.add(demoBean.cabinetChildNum + "号柜"); list.add(demoBean.userName); if (demoBean.returnBorrow == 1) { list.add("归还"); } else { list.add("借出"); } list.add(demoBean.articleTypeName); list.add(demoBean.operateTime); list.add(demoBean.articleEpcNum); for (int i = 0; i < list.size(); i++) { sheet.addCell(new Label(i, j + 1, list.get(i), arial12format)); if (list.get(i).length() <= 4) { //设置列宽 sheet.setColumnView(i, list.get(i).length() + 8); } else { //设置列宽 sheet.setColumnView(i, list.get(i).length() + 5); } } //设置行高 sheet.setRowView(j + 1, 350); } writebook.write(); workbook.close(); LogUtil.e("导出Excel成功"); } catch (Exception e) { e.printStackTrace(); } finally { if (writebook != null) { try { writebook.close(); } catch (Exception e) { e.printStackTrace(); } } if (in != null) { try { in.close(); } catch (IOException e) { e.printStackTrace(); } } } } } }
2.使用方法
代码如下(示例):
private String filePath = "/sdcard/AndroidExcel"; public void OninitExcel(View view) { EsCabinApp.threadPool.submit(new Runnable() { @Override public void run() { File file = new File(filePath); if (!file.exists()) { file.mkdirs(); } String excelFileName = "/台账信息.xls"; String[] title = {"柜子号", "操作人姓名", "使用状态", "物品类型", "操作时间", "射频标签"}; String sheetName = "demoSheetName"; standingBookTables = new ArrayList<>(); standingBookTables = EsCabinApp.standingBookDao.queryBookAll(); String filePaths = filePath + excelFileName; ExcelUtil.initExcel(filePaths, sheetName, title); ExcelUtil.writeObjListToExcel(standingBookTables, filePaths, mActivity); EsCabinApp.debugShowToast("导出Excel成功"); } }); }
该处使用的url网络请求的数据。
总结
本文仅仅简单介绍了android导出Excel的代码使用,而导出Excel里面包含了很多读写操作有兴趣可以更深入了解一下。