Excel数据操作

13693261870

2022-11-15 cc01f01a9ff12f4167d7d5d40bc3cff2ffb366c6

 src/main/java/com/lf/server/config/InitConfig.java

@@ -1,15 +1,16 @@
package com.lf.server.config;

import com.alibaba.fastjson.JSON;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
import com.baomidou.mybatisplus.core.metadata.OrderItem;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.lf.server.controller.other.FloatServerController;
import com.lf.server.entity.all.MenusAuthEntity;
import com.lf.server.entity.all.PermsAuthEntity;
import com.lf.server.entity.all.ResAuthEntity;
import com.lf.server.entity.bd.DlgAgnpEntity;
import com.lf.server.entity.show.ReqParamFloatServer;
import com.lf.server.entity.bs.Gxcg;
import com.lf.server.entity.bs.Zxcg;
import com.lf.server.helper.*;
import com.lf.server.mapper.bd.DlgAgnpMapper;
import com.lf.server.service.all.BaseQueryService;
@@ -73,12 +74,13 @@
            //testAes();
            //testPerms();
            //testBlacklist();
            //FloatServerController.test();
            //testReadExcel();

            //boolean f1 = ZipHelper.unzip("D:\\LF\\data\\resources.zip", "D:\\LF\\data\\unzip");
            //boolean f2 = ZipHelper.zip("D:\\LF\\data\\res.zip", "D:\\LF\\data\\unzip\\resources");
            //boolean f3 = Zip4jHelper.zip("D:\\LF\\data\\zip\\resources.zip", "D:\\LF\\data\\zip\\resources", "12345");
            //boolean f4 = Zip4jHelper.unzip("D:\\LF\\data\\zip\\resources.zip", "D:\\LF\\data\\zip\\res", "12345");
            //testFloatServer();

            // 初始化
            GdalHelper.init();
@@ -186,19 +188,11 @@
        List<String> list5 = blacklistService.selectIpList(1);
    }

    private void testFloatServer() {
        try {
            ReqParamFloatServer reqParam = new ReqParamFloatServer("192.168.20.106", "12316");
            String json = JSON.toJSONString(reqParam);
    private void testReadExcel() {
        List<Zxcg> listZxcg = ExcelHelper.readExcel(Zxcg.class, "D:\\LF\\data\\xls\\测绘\\1-项目成果-西三中\\1-1中线成果表\\海原县中线成果表.xlsx");
        int r1 = listZxcg.size();

            LicHelper helper = new LicHelper();
            helper.d("&kdaow$IEW.##%5-");
            helper.c("*y91z72a;pclfleoqc20161v$DSP&%3+");

            String str = helper.a(json);
            System.out.println("ReqParamFloatServer: " + str);
        } catch (Exception ex) {
            //
        }
        List<Gxcg> listGxcg = ExcelHelper.readExcel(Gxcg.class, "D:\\LF\\data\\xls\\测绘\\2-地下管线探测成果\\2-2 管线成果表.xlsx");
        int r2 = listGxcg.size();
    }
}