public void ForMember(string columnName, Expression <Func <T, object> > entityExpression)
{
XlsEntity xlsEntity = new XlsEntity();
xlsEntity.ColumnName = columnName;
xlsEntity.EntityName = GetPropertyName(entityExpression);
xlsHeader.Add(xlsEntity);
}
public void ForMember(string columnName, string entityName)
{
XlsEntity xlsEntity = new XlsEntity();
xlsEntity.ColumnName = columnName;
xlsEntity.EntityName = entityName;
xlsHeader.Add(xlsEntity);
}
public void ForMember(string columnName, string entityName, Func <string, object> func)
{
XlsEntity xlsEntity = new XlsEntity();
xlsEntity.ColumnName = columnName;
xlsEntity.EntityName = entityName;
xlsEntity.ConvertFunc = func;
xlsHeader.Add(xlsEntity);
}
public void ForMember(Expression <Func <T, object> > entityExpression, Func <string, object> func)
{
XlsEntity xlsEntity = new XlsEntity();
xlsEntity.EntityName = GetPropertyName(entityExpression);
xlsEntity.ColumnName = xlsEntity.EntityName;
xlsEntity.ConvertFunc = func;
xlsHeader.Add(xlsEntity);
}
/// <summary>
/// Excel文件流加载到内存
/// </summary>
/// <param name="ExcelFileStream">文件流</param>
/// <param name="SheetIndex">加载页码</param>
/// <returns></returns>
public List <T> LoadFromExcel(Stream ExcelFileStream, int SheetIndex = 0)
{
List <T> resultList = new List <T>();
using (ExcelPackage package = new ExcelPackage(ExcelFileStream))
{
ExcelWorksheet worksheet = package.Workbook.Worksheets[SheetIndex];//选定 指定页
int colStart = worksheet.Dimension.Start.Column;
int colEnd = worksheet.Dimension.End.Column;
int rowStart = worksheet.Dimension.Start.Row;
int rowEnd = worksheet.Dimension.End.Row;
PropertyInfo[] propertyInfoList = typeof(T).GetProperties();
XlsEntity xlsEntity;
#region 将实体和excel列标题进行对应绑定,添加到集合中
for (int i = colStart; i <= colEnd; i++)
{
string columnName = worksheet.Cells[rowStart, i].Value == null ? "0" : worksheet.Cells[rowStart, i].Value.ToString();
xlsEntity = xlsHeader.FirstOrDefault(e => e.ColumnName == columnName);
for (int j = 0; j < propertyInfoList.Length; j++)
{
if (xlsEntity != null && xlsEntity.ColumnName == columnName)
{
xlsEntity.ColumnIndex = i;
xlsHeader.Add(xlsEntity);
}
else if (propertyInfoList[j].Name == columnName)
{
xlsEntity = new XlsEntity();
xlsEntity.ColumnName = columnName;
xlsEntity.EntityName = propertyInfoList[j].Name;
xlsEntity.ColumnIndex = i;
xlsHeader.Add(xlsEntity);
break;
}
}
}
#endregion
#region 根据对应的实体名列名的对应绑定就行值的绑定
for (int row = rowStart + 1; row <= rowEnd; row++)
{
T result = new T();
foreach (PropertyInfo p in propertyInfoList)
{
var xlsRow = xlsHeader.FirstOrDefault(e => e.EntityName == p.Name);
if (xlsRow == null || xlsRow?.ColumnIndex == 0)
{
continue;
}
ExcelRange cell = worksheet.Cells[row, xlsRow.ColumnIndex];
if (cell.Value == null)
{
continue;
}
try
{
if (xlsRow.ConvertFunc != null)
{
object entityValue = xlsRow.ConvertFunc(cell.Value.ToString());
p.SetValue(result, entityValue);
}
else
{
cellBindValue(result, p, cell);
}
}
catch (Exception ex)
{
//if (result.ErrColumn == null) result.ErrColumn = new List<string>();
//if (result.ErrMessage == null) result.ErrMessage = new List<string>();
//if (result.ErrValue == null) result.ErrValue = new List<string>();
//result.ErrColumn.Add(p.Name);
//result.ErrMessage.Add(ex.Message);
//result.ErrValue.Add(cell.Value.ToString());
//result.IsErr = true;
}
}
resultList.Add(result);
}
#endregion
}
return(resultList);
}
