/// <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);
}
}