/// <summary>
/// export excel via template
/// </summary>
/// <typeparam name="TEntity">Entity Type</typeparam>
/// <param name="entities">entities</param>
/// <param name="templateStream">templateStream</param>
/// <param name="excelFormat">excelFormat</param>
/// <param name="sheetIndex">sheetIndex,zero by default</param>
/// <param name="extraData">extraData</param>
/// <returns>exported excel bytes</returns>
public static byte[] ToExcelBytesByTemplate<TEntity>([NotNull] this IEnumerable<TEntity> entities, Stream templateStream, ExcelFormat excelFormat = ExcelFormat.Xls, int sheetIndex = 0, object extraData = null)
{
if (templateStream == null)
{
throw new ArgumentNullException(nameof(templateStream));
}
var workbook = ExcelHelper.LoadExcel(templateStream, excelFormat);
return ToExcelBytesByTemplate(entities, workbook, sheetIndex, extraData);
}
/// <summary>
/// export excel via template
/// </summary>
/// <typeparam name="TEntity">Entity Type</typeparam>
/// <param name="entities">entities</param>
/// <param name="templateBytes">templateBytes</param>
/// <param name="excelFormat">excelFormat</param>
/// <param name="excelPath">excelPath</param>
/// <param name="sheetIndex">sheetIndex,zero by default</param>
/// <param name="extraData">extraData</param>
/// <returns>exported excel bytes</returns>
public static void ToExcelFileByTemplate<TEntity>([NotNull] this IEnumerable<TEntity> entities, byte[] templateBytes, string excelPath, ExcelFormat excelFormat = ExcelFormat.Xls, int sheetIndex = 0, object extraData = null)
{
if (templateBytes == null)
{
throw new ArgumentNullException(nameof(templateBytes));
}
if (excelPath == null)
{
throw new ArgumentNullException(nameof(excelPath));
}
var workbook = ExcelHelper.LoadExcel(templateBytes, excelFormat);
entities.ToExcelFileByTemplate(workbook, excelPath, sheetIndex, extraData);
}
/// <summary>
/// export excel via template
/// </summary>
/// <typeparam name="TEntity">Entity Type</typeparam>
/// <param name="entities">entities</param>
/// <param name="templatePath"></param>
/// <param name="excelPath">templateBytes</param>
/// <param name="sheetIndex">sheetIndex,zero by default</param>
/// <param name="extraData">extraData</param>
/// <returns>exported excel bytes</returns>
public static int ToExcelFileByTemplate <TEntity>([NotNull] this IEnumerable <TEntity> entities, string templatePath, string excelPath, int sheetIndex = 0, object extraData = null)
{
if (templatePath == null)
{
throw new ArgumentNullException(nameof(templatePath));
}
if (excelPath == null)
{
throw new ArgumentNullException(nameof(excelPath));
}
var workbook = ExcelHelper.LoadExcel(templatePath);
return(entities.ToExcelFileByTemplate(workbook, excelPath, sheetIndex, extraData));
}
/// <summary>
/// export excel via template
/// </summary>
/// <typeparam name="TEntity">Entity Type</typeparam>
/// <param name="entities">entities</param>
/// <param name="templatePath">templatePath</param>
/// <param name="sheetIndex">sheetIndex,zero by default</param>
/// <param name="extraData">extraData</param>
/// <returns>exported excel bytes</returns>
public static byte[] ToExcelBytesByTemplate<TEntity>([NotNull] this IEnumerable<TEntity> entities, string templatePath, int sheetIndex = 0, object extraData = null)
{
return ToExcelBytesByTemplate(entities, ExcelHelper.LoadExcel(templatePath), sheetIndex, extraData);
}