# XLSX.jl merging and formatting cells in Excel file?

**URL:** <https://discourse.julialang.org/t/xlsx-jl-merging-and-formatting-cells-in-excel-file/71719>\
**Category:** General Usage\
**Tags:** xlsx\
**Created:** [November 18, 2021, 12:39pm UTC](https://discourse.julialang.org/t/xlsx-jl-merging-and-formatting-cells-in-excel-file/71719 "2021-11-18T12:39:49Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![programista](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/programista/32/5372_2.png) [@programista](https://discourse.julialang.org/u/programista)\
**Post date:** [November 18, 2021, 12:39pm UTC](https://discourse.julialang.org/t/xlsx-jl-merging-and-formatting-cells-in-excel-file/71719/1 "2021-11-18T12:39:49Z")

</div>

XLSX.jl How merging and formatting cells in Excel file?

1 How to combine/merge cells in a worksheet e.g. A1: C3  
2. How to format table boundaries

Paul

---

<div class="post-metadata">

**Author:** ![YongHee-Kim](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/yonghee-kim/32/5965_2.png) [@YongHee-Kim](https://discourse.julialang.org/u/YongHee-Kim)\
**Post date:** [November 20, 2021, 1:43am UTC](https://discourse.julialang.org/t/xlsx-jl-merging-and-formatting-cells-in-excel-file/71719/2 "2021-11-20T01:43:12Z")

</div>

Well unfortunately XLSX.jl doesn’t provide any functionality for formatting. So merging cells with XLSX.jl is impossible

---

<div class="post-metadata">

**Author:** ![programista](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/programista/32/5372_2.png) [@programista](https://discourse.julialang.org/u/programista)\
**Post date:** [November 20, 2021, 7:31am UTC](https://discourse.julialang.org/t/xlsx-jl-merging-and-formatting-cells-in-excel-file/71719/3 "2021-11-20T07:31:54Z")

</div>

Any other way in Julia ? Other packages?  
Paul

---

<div class="post-metadata">

**Author:** ![rafael.guerra](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/rafael.guerra/32/216610_2.png) [@rafael.guerra](https://discourse.julialang.org/u/rafael.guerra)\
**Post date:** [November 20, 2021, 7:47am UTC](https://discourse.julialang.org/t/xlsx-jl-merging-and-formatting-cells-in-excel-file/71719/4 "2021-11-20T07:47:11Z")

</div>

Using `PyCall` to call `openpyxl`. See [this post](https://discourse.julialang.org/t/julia-using-openpyxl-to-change-column-width-row-height/45172/6) and [this article](https://www.google.com/amp/s/www.geeksforgeeks.org/python-adjusting-rows-and-columns-of-an-excel-file-using-openpyxl-module/amp/).

---

<div class="post-metadata">

**Author:** ![YongHee-Kim](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/yonghee-kim/32/5965_2.png) [@YongHee-Kim](https://discourse.julialang.org/u/YongHee-Kim)\
**Post date:** [November 20, 2021, 7:59am UTC](https://discourse.julialang.org/t/xlsx-jl-merging-and-formatting-cells-in-excel-file/71719/5 "2021-11-20T07:59:45Z")

</div>

[ExcelReaders.jl](https://ExcelReaders) uses python package xlrd, and xlrd seems to have more functionalities regarding formatting. [API Reference — xlrd 2.0.1 documentation](https://xlrd.readthedocs.io/en/latest/api.html#module-xlrd.formatting)

You probably can use xlrd functions from Julia but I’m not sure, because I’ve never used them myself 🙂

---

<div class="post-metadata">

**Author:** ![TimG](https://avatars.discourse-cdn.com/v4/letter/t/82dd89/32.png) [@TimG](https://discourse.julialang.org/u/TimG)\
**Post date:** [August 29, 2026, 8:47pm UTC](https://discourse.julialang.org/t/xlsx-jl-merging-and-formatting-cells-in-excel-file/71719/6 "2026-08-29T20:47:58Z")

</div>

XLSX.jl provides a full set of formatting functions, including conditional formatting, in versions v0.11 and newer.

---

<div class="post-metadata">

**Author:** ![mwsohn](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/mwsohn/32/2696_2.png) [@mwsohn](https://discourse.julialang.org/u/mwsohn)\
**Post date:** [August 30, 2026, 1:44am UTC](https://discourse.julialang.org/t/xlsx-jl-merging-and-formatting-cells-in-excel-file/71719/7 "2026-08-30T01:44:10Z")

</div>

There is a package called LibXLSXWriter.jl. Check it out. This is a fantastic package for creating Excel Spreadsheets with formatting.