/// <summary> /// 获取单元格数值 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="range"></param> /// <returns></returns> public static IEnumerable <T> GetValues <T>(this ExcelReference range) { if (range.CellsCount() == 1) { return(new T[] { range.GetValue().ConvertTo <T>() }); } return(((object[, ])range.GetValue()).AsIEnumerable <T>()); }