package com.gkhy.admin;

import com.alibaba.excel.EasyExcel;
import com.gkhy.assess.admin.GkhyAdminApplication;
import com.gkhy.assess.system.excel.ExpertExcelListener;
import com.gkhy.assess.system.domain.vo.SysExpertInfoExcelVO;
import lombok.extern.slf4j.Slf4j;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.context.ApplicationContext;
import org.springframework.core.io.Resource;
import org.springframework.test.context.junit4.SpringRunner;

import java.io.IOException;
import java.io.InputStream;

@RunWith(SpringRunner.class)
@SpringBootTest(classes = GkhyAdminApplication.class)
//@ActiveProfiles("dev")
@Slf4j
public class ExcelTest {
    @Autowired
    private ApplicationContext applicationContext;

    @Test
    public void testExcel() throws IOException {
        Resource resource = applicationContext.getResource("classpath:abc.xlsx");
        InputStream resourceAsStream =resource.getInputStream();
        EasyExcel.read(resourceAsStream, SysExpertInfoExcelVO.class,new ExpertExcelListener()).sheet(0).doRead();
    }
}