| | |
|---|
| | | package com.ruoyi.common.utils.poi; |
|---|
| | | |
|---|
| | | import java.io.File; |
|---|
| | | import java.io.FileOutputStream; |
|---|
| | | import java.io.IOException; |
|---|
| | | import java.io.InputStream; |
|---|
| | | import java.io.OutputStream; |
|---|
| | | import java.lang.reflect.Field; |
|---|
| | | import java.lang.reflect.Method; |
|---|
| | | import java.lang.reflect.ParameterizedType; |
|---|
| | | import java.math.BigDecimal; |
|---|
| | | import java.text.DecimalFormat; |
|---|
| | | import java.time.LocalDate; |
|---|
| | | import java.time.LocalDateTime; |
|---|
| | | import java.util.ArrayList; |
|---|
| | | import java.util.Arrays; |
|---|
| | | import java.util.Collection; |
|---|
| | | import java.util.Comparator; |
|---|
| | | import java.util.Date; |
|---|
| | | import java.util.HashMap; |
|---|
| | | import java.util.List; |
|---|
| | | import java.util.Map; |
|---|
| | | import java.util.Set; |
|---|
| | | import java.util.UUID; |
|---|
| | | import java.util.stream.Collectors; |
|---|
| | | import javax.servlet.http.HttpServletResponse; |
|---|
| | | |
|---|
| | | import com.sun.rowset.internal.Row; |
|---|
| | | import javafx.scene.control.Cell; |
|---|
| | | import org.apache.commons.io.IOUtils; |
|---|
| | | import org.apache.commons.lang3.ArrayUtils; |
|---|
| | | import org.apache.commons.lang3.RegExUtils; |
|---|
| | | import org.apache.commons.lang3.reflect.FieldUtils; |
|---|
| | | //import org.apache.poi.hssf.usermodel.HSSFClientAnchor; |
|---|
| | | //import org.apache.poi.hssf.usermodel.HSSFPicture; |
|---|
| | | //import org.apache.poi.hssf.usermodel.HSSFPictureData; |
|---|
| | | //import org.apache.poi.hssf.usermodel.HSSFShape; |
|---|
| | | //import org.apache.poi.hssf.usermodel.HSSFSheet; |
|---|
| | | //import org.apache.poi.hssf.usermodel.HSSFWorkbook; |
|---|
| | | //import org.apache.poi.ooxml.POIXMLDocumentPart; |
|---|
| | | //import org.apache.poi.ss.usermodel.BorderStyle; |
|---|
| | | //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.ClientAnchor; |
|---|
| | | //import org.apache.poi.ss.usermodel.DataValidation; |
|---|
| | | //import org.apache.poi.ss.usermodel.DataValidationConstraint; |
|---|
| | | //import org.apache.poi.ss.usermodel.DataValidationHelper; |
|---|
| | | //import org.apache.poi.ss.usermodel.DateUtil; |
|---|
| | | //import org.apache.poi.ss.usermodel.Drawing; |
|---|
| | | //import org.apache.poi.ss.usermodel.FillPatternType; |
|---|
| | | //import org.apache.poi.ss.usermodel.Font; |
|---|
| | | //import org.apache.poi.ss.usermodel.HorizontalAlignment; |
|---|
| | | //import org.apache.poi.ss.usermodel.IndexedColors; |
|---|
| | | //import org.apache.poi.ss.usermodel.Name; |
|---|
| | | //import org.apache.poi.ss.usermodel.PictureData; |
|---|
| | | //import org.apache.poi.ss.usermodel.Row; |
|---|
| | | //import org.apache.poi.ss.usermodel.Sheet; |
|---|
| | | //import org.apache.poi.ss.usermodel.VerticalAlignment; |
|---|
| | | //import org.apache.poi.ss.usermodel.Workbook; |
|---|
| | | //import org.apache.poi.ss.usermodel.WorkbookFactory; |
|---|
| | | //import org.apache.poi.ss.util.CellRangeAddress; |
|---|
| | | //import org.apache.poi.ss.util.CellRangeAddressList; |
|---|
| | | //import org.apache.poi.util.IOUtils; |
|---|
| | | //import org.apache.poi.xssf.streaming.SXSSFWorkbook; |
|---|
| | | //import org.apache.poi.xssf.usermodel.XSSFClientAnchor; |
|---|
| | | //import org.apache.poi.xssf.usermodel.XSSFDataValidation; |
|---|
| | | //import org.apache.poi.xssf.usermodel.XSSFDrawing; |
|---|
| | | //import org.apache.poi.xssf.usermodel.XSSFPicture; |
|---|
| | | //import org.apache.poi.xssf.usermodel.XSSFShape; |
|---|
| | | //import org.apache.poi.xssf.usermodel.XSSFSheet; |
|---|
| | | //import org.apache.poi.xssf.usermodel.XSSFWorkbook; |
|---|
| | | //import org.openxmlformats.schemas.drawingml.x2006.spreadsheetDrawing.CTMarker; |
|---|
| | | import org.slf4j.Logger; |
|---|
| | | import org.slf4j.LoggerFactory; |
|---|
| | | //import com.ruoyi.common.annotation.Excel; |
|---|
| | | //import com.ruoyi.common.annotation.Excel.ColumnType; |
|---|
| | | //import com.ruoyi.common.annotation.Excel.Type; |
|---|
| | | import com.ruoyi.common.annotation.Excels; |
|---|
| | | import com.ruoyi.common.config.RuoYiConfig; |
|---|
| | | import com.ruoyi.common.core.domain.AjaxResult; |
|---|
| | | import com.ruoyi.common.core.text.Convert; |
|---|
| | | import com.ruoyi.common.exception.UtilException; |
|---|
| | | import com.ruoyi.common.utils.DateUtils; |
|---|
| | | import com.ruoyi.common.utils.DictUtils; |
|---|
| | | import com.ruoyi.common.utils.StringUtils; |
|---|
| | | import com.ruoyi.common.utils.file.FileTypeUtils; |
|---|
| | | import com.ruoyi.common.utils.file.FileUtils; |
|---|
| | | import com.ruoyi.common.utils.file.ImageUtils; |
|---|
| | | import com.ruoyi.common.utils.reflect.ReflectUtils; |
|---|
| | | |
|---|
| | | import java.util.HashMap; |
|---|
| | | import java.util.Map; |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * Excel相关处理 |
|---|
