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 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	2	1281	December 18, 2018
Write to XLSX file while maintaining formatting General Usage question , xlsx , formatting	1	643	September 24, 2022
A few questions on exporting charts and formatted output to Excel General Usage excel	7	1110	March 30, 2022
[ANN] XLSX.jl v0.11.0 now released, bringing significant new functionality Package Announcements package , xlsx	5	716	April 9, 2026
[ANN] Write Excel files with XLSX.jl v0.2.0 Community package , xlsx	43	7413	February 25, 2026

XLSX.jl merging and formatting cells in Excel file?

Related topics