cell merge

[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!

[jason]

merging cells A1 and B1 results in:

Syntax: [ Download ] [ Hide ]

Syntax: [ Download ] [ Show ]

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.