Bool值的字段默认是否，如何自定义？比如yes no

[wulienen]

[ImporterHeader(Name = "是否住校"]
public bool? IsBoarding { get; set; }

bool我想用英文yes no，因为面向国际的，怎么更改？

[xin-lai]

通过值映射特性。
比如：
[ValueMapping(text: "yes", true)]
[ValueMapping(text: "no", false)]
你可以试试。bool类型这块没写单元测试，有问题再找我。我有空了会试试。

[wulienen]

可行！

[DUWENINK]

我建议重开此issue

一点也不可行

[xin-lai]

@DUWENINK 麻烦提供下Demo，最好以单元测试的形势

[DUWENINK]

运行环境:netcore 3.1+docker(ununtu 21)
实体类

[ExcelImporter(IsLabelingError = true)]
   [ExcelExporter(Name = "PFEP", TableStyle = "Light10", AutoFitAllColumn = true)]
   public class PFEPExcelDto
   {
       /// <summary>
       /// 工装代码
       /// </summary>
       [ImporterHeader(Name = "供应商代码", IsAllowRepeat = false)]
       [Required(ErrorMessage = "供应商代码")]
       //[MaxLength(30, ErrorMessage = "供应商代码超过30字符限制请修改")]
       [ExporterHeader(DisplayName = "供应商代码")]
       public string OrganizationCode { get; set; }

       /// <summary>
       /// 
       /// </summary>
       [IEIgnore(IsExportIgnore = false, IsImportIgnore = true)]
       [ExporterHeader(DisplayName = "供应商名称")]
      //[ImporterHeader(Name = "供应商名称", IsAllowRepeat = false)]
       public string OrganizationName { get; set; }


       /// <summary>
       /// 物料代码
       /// </summary>
       [ImporterHeader(Name = "物料代码", IsAllowRepeat = true)]
       [Required(ErrorMessage = "物料代码不能为空")]
       [MaxLength(50, ErrorMessage = "物料代码超过50字符限制请修改")]
       [ExporterHeader(DisplayName = "物料代码")]
       public string ProductCode { get; set; }



       /// <summary>
       /// 物料名称
       /// </summary>
       //[ImporterHeader(Name = "物料名称", IsAllowRepeat = true)]
       //[Required(ErrorMessage = "物料名称不能为空")]
       //[MaxLength(50, ErrorMessage = "物料名称超过50字符限制请修改")]
       [ExporterHeader(DisplayName = "物料名称")]
       [IEIgnore(IsExportIgnore = false, IsImportIgnore = true)]
       public string ProductName { get; set; }


       /// <summary>
       /// 标准运输包装量
       /// </summary>
       [Required(ErrorMessage = "标准运输包装量")]
       [ImporterHeader(Name = "标准运输包装量", IsAllowRepeat = true)]
       [ExporterHeader(DisplayName = "标准运输包装量")]
       public int Count { get; set; }


       /// <summary>
       /// 单托箱数量
       /// </summary>
       [Required(ErrorMessage = "单托箱数量")]
       [ImporterHeader(Name = "单托箱数量", IsAllowRepeat = true)]
       [ExporterHeader(DisplayName = "单托箱数量")]
       public int PeerPalletBoxCount { get; set; }


       /// <summary>
       /// 
       /// </summary>
       [Required(ErrorMessage = "时间窗口组代码")]
       [ImporterHeader(Name = "时间窗口组代码", IsAllowRepeat = true)]
       [ExporterHeader(DisplayName = "时间窗口组代码")]
       public string TimeWindowCode { get; set; }

       /// <summary>
       /// 
       /// </summary>
       [IEIgnore(IsExportIgnore = false, IsImportIgnore = true)]
       [ExporterHeader(DisplayName = "时间窗口组名称")]
       public string TimeWindowName { get; set; }
       ///// <summary>
       ///// 
       ///// </summary>
       //[ExporterHeader(DisplayName = "时间窗口")]
       //[IEIgnore(IsExportIgnore = false, IsImportIgnore = true)]
       //public string TimeWindowDetailText =>$"{TimeUtil.GetTimeFormat(TimeWindowDetail.StartHour, TimeWindowDetail.StartMinutes, TimeWindowDetail.StartSeconds)}-{TimeUtil.GetTimeFormat(TimeWindowDetail.EndHour, TimeWindowDetail.EndMinutes, TimeWindowDetail.EndSeconds)}" ;

       
       /// <summary>
       /// 
       /// </summary>
       [Required(ErrorMessage = "运输方案代码")]
       [ImporterHeader(Name = "运输方案代码", IsAllowRepeat = true)]
       [ExporterHeader(DisplayName = "运输方案代码")]
       public string TrafficPlanCode { get; set; }


       /// <summary>
       /// 发运提前时间
       /// </summary>
       [ImporterHeader(Name = "发运提前时间(小时)", IsAllowRepeat = true)]
       [ExporterHeader(DisplayName = "发运提前时间(小时)")]
       public double? AheadTime { get; set; }

       /// <summary>
       /// 
       /// </summary>
       [ExporterHeader(DisplayName = "运输方案名称")]
       [IEIgnore(IsExportIgnore = false, IsImportIgnore = true)]
       public string TrafficPlanName { get; set; }


       /// <summary>
       /// 
       /// </summary>
       [ImporterHeader(Name = "箱代码", IsAllowRepeat = true)]
       [ExporterHeader(DisplayName = "箱代码")]
       public string BoxCode { get; set; }

       /// <summary>
       /// 
       /// </summary>
       [ExporterHeader(DisplayName = "箱名称")]
       [IEIgnore(IsExportIgnore = false, IsImportIgnore = true)]
       public string BoxName { get; set; }

       /// <summary>
       /// 
       /// </summary>
       [ImporterHeader(Name = "托代码", IsAllowRepeat = true)]
       [ExporterHeader(DisplayName = "托代码")]
       public string PalletCode { get; set; }

       /// <summary>
       /// 
       /// </summary>
       [ExporterHeader(DisplayName = "托名称")]
       [IEIgnore(IsExportIgnore = false, IsImportIgnore = true)]
       public string PalletName { get; set; }


       /// <summary>
       /// 
       /// </summary>
       [ImporterHeader(Name = "箱重(kg)", IsAllowRepeat = true)]
       [ExporterHeader(DisplayName = "箱重(kg)")]
       public double? Weight { get; set; }


       /// <summary>
       /// 
       /// </summary>
       [ImporterHeader(Name = "备注", IsAllowRepeat = true)]
       [ExporterHeader(DisplayName = "备注")]
       public string ReMark { get; set; }

       /// <summary>
       /// 
       /// </summary>
       [ImporterHeader(Name = "是否免检", IsAllowRepeat = true)]
       [ExporterHeader(DisplayName = "是否免检")]
       [ValueMapping(text: "是", true)]
       [ValueMapping(text: "否", false)]
       public bool NeedInspection { get; set; }
       //---------------------------------------------------
       /// <summary>
       /// 箱信息
       /// </summary>
       [IEIgnore(IsExportIgnore = true,IsImportIgnore =true)]
       public virtual MdmContainerDto Box { get; set; }

       /// <summary>
       /// 拖信息
       /// </summary>
       [IEIgnore(IsExportIgnore = true, IsImportIgnore = true)]
       public virtual MdmContainerDto Pallet { get; set; }

       /// <summary>
       /// 
       /// </summary>
       [IEIgnore(IsExportIgnore = true, IsImportIgnore = true)]
       public virtual MdmTimewindowDto TimeWindow { get; set; }
       /// <summary>
       /// 
       /// </summary>
       [IEIgnore(IsExportIgnore = true, IsImportIgnore = true)]
       public virtual MdmTrafficplanDto TrafficPlan { get; set; }

   }

导出接口

        /// <summary>
        /// 导出数据
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpPost]
        [AllowAnonymous]
        public async Task<FileStreamResult> PFEPExcelExport([FromBody] MdmPFEPFilter input)
        {
            var exp = input.ToExpression();
            var data = await _PFEPService.FindAllAsync(exp);
            var list = _mapper.Map<List<PFEPExcelDto>>(data);
            return await _excelService.Export("PFEP导出", list);
        }

[xin-lai]

@DUWENINK 抱歉，是我们文档强调的还不够。值映射目前仅支持导入，也就是导出是不支持的，建议你自行转换，比如通过Select方法处理。
暂不支持的主要原因是，从性能上考虑，需要等我们基于EPPlus的源码重写底层。底层重写工作因精力的问题，暂未开始。

[hueifeng]

该问题已在2.4 beta1中解决，欢迎大家后续使用2.4版本通过如下代码实现需求：

[ValueMapping(text: "yes", true)]
[ValueMapping(text: "no", false)]