The environment is 11g.

Not sure about your question. Is this fast for 4-5 reports or then also excel download is slow? meaning?

Sample data had only 5 rows. for my requirement, output data is 40-50 K rows. The issue I'm trying to understand is whether this is expected from BI Publisher, because query itself finishes in the DB in 2-3 minutes, and it takes another 9-10 minutes to get the output.

Hi Brajesh Thanks for your reply, I confirm that there are no merged cells being generated in the output file. The performance issue after observation looks like coming during the excel file generation by the report engine. I tried by monitoring the report by scheduling it. The query runs in database in a few minutes but…

I've attached the sample xml and the template herewith. Thanks Gulshan.