介绍：本功能用于根据excel模板 来解析excel数据 避免繁琐的编码
将获取数据的规则、对应关系 可视化

gitee 体验包下载
https://gitee.com/chenanqi6/nsn_excel_Quick_start/tree/master/v1.0

gitee 源码下载
https://gitee.com/chenanqi6/nsn_excel

使用教程

1.下载上面的体验包 将jar包 和 ExcelTest.java导入项目
2.将ExcelTest.java 中的文件地址 改成你本地地址
3.执行

调用案例

1.数据

image.png

2.根据数据编写模板

image.png

3.程序调用

  1.     public static void main(String[] args)  {
  2.         //这个是数据地址
  3.         String fileExcel = "C:\\Users\\caq\\Desktop\\TestExcel\\模板\\data.xlsx";
  4.         //这个是模板地址
  5.         String modelExcel = "C:\\Users\\caq\\Desktop\\TestExcel\\模板\\model.xlsx";
  6.         //创建模板的Excel解析类
  7.         ModelExcelRead excelModelRead = new ModelExcelReadAdpter();
  8.         Map<String, Object> map = excelModelRead.modelParseData(modelExcel, fileExcel);
  9.         //查看数据是否正常
  10.         System.out.println(map);
  11.     }

4.出参JSON 结果

  1. {
  2.     "task": [
  3.         {
  4.             "sysName": "挖矿", 
  5.             "taskName": "显卡购买", 
  6.             "time": "2020-01-01 00:00:00", 
  7.             "psnNum": "2", 
  8.             "remark": "需要足够的资金"
  9.         }, 
  10.         {
  11.             "sysName": "财务系统", 
  12.             "taskName": "资金回笼", 
  13.             "time": "2021-01-01 13:40:00", 
  14.             "psnNum": "2", 
  15.             "remark": "融资"
  16.         }
  17.     ], 
  18.     "section": [
  19.         {
  20.             "psnName": "法外狂徒", 
  21.             "section": "市外部", 
  22.             "phoneNumber": "12345678910", 
  23.             "outFlag": "否"
  24.         }, 
  25.         {
  26.             "psnName": "周淑怡", 
  27.             "section": "怡定药在一起", 
  28.             "phoneNumber": "12345678911", 
  29.             "outFlag": "否"
  30.         }, 
  31.         {
  32.             "psnName": "药水哥", 
  33.             "section": "怡定药在一起", 
  34.             "phoneNumber": "12345678912", 
  35.             "outFlag": "否"
  36.         }, 
  37.         {
  38.             "psnName": "药水哥", 
  39.             "section": "怡定药在一起", 
  40.             "phoneNumber": "12345678912", 
  41.             "outFlag": "否"
  42.         }
  43.     ], 
  44.     "base": {
  45.         "endDate": "2021-07-09", 
  46.         "startDate": "2020-01-02", 
  47.         "name": "nsn"
  48.     }
  49. }