package com.ruoyi;
|
|
import com.ruoyi.common.utils.poi.ExcelUtil;
|
import com.ruoyi.domain.ZfProperty;
|
import org.junit.jupiter.api.Test;
|
import org.springframework.boot.test.context.SpringBootTest;
|
|
import java.io.File;
|
import java.io.FileInputStream;
|
import java.io.InputStream;
|
import java.util.List;
|
|
/**
|
* @Version 1.0
|
* @Author Jin_quan Ou
|
* @Date 2023-03-22 12:48
|
*/
|
@SpringBootTest
|
public class ExcelTest {
|
|
@Test
|
public void testExcelImport() throws Exception {
|
InputStream is = new FileInputStream(new File("D:\\test.xlsx"));
|
ExcelUtil<ZfProperty> util = new ExcelUtil<ZfProperty>(ZfProperty.class);
|
List<ZfProperty> userList = util.importExcel(is);
|
}
|
}
|
