ferdi.maillist

I couldn't find a way to solve the problem, so I've persuaded our customer, not to use, or to modify the template in the first excel worksheet. After modifying the template now everything looks fine. Thanks! ;)

Thanks for your reply sriharigouru.career, The problem is the template, which I have to use in the report design and as I mentioned before, I'm not allowed to change the template, which causes the merged cells. If I remove the template from my report, I can get a beautiful excel file, which does not have any merged cells. What I'm actually asking is, if there's a way to create a new excel worksheet, which does not have any merged cells.

I'm having problems with excel exports in Jasper Reports. The output excel files of my reports have unwanted merged cells, depending on the report template I use for each report. I'm displaying report template in first excel sheet, and "Column Header" and "Data" in the second excel sheet. what I'm trying to do is to ignore merged cells in second sheet. I use property to create second sheet. I'm not allowed to change the template, so I shoud find a way to ignore merged cells in the second sheet, here is a screenshot of my excel file as you can see, in the second column there are four merged cells. Any ideas to ignore those unwanted merged cells? Thanks!