Page 1 of 1

cell merge

PostPosted: Mon Feb 11, 2019 7:21 am
by glively
I've have been able to create a Table in Word and perform cell merges (aka cell span, col span). But I am now using Docx4j (Xlsx4j) to create simple XLSX spreadsheets and need to perform a cell merge, but cannot find out how. I've searched google and he forums here. Does anyone know how? (a horizontal merge)

Thank you!

Re: cell merge

PostPosted: Mon Feb 11, 2019 8:30 pm
by jason
merging cells A1 and B1 results in:

Syntax: [ Download ] [ Hide ]
Using xml Syntax Highlighting
<worksheet ..>
  <dimension ref="A1:B1"/>
:
  <sheetData>
    <row r="1" spans="1:2" >
      <c r="A1" s="1"/>
      <c r="B1" s="1"/>
    </row>
  </sheetData>
  <mergeCells count="1">
    <mergeCell ref="A1:B1"/>
  </mergeCells>
 </worksheet>
 
Parsed in 0.001 seconds, using GeSHi 1.0.8.4


You can consult the spec at http://webapp.docx4java.org/OnlineDemo/ ... index.html for more on the meaning of those elements, and you can upload a sample xlsx to http://webapp.docx4java.org/OnlineDemo/PartsList.html to generate sample code.