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"/>
    <row r="1" spans="1:2" >
      <c r="A1" s="1"/>
      <c r="B1" s="1"/>
  <mergeCells count="1">
    <mergeCell ref="A1:B1"/>
Parsed in 0.001 seconds, using GeSHi

You can consult the spec at ... index.html for more on the meaning of those elements, and you can upload a sample xlsx to to generate sample code.