[AttributeUsage(AttributeTargets.Property, AllowMultiple = false, Inherited = true)]

    public class PropertyDescriptionAttribute : Attribute

    {

        private bool _allownullorempty = true;

        public PropertyDescriptionAttribute() { }

        /// <summary>

        /// 是否允许为null或空值

        /// </summary>

        public bool AllowNullOrEmpty

        {

            get

            {

                return this._allownullorempty;

            }

            set

            {

                this._allownullorempty = value;

            }

        }

    }

public class UploadUserModel

    {

        [PropertyDescription(AllowNullOrEmpty = false)]

        public string Name { get; set; }

        [PropertyDescription(AllowNullOrEmpty = false)]

        public string Phone { get; set; }

    }

/// <summary>

/// PROPERTY_NAME数组:值与excel列一一对应

/// </summary>

private readonly string[] PROPERTY_NAME = { "Name", "Phone" };

private List<UploadUserModel> ExcelToList(HttpPostedFile excelFile)

        {

            IWorkbook workbook = null;

            ISheet sheet = null;

            int colCount = ;

            List<UploadUserModel> users = new List<UploadUserModel>();

            if (excelFile.FileName.IndexOf(".xlsx") > )

            {

                workbook = new XSSFWorkbook(excelFile.InputStream);

            }

            else if (excelFile.FileName.IndexOf(".xls") > )

            {

                workbook = new HSSFWorkbook(excelFile.InputStream);

            }

            if (workbook != null)

            {

                sheet = workbook.GetSheetAt();

                if (sheet != null && sheet.LastRowNum > )

                {

                    colCount = sheet.GetRow().LastCellNum;//获取列数

                    //从第二行开始解析

                    for (int rowIndex = ; rowIndex <= sheet.LastRowNum; rowIndex++)

                    {

                        var curRow = sheet.GetRow(rowIndex);//获取当前行

                        UploadUserModel user = new UploadUserModel();

                        Type cType = user.GetType();

                        //解析列

                        for (int colIndex = ; colIndex < colCount; colIndex++)

                        {

                            var curCell = curRow.GetCell(colIndex);

                            if (curCell != null)

                            {

                                curCell.SetCellType(CellType.String);//把单元格设置成String类型,统一取值方式

                            }

                            //定义PROPERTY_NAME避免if判断

                            PropertyInfo propertyInfo = cType.GetProperty(PROPERTY_NAME[colIndex]);

                            //获取自定义特性

                            object[] customAttrs = propertyInfo.GetCustomAttributes(typeof(PropertyDescriptionAttribute), true);

                            if (customAttrs.Length > )

                            {

                                PropertyDescriptionAttribute attr = customAttrs[] as PropertyDescriptionAttribute;

                                if (!attr.AllowNullOrEmpty)//属性值不能为空

                                {

                                    if (curCell == null)

                                    {

                                        throw new Exception("第" + (rowIndex + ).ToString() + "行有未填项，请填写后重新上传。");

                                    }

                                    else if (string.IsNullOrEmpty(curCell.StringCellValue))

                                    {

                                        throw new Exception("第" + (rowIndex + ).ToString() + "行有未填项，请填写后重新上传。");

                                    }

                                }

                                object cellValue = null;

                                if (curCell == null)

                                {

                                    cellValue = "";

                                }

                                else

                                {

                                    cellValue = curCell.StringCellValue;

                                }

                                if (!propertyInfo.PropertyType.IsGenericType)

                                {

                                    //非泛型

                                    propertyInfo.SetValue(user, curCell == null ? null : Convert.ChangeType(cellValue, propertyInfo.PropertyType), null);

                                }

                                else

                                {

                                    //泛型Nullable<>

                                    Type genericTypeDefinition = propertyInfo.PropertyType.GetGenericTypeDefinition();

                                    if (genericTypeDefinition == typeof(Nullable<>))

                                    {

                                        propertyInfo.SetValue(user, curCell == null ? null : Convert.ChangeType(cellValue, Nullable.GetUnderlyingType(propertyInfo.PropertyType)), null);

                                    }

                                }

                            }

                        }

                        users.Add(user);

                    }

                }

            }

            else

            {

                throw new Exception("Excel解析异常");

            }

            foreach (var item in users)

            {

                if (!checkPhoneGS(item.Phone))

                {

                    throw new Exception("手机号格式不正确:"+ item.Phone);

                }

            }

            return users;

        }