ferdi.maillist Posted January 23, 2013 Share Posted January 23, 2013 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 useproperty 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! Link to comment Share on other sites More sharing options...
sriharigouru.career Posted January 23, 2013 Share Posted January 23, 2013 i had this sort of problem, when cells are starting at different point in the other row. For example Row 1 had two columns with 10 and 30 width and Row 2 had four columns with width of 10 each. both rows are starting at the same point(left and top). Please note, my report did not multiple sheet like in your requirement. Hope it helps Link to comment Share on other sites More sharing options...
ferdi.maillist Posted January 23, 2013 Author Share Posted January 23, 2013 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. Link to comment Share on other sites More sharing options...
Solution ferdi.maillist Posted January 25, 2013 Author Solution Share Posted January 25, 2013 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! ;) Link to comment Share on other sites More sharing options...
athimmig Posted November 11, 2014 Share Posted November 11, 2014 I found that expanding the width of the entire report and shifting cells to the right of the area where the merge happens cleaned it up for me. The columns where the merge happened was reduced to 0 in width and empty when I ran the report again. If you don't mind the extra columns being there as they are all but invisible then this solution is confirmed to work. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now