导出excel此单元格中的数字为文本格式,或者其前面有撇号

package com.esse.projects.ct.until; import com.alibaba.excel.converters.Converter; import com.alibaba.excel.enums.CellDataTypeEnum; import com.alibaba.excel.metadata.CellData; import com.alibaba.excel.metadata.GlobalConfiguration; import com.alibaba.excel.metadata.property.ExcelContentProperty; import com.esse.common.core.util.StringUtils; import java.math.BigDecimal; /** * @description:自定义转换器 * @author: yuhx * @date: 2023/3/30 9:08 */ public class CustomConvert implements Converter<String> { /** * 支持的Java类型 * * @return */ @Override public Class supportJavaTypeKey() { return String.class; } /** * 支持的excel类型 * * @return */ @Override public CellDataTypeEnum supportExcelTypeKey() { return CellDataTypeEnum.STRING; } /** * 转换Java支持的类型 * * @param cellData * @param excelContentProperty * @param globalConfiguration * @return * @throws Exception */ @Override public String convertToJavaData(CellData cellData, ExcelContentProperty excelContentProperty, GlobalConfiguration globalConfiguration) throws Exception { return cellData.getStringValue(); } /** * 转换为Excel支持的类型 * * @param s * @param excelContentProperty * @param globalConfiguration * @return * @throws Exception */ @Override public CellData convertToExcelData(String s, ExcelContentProperty excelContentProperty, GlobalConfiguration globalConfiguration) throws Exception { if (isBigDecimal(s)) { BigDecimal bigDecimal = new BigDecimal(s); return new CellData(bigDecimal); } else { return new CellData(s); } } public static boolean isBigDecimal(String str) { if (str == null || str.trim().length() == 0) { return false; } char[] chars = str.toCharArray(); int sz = chars.length; int i = (chars[0] == '-') ? 1 : 0; if (i == sz) return false; //除了负号，第一位不能为'小数点' if (chars[i] == '.') return false; boolean radixPoint = false; for (; i < sz; i++) { if (chars[i] == '.') { if (radixPoint) return false; radixPoint = true; } else if (!(chars[i] >= '0' && chars[i] <= '9')) { return false; } } return true; } }