既有适合小白学习的零基础资料,也有适合3年以上经验的小伙伴深入学习提升的进阶课程,涵盖了95%以上大数据知识点,真正体系化!
由于文件比较多,这里只是将部分目录截图出来,全套包含大厂面经、学习笔记、源码讲义、实战项目、大纲路线、讲解视频,并且后续会持续更新
<commons.compress.version>1.18</commons.compress.version>
<poi.version>4.0.1</poi.version>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
${ poi.version }
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
${ poi.version }
org.apache.commons
commons-compress
${commons.compress.version}
工具类
import dbox.tbox.lang.DateUtils;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.CellType;
import org.apache.poi.ss.usermodel.HorizontalAlignment;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.WorkbookFactory;
import org.apache.poi.xssf.streaming.SXSSFSheet;
import org.apache.poi.xssf.streaming.SXSSFWorkbook;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.lang.reflect.Field;
import java.lang.reflect.Modifier;
import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Map;
import java.util.stream.Stream;
/**
-
@Author ping
-
@Date 2023/12/4 17:04
-
excel工具类 用于service服务的导出,不使用export模式
*/
public class ExcelUtil {
// 读取 Excel 文件并将其映射为具体的 Java 对象
public static List readExcel(String filePath, Class clazz) throws Exception {
List objects = new ArrayList<>();
try (FileInputStream fis &#