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

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

Any other way in Julia ? Other packages? Paul

ExcelReaders.jl uses python package xlrd, and xlrd seems to have more functionalities regarding formatting. API Reference — xlrd 2.0.1 documentation You probably can use xlrd functions from Julia but I’m not sure, because I’ve never used them myself :slight_smile:

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

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

XLSX.jl merging and formatting cells in Excel file?

General Usage

rafael.guerra November 20, 2021, 7:47am 4

Using PyCall to call openpyxl. See this post and this article.

Topic		Replies	Views
Merging and formatting cells in Excel from Julia General Usage question , package , xlsx	3	1386	August 30, 2026
Write to XLSX file while maintaining formatting General Usage question , xlsx , formatting	2	728	August 30, 2026
A few questions on exporting charts and formatted output to Excel General Usage excel	8	1242	August 27, 2026
[ANN] XLSX.jl v0.11.0 now released, bringing significant new functionality Package Announcements package , xlsx	7	1423	July 31, 2026
[ANN] Write Excel files with XLSX.jl v0.2.0 Community package , xlsx	43	7822	February 25, 2026

XLSX.jl merging and formatting cells in Excel file?

Related topics