北京seo网站设计,阿里云域名服务,深圳品牌网站设计电话,wordpress解析完403Android开发生成保存Excel文件#xff0c;首先下载两个jar包。下载地址#xff1a;Android读写Excel文件的两个jar包资源-CSDN文库 poi-3.12-android-a.jar poi-ooxml-schemas-3.12-20150511-a.jar 把jar包放在app的libs文件夹下#xff0c;引用jar我一般都在build.gradle的…Android开发生成保存Excel文件首先下载两个jar包。下载地址Android读写Excel文件的两个jar包资源-CSDN文库 poi-3.12-android-a.jar poi-ooxml-schemas-3.12-20150511-a.jar 把jar包放在app的libs文件夹下引用jar我一般都在build.gradle的dependencies中添加
implementation fileTree(dir: libs, include: [*.?ar])
把.jar和.aar都引用上。
如果项目需要混淆则加上混淆
#生成Excel
-keep class com.bea.xml.stream.** { *;}
-keep class com.wutka.dtd.** { *;}
-keep class org.** { *;}
-keep class aavax.xml.** { *;}
-keep class com.microsoft.schemas.office.x2006.** { *; }
-keep class schemaorg_apache_xmlbeans.** { *; }
-keep class schemasMicrosoftComOfficeExcel.** { *; }
-keep class schemasMicrosoftComOfficeOffice.** { *; }
-keep class schemasMicrosoftComVml.** { *; }
-keep class repackage.** { *; }
-keep class schemaorg_apache_xmlbeans.** { *; }
然后就是生成Excel文件了
/*** 创建excel分析结果文件*/private void createExcel(){new Thread(){Overridepublic void run() {try {Log.i(lllllll, createExcel );XSSFWorkbook workbook new XSSFWorkbook();XSSFSheet sheet workbook.createSheet(WorkbookUtil.createSafeSheetName(sheet));//第一行Row row0 sheet.createRow(0);String[] title new String[]{市公司, 道路名称, 路段长度米, 计算值, 起始经纬度, 结束经纬度};for (int i 0;ititle.length;i){Cell cell row0.createCell(i);cell.setCellValue(title[i]);}//添加数据for (int i 0;iexcelBeans.size();i){ExcelBean eb excelBeans.get(i);Row row sheet.createRow(i1);for (int j 0;jtitle.length;j){Cell cell row.createCell(j);if (j 0){cell.setCellValue(eb.getCity());}else if (j 1){cell.setCellValue(eb.getAddress());}else if (j 2){double distance DistanceUtil.getDistance(eb.getStartLatLng(), eb.getStopLatLng());cell.setCellValue(NumberUtils.makeNumDecimalPlaces(distance, 2));}else if (j 3){cell.setCellValue(eb.getCoverage());}else if (j 4){cell.setCellValue([eb.getStartLatLng().longitude ,eb.getStartLatLng().latitude]);}else if (j 5){cell.setCellValue([eb.getStopLatLng().longitude ,eb.getStopLatLng().latitude]);}}}String path parseFile.getAbsolutePath();SimpleDateFormat dateFormat new SimpleDateFormat(yyyyMMdd-HHmmss);String time dateFormat.format(new Date());analysisFilePath path.replace(.csv, _analysis_earfcn_time.xlsx);Log.i(lllllll, fileName analysisFilePath);FileOutputStream fos new FileOutputStream(analysisFilePath);workbook.write(fos);fos.flush();fos.close();Log.i(lllllll, 保存成功 );}catch (Exception e){e.printStackTrace();}}}.start();}
我这生成Excel之后在手机里能打开但是在电脑上只能用WPS打开用offic打开就会报错。我查了半天最终没有找到问题在哪。有可能是我电脑上的offic版本太低了不过WPS能打开已经能满足需求了。
