1.需求描述
用户要求导出的金额格式为数字,不能导出为文本
POI导出工具类
import com.platform.park.model.vo.carRecords.ExportOutOfYardVO;
import io.swagger.annotations.ApiModelProperty;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.springframework.cglib.beans.BeanMap;
import org.springframework.stereotype.Service;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.io.OutputStream;
import java.lang.reflect.Field;
import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Map;
@Service
public class ExcelExpotUtils {
public static final int SHEET_PAGE_NUM = 10000;
public void expoerDataExcel(HttpServletResponse response,String fileName, Class c, List<BeanMap> beanMapList) throws IOException, NoSuchFieldException {
XSSFWorkbook wb = new XSSFWorkbook();
// 工作表对象
XSSFSheet sheet = null;
//行对象
Row row = null;
//列对象
Cell cell = null;
List<String> titleList= new ArrayList<>();
List<String> fieldList = new ArrayList<