@oggymishra,
Aspose.Cells cannot process smarter makers horizontally and vertically together. Please generate repeated formula smart makers with your datasource, try the following codes with the template file:
e.g.
Sample code:
string companyInfo = "{\"TableName\":\"CompanyInfo\", \"Table\": [{\"Ticker\":\"MCD\",\"Depth\":\"IMPL\",\"Revision\":\"11/12/2020\",\"Tab\":\"Cash Flow\",\"View\":\"CD\",\"SheetName\":\"Cash Flow-CF\"}]}";
string parameterInfo = "{\"TableName\":\"Parameter\", \"Table\": [{\"Id\":\"N_5774220\",\"Name\":\"Net income (CF)\", \"Unit\":\"$M\"}, {\"Id\":\"N_5774220\",\"Name\":\"Net income (CF)\", \"Unit\":\"$M\"}, {\"Id\":\"N_5774220\",\"Name\":\"Net income (CF)\", \"Unit\":\"$M\"}, {\"Id\":\"N_5774220\",\"Name\":\"Net income (CF)\", \"Unit\":\"$M\"}, {\"Id\":\"N_5774220\",\"Name\":\"Net income (CF)\", \"Unit\":\"$M\"}, {\"Id\":\"N_5774220\",\"Name\":\"Net income (CF)\", \"Unit\":\"$M\"}, {\"Id\":\"N_5774220\",\"Name\":\"Net income (CF)\", \"Unit\":\"$M\"}, {\"Id\":\"N_5774220\",\"Name\":\"Net income (CF)\", \"Unit\":\"$M\"}, {\"Id\":\"N_5774220\",\"Name\":\"Net income (CF)\", \"Unit\":\"$M\"}, {\"Id\":\"N_5774220\",\"Name\":\"Net income (CF)\", \"Unit\":\"$M\"}, {\"Id\":\"N_5774220\",\"Name\":\"Net income (CF)\", \"Unit\":\"$M\"}, {\"Id\":\"N_5774220\",\"Name\":\"Net income (CF)\", \"Unit\":\"$M\"}, {\"Id\":\"N_5774220\",\"Name\":\"Net income (CF)\", \"Unit\":\"$M\"}, {\"Id\":\"N_5774220\",\"Name\":\"Net income (CF)\", \"Unit\":\"$M\"}, {\"Id\":\"N_5774220\",\"Name\":\"Net income (CF)\", \"Unit\":\"$M\"}, {\"Id\":\"N_5774220\",\"Name\":\"Net income (CF)\", \"Unit\":\"$M\"}, {\"Id\":\"N_5774220\",\"Name\":\"Net income (CF)\", \"Unit\":\"$M\"}, {\"Id\":\"N_5774220\",\"Name\":\"Net income (CF)\", \"Unit\":\"$M\"}, {\"Id\":\"N_5774220\",\"Name\":\"Net income (CF)\", \"Unit\":\"$M\"}, {\"Id\":\"N_5774220\",\"Name\":\"Net income (CF)\", \"Unit\":\"$M\"}]}";
string periodInfo = "{\"TableName\":\"Period\", \"Table\": [{\"Value\":\"1Q-19\",\"Formula\":\"&=&=GetData($C$3, {0}${-3}, $C{0}, {0}${-1}, $C$5, $C$4, $C$7)\" }, {\"Value\":\"2Q-19\",\"Formula\":\"&=&=GetData($C$3, {0}${-3}, $C{0}, {0}${-1}, $C$5, $C$4, $C$7)\"}]}";
var companyInfoTable = JsonConvert.DeserializeObject<DataTableMapping>(companyInfo);
// TODO: make a consistent deserliazer to set this name directly.
companyInfoTable.Table.TableName = companyInfoTable.TableName;
var parameterTable = JsonConvert.DeserializeObject<DataTableMapping>(parameterInfo);
parameterTable.Table.TableName = parameterTable.TableName;
var periodTable = JsonConvert.DeserializeObject<DataTableMapping>(periodInfo);
periodTable.Table.TableName = periodTable.TableName;
Aspose.Cells.Cells cells = wb.Worksheets[0].Cells;
report.SetDataSource(companyInfoTable.Table);
report.SetDataSource(periodTable.Table);
report.Process(true);
report.SetDataSource(parameterTable.Table);
report.Process();