/// <summary>

/// 修复日期转换后存在中文的问题

/// 原因分析：Excel列的类型是DateTime，在不同的系统环境下，经过Mapper的转换，会生成区域性特定格式的字符串

/// 解决方案是对格式为DateTime的列指定自定义的转换规则

/// </summary>

/// <typeparam name="T">Excel文档映射的实体</typeparam>

/// <param name="fileStream">Excel文档的流</param>

/// <param name="dateCols">数据为日期的列名</param>

/// <returns></returns>

public List<T> analysisExcelWithDateCols<T>(Stream fileStream, string[] dateCols) where T : class

{

    List<T> ModelList = new List<T>();

    var mapper = new Mapper(fileStream);

    List<RowInfo<T>> DataList = new List<RowInfo<T>>();

    foreach (string dateCol in dateCols)

    {

        PropertyInfo propertyInfo = typeof(T).GetProperty(dateCol);

        mapper.Map<T>(dateCol, dateCol, (excelCol, entity) =>

        {

            if (excelCol.CurrentValue != null)

            {

                T obj = entity as T;

                if (obj != null)

                {

                    DateTime date;

                    if (excelCol.CurrentValue is string)

                    {

                        date = Convert.ToDateTime(excelCol.CurrentValue);

                    }

                    else

                    {

                        date = (DateTime)excelCol.CurrentValue;

                    }

                    propertyInfo?.SetValue(obj, date.ToString("MM/dd/yyyy"));

                }

            }

            return true;

        }, null);

    }

    DataList = mapper.Take<T>().ToList();

    if (DataList != null && DataList.Count > 0)

    {

        foreach (var item in DataList)

        {

            ModelList.Add(item.Value);

        }

    }

    return ModelList;

}