导出Excel准备工作: ①项目右键,点击Open Module Settings,进入Project Structure, 在Modules下的app状态下,右侧选中Depenencies, 点击下方的 + 号,选择Library dependency, 出现搜索框,输入jxl, 我选择的是com.hynnet:jxl:2.6.12.1,点击确定, 会发现在app下的build.gradle中添加了 compile 'com.hynnet:jxl:2.6.12.1' 接下来Sync Now,jxl的库就算导入好了 ②在AndroidManifest.xml文件中加入读写存储权限 <uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE" /> <uses-permission android:name="android.permission.READ_EXTERNAL_STORAGE" /> ③添加类ExcelUtils ④在MainActivity中实现导出操作,具体代码见MainActivity.java 注意:代码中用到 新的运行时权限,需要用到android.support.v4包
package com.katherine.du.exportexceldemo.tools; import android.content.Context; import android.widget.Toast; import java.io.File; import java.io.FileInputStream; import java.io.IOException; import java.io.InputStream; import java.util.ArrayList; import java.util.List; import jxl.Workbook; import jxl.WorkbookSettings; import jxl.write.Label; import jxl.write.WritableCell; import jxl.write.WritableCellFormat; import jxl.write.WritableFont; import jxl.write.WritableSheet; import jxl.write.WritableWorkbook; import jxl.write.WriteException; /** * Excel导出工具 */ public class ExcelUtils { public static WritableFont arial12font = null; public static WritableCellFormat arial12format = null; public final static String UTF8_ENCODING = "UTF-8"; public final static String GBK_ENCODING = "GBK"; public static void format() { try { arial12font = new WritableFont(WritableFont.ARIAL, 12); arial12format = new WritableCellFormat(arial12font); arial12format.setBorder(jxl.format.Border.ALL, jxl.format.BorderLineStyle.THIN); } catch (WriteException e) { e.printStackTrace(); } } /** * 初始化表格,包括文件名、sheet名、各列的名字 * * @param filePath 文件路径 * @param sheetName sheet名 * @param colName 各列的名字 */ public static void initExcel(String filePath, String sheetName, String[] colName) { format(); WritableWorkbook workbook = null; try { File file = new File(filePath); if (