/// <summary> /// Based on the table name template was copied to the workbook range /// template is in following format. /// %DataTableName.ColumnName /// </summary> /// <param name="range">Workbook Range</param> /// <param name="tablename">Data Table name</param> private static void FillTemplate(IWorkbook workbook, string tablename) { IWorksheet SourceSheet = workbook.Worksheets[1]; IWorksheet MainSheet = workbook.Worksheets[0]; IRange SourceRange; IRange TargetRange; if (SourceSheet != null && MainSheet != null) { TargetRange = MainSheet.Range["A1:E3"]; if (tablename.Equals("Products")) { SourceRange = SourceSheet.Range["A6:E8"]; } else if (tablename.Equals("Customers")) { SourceRange = SourceSheet.Range["A11:E13"]; } else { SourceRange = SourceSheet.Range["A1:E3"]; } SourceRange.CopyTo(TargetRange); } }