> -----Original Message----- > From: Greg Woolsey [mailto:greg.wool...@gmail.com] > Sent: Tuesday, May 01, 2018 5:56 PM > To: POI Users List <user@poi.apache.org> > Subject: Re: XSSFTable with Merged Ranges > > The best way I've found to work through issues like this (I also modify > tables, but don't need merged cells) is to mock up what I want it to end up > like in Excel, save it to XLSX, mock up the same (or what I want to be the > same) content via POI and save it to XLSX. I then unzip the files and > compare their contents, looking for differences. This is a bit tedious, > since XML element and attribute order will almost surely differ, but it's > the only way I know to make sure I can recreate something Excel will accept.
Thanks for the advice. When I tried it out, I found that Excel itself doesn't handle Tables on merged ranges. When you try it, Excel removes the merged ranges.
