easyfile

<dependency>
  <groupId>com.github.springbootPlus</groupId>
  <artifactId>easyfile</artifactId>
  <version>1.0.0</version>
</dependency>

 ExcelContext context = new ExcelContext("job-config.xml");
 Map param = Collections.singletonMap("companyId", "cccccc");
 InputStream in = ResourceUtils.getResourceFromClassPath("job.xlsx").getInputStream();
 ExcelImportResult result = context.readExcel("jobCategory", in, param);
        

<?xml version="1.0" encoding="UTF-8"?>
<excels>
    <!-- excel标签参看:ExcelDefinition,Field标签参看:FieldValue -->

    <excel id="jobCategory" class="Job" titleIndex="0" uniqueFields="jobCode"
   		uniqueDesc=" 职业编码重复 " rowFilter="com.kbao.sales.jobCategory.service.JobRowFilter">
        <field name="companyId"  title="companyId" defaultValue ="${companyId}"/>
        <field name="jobTypeCode" title="职业大类代码" isNull="false"/>
        <field name="jobTypeName" title="职业大类名称"  isNull="false" />
        <field name="jobCode" title="职业编码"  isNull="false"/>
        <field name="jobName" title="职业名称"  isNull="false"/>
        <field name="jobLevel" title="职业等级"  isNull="false"/>
        <field name="createTime" title="创建时间" defaultValue ="newDate()"/>
    </excel>
</excels>

ExcelContext context = new ExcelContext("excel/order-config.xml");
List<Pojo> beanList = new ArrayList<Pojo>(); //从数据库中查询数据
File file = context.createExcelFile("insureOrder", beanList);

String dir = "sftp://root:root123456@xxxxx:22/data/";

FileSystem fileSystem = new VfsFileSystem();

InputStream in = ResourceUtils.getResourceFromClassPath("log4j2.xml").getInputStream();
fileSystem.upload(in, dir+"log4j2.xml");

InputStream in = fileSystem.download(fileUri);
System.out.println(FileUtils.copyToString(in));

 Properties properties = PropertiesUtils.load("application.properties");
 

  PropertyPlaceholderHelper helper = new PropertyPlaceholderHelper("${", "}");
  String val = helper.replacePlaceholders("${TEMP}>>>123", properties);
  System.out.println(val);
  // result :  C:\Users\WANGHUI\AppData\Local\Temp>>>123

    Set<Class> classSet =  PackageHelper.scanTypePackage("com.github.**");
    for (Class aClass : classSet) {
        System.out.println(aClass);
    }