/// <summary>
/// 获取错误消息
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="output"></param>
/// <returns></returns>
public static string GetErrorMessage <T>(this ExcelSheetDataOutput <T> output) where T : class, new()
{
if (output == null || output.InvalidCount <= 0)
{
return(null);
}
return($"工作表【{output.SheetName}】数据错误：\r\n{string.Join(" ", output.Rows.Select(a => a.GetErrorMessage()).Where(a => a != null))}\r\n");
}
/// <summary>
/// 检查错误并抛出异常
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="output"></param>
/// <returns></returns>
public static void CheckError <T>(this ExcelSheetDataOutput <T> output) where T : class, new()
{
if (output == null)
{
return;
}
if (output.InvalidCount > 0)
{
throw new Exception(output.GetErrorMessage());
}
}
/// <summary>
/// 获取所有数据
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="output"></param>
/// <returns></returns>
public static IEnumerable <T> GetAllData <T>(this ExcelSheetDataOutput <T> output) where T : class, new()
{
return(output?.GetData(null));
}
/// <summary>
/// 获取无效数据
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="output"></param>
/// <param name="isValid">是否有效，null全部</param>
/// <returns></returns>
private static IEnumerable <T> GetData <T>(this ExcelSheetDataOutput <T> output, bool?isValid) where T : class, new()
{
return(output?.Rows?.GetData(isValid));
}
/// <summary>
/// 获取有效数据
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="output"></param>
/// <returns></returns>
public static IEnumerable <T> GetValidData <T>(this ExcelSheetDataOutput <T> output) where T : class, new()
{
return(output?.GetData(true));
}