cell merge
Posted:
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
Posted:
Mon Feb 11, 2019 8:30 pm
by jason
merging cells A1 and B1 results in:
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.