Android导出Excel的各种方法

poi

poi官网

    implementation 'org.apache.poi:poi:5.2.3'
    implementation 'org.apache.poi:poi-ooxml:5.2.3'
  • org.apache.poi:poi-ooxml:4.x:
    • 不支持Android使用, 不支持原因:Android底层库不支持xml所需的bean类,使用即报错
    • only supported starting with Android O (–min-api 26)
  • org.apache.poi:poi-ooxml:5.2.0:
    • 支持Android使用.xls前缀,但不支持.xlsx
    • only supported starting with Android O (–min-api 26)
  • poi-3.12-android-a:
    • 专门开放给android使用的依赖库,支持.xls, .xlsx;apche专门针对android不支持库开放的依赖,这个是当前使用最正确的第三方依赖包
    • poi-3.12-android-a.jar
    • poi-ooxml-schemas-3.12-20150511-a.jar

EasyExcel

implementation 'com.github.liaohuqiu.android:EasyExcel:1.1.16'

说明:底层用的还是poi,poi存在的问题,它也有。

JExcelApi

implementation ‘net.sourceforge.jexcelapi:jxl:2.6.12

注:v2.6.12 是 2009年更新的。

下载地址:https://sourceforge.net/projects/jexcelapi/files/jexcelapi/
参考示例:https://blog.youkuaiyun.com/fromVillageCoolBoy/article/details/139748259

nachos

implementation "com.hootsuite.android:nachos:1.1.1"
android 使用poi读取高版本excel, 解决以下这两个错误 java.lang.NoClassDefFoundError: Failed resolution of: Ljavax/xml/stream/XMLEventFactory; at org.apache.poi.openxml4j.opc.internal.marshallers.PackagePropertiesMarshaller.(PackagePropertiesMarshaller.java:41) at org.apache.poi.openxml4j.opc.OPCPackage.init(OPCPackage.java:161) at org.apache.poi.openxml4j.opc.OPCPackage.(OPCPackage.java:141) at org.apache.poi.openxml4j.opc.ZipPackage.(ZipPackage.java:97) at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:324) at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:184) at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:149) javax.xml.stream.FactoryConfigurationError: Provider com.sun.xml.internal.stream.events.XMLEventFactoryImpl not found at javax.xml.stream.FactoryFinder.newInstance(Unknown Source) at javax.xml.stream.FactoryFinder.newInstance(Unknown Source) at javax.xml.stream.FactoryFinder.find(Unknown Source) at javax.xml.stream.FactoryFinder.find(Unknown Source) at javax.xml.stream.XMLEventFactory.newInstance(Unknown Source) at org.apache.poi.openxml4j.opc.internal.marshallers.PackagePropertiesMarshaller.(PackagePropertiesMarshaller.java:41) at org.apache.poi.openxml4j.opc.OPCPackage.init(OPCPackage.java:161) at org.apache.poi.openxml4j.opc.OPCPackage.(OPCPackage.java:141) at org.apache.poi.openxml4j.opc.ZipPackage.(ZipPackage.java:97) at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:324) at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:184) at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:149)
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值