# \#xlsx

**URL:** https://discourse.julialang.org/tag/xlsx/511.md

[Latest](https://discourse.julialang.org/latest.md) · [Categories](https://discourse.julialang.org/categories.md) · [Tags](https://discourse.julialang.org/tags.md)

---

## [Merging and formatting cells in Excel from Julia](https://discourse.julialang.org/t/merging-and-formatting-cells-in-excel-from-julia/18786)

<div class="topic-metadata">

**Author:** [@ahmetumutdurmus](https://discourse.julialang.org/u/ahmetumutdurmus)\
**Replies:** 3\
**Last updated:** [August 30, 2026, 2:55pm UTC](https://discourse.julialang.org/t/merging-and-formatting-cells-in-excel-from-julia/18786 "2026-08-30T14:55:30Z")

</div>

Hello, Is there a way of merging cells, formatting and aligning cell contents in an Excel file using Julia? Using a package is also fine. I am currently using XLSX.jl to write to Excel files yet for merging, formatting …

---

## [Write to XLSX file while maintaining formatting](https://discourse.julialang.org/t/write-to-xlsx-file-while-maintaining-formatting/87715)

<div class="topic-metadata">

**Author:** [@Carl\_Talsma](https://discourse.julialang.org/u/Carl_Talsma)\
**Replies:** 2\
**Last updated:** [August 30, 2026, 2:54pm UTC](https://discourse.julialang.org/t/write-to-xlsx-file-while-maintaining-formatting/87715 "2026-08-30T14:54:34Z")

</div>

Hi, I’m trying to write data to a .xlsx file that has already been formatted (cell size, colors, etc.). Is there anyway to write data to a .xlsx file while maintaining the existing formatting? I’m currently using the XL…

---

## [XLSX cell format](https://discourse.julialang.org/t/xlsx-cell-format/113975)

<div class="topic-metadata">

**Author:** [@monty](https://discourse.julialang.org/u/monty)\
**Replies:** 8\
**Last updated:** [August 30, 2026, 8:11am UTC](https://discourse.julialang.org/t/xlsx-cell-format/113975 "2026-08-30T08:11:49Z")

</div>

I tried different approaches to specify a numerical format with 4 decimal places of all the cells in an Excel sheet generated using XLSX.jl. None of them worked. Any suggestions?

---

## [Reading in Excel Data from GitHub](https://discourse.julialang.org/t/reading-in-excel-data-from-github/58055)

<div class="topic-metadata">

**Author:** [@Michael\_Barmann](https://discourse.julialang.org/u/Michael_Barmann)\
**Replies:** 9\
**Last updated:** [August 30, 2026, 8:01am UTC](https://discourse.julialang.org/t/reading-in-excel-data-from-github/58055 "2026-08-30T08:01:14Z")

</div>

I am preparing a Minimal Reproducible Example which involves reading in some data contained in an Excel file. I’m trying to figure out the best way to make the data easily accessible for anyone who wants to run my code. …

---

## [XLSX.jl merging and formatting cells in Excel file?](https://discourse.julialang.org/t/xlsx-jl-merging-and-formatting-cells-in-excel-file/71719)

<div class="topic-metadata">

**Author:** [@programista](https://discourse.julialang.org/u/programista)\
**Replies:** 6\
**Last updated:** [August 30, 2026, 1:44am UTC](https://discourse.julialang.org/t/xlsx-jl-merging-and-formatting-cells-in-excel-file/71719 "2026-08-30T01:44:10Z")

</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

---

## [Excel doesn't recalculate after using XLSX package](https://discourse.julialang.org/t/excel-doesnt-recalculate-after-using-xlsx-package/70881)

<div class="topic-metadata">

**Author:** [@Pahec97](https://discourse.julialang.org/u/Pahec97)\
**Replies:** 8\
**Last updated:** [August 29, 2026, 6:25pm UTC](https://discourse.julialang.org/t/excel-doesnt-recalculate-after-using-xlsx-package/70881 "2026-08-29T18:25:05Z")

</div>

Hello, my problem is as follows: Having a excel file, which does something with the data, for example in figure 1. With XLSX, I rewrite the numbers n1 and n2, code in figure 2. The result of the excel formula doesn’t …

---

## [How do you get formulas created by XLSX.jl to be read automatically in Excel?](https://discourse.julialang.org/t/how-do-you-get-formulas-created-by-xlsx-jl-to-be-read-automatically-in-excel/75701)

<div class="topic-metadata">

**Author:** [@scotts](https://discourse.julialang.org/u/scotts)\
**Replies:** 3\
**Last updated:** [August 29, 2026, 5:46pm UTC](https://discourse.julialang.org/t/how-do-you-get-formulas-created-by-xlsx-jl-to-be-read-automatically-in-excel/75701 "2026-08-29T17:46:34Z")

</div>

I’m making Excel files with XLSX.jl. Everything works as it should, however, I’ve found when I create formulas for the spreadsheet they just show up as text in Excel. I can manually get them to register and process if …

---

## [Sending excel file as response is slow](https://discourse.julialang.org/t/sending-excel-file-as-response-is-slow/116705)

<div class="topic-metadata">

**Author:** [@Sandy45](https://discourse.julialang.org/u/Sandy45)\
**Replies:** 8\
**Last updated:** [August 29, 2026, 4:46pm UTC](https://discourse.julialang.org/t/sending-excel-file-as-response-is-slow/116705 "2026-08-29T16:46:40Z")

</div>

I have an API which get csv file in the request and all I need to do is format and send the response as excel file. I am reading the data into dataframe and directly writing into excel. The issue is that writing data in…

---

## [\[ANN\] XLSX.jl v0.11.0 now released, bringing significant new functionality](https://discourse.julialang.org/t/ann-xlsx-jl-v0-11-0-now-released-bringing-significant-new-functionality/136345)

<div class="topic-metadata">

**Author:** [@TimG](https://discourse.julialang.org/u/TimG)\
**Replies:** 7\
**Last updated:** [July 31, 2026, 11:32am UTC](https://discourse.julialang.org/t/ann-xlsx-jl-v0-11-0-now-released-bringing-significant-new-functionality/136345 "2026-07-31T11:32:52Z")

</div>

This release introduces significant new functionality as set out below. There are almost no changes in existing functional APIs in v0.11.0 compared with v0.10.4. Those changes that have been made are described briefly h…

---

## [Should ownership of XLSX.jl transfer to JuliaData?](https://discourse.julialang.org/t/should-ownership-of-xlsx-jl-transfer-to-juliadata/135023)

<div class="topic-metadata">

**Author:** [@TimG](https://discourse.julialang.org/u/TimG)\
**Replies:** 13\
**Last updated:** [March 13, 2026, 12:29am UTC](https://discourse.julialang.org/t/should-ownership-of-xlsx-jl-transfer-to-juliadata/135023 "2026-03-13T00:29:13Z")

</div>

XLSX.jl seems to be a well used package. It has 298 stars on GitHub, for example. Unfortunately, the package owner seems no longer to be active, and so active maintenance of the package has more or less stopped. Excel i…

---

## [\[ANN\] Write Excel files with XLSX.jl v0.2.0](https://discourse.julialang.org/t/ann-write-excel-files-with-xlsx-jl-v0-2-0/11152)

<div class="topic-metadata">

**Author:** [@felipenoris](https://discourse.julialang.org/u/felipenoris)\
**Replies:** 43\
**Last updated:** [February 25, 2026, 10:55am UTC](https://discourse.julialang.org/t/ann-write-excel-files-with-xlsx-jl-v0-2-0/11152 "2026-02-25T10:55:34Z")

</div>

This is a major upgrage for package XLSX.jl . You can now export your DataFrames to Excel files. XLSX.writetable("df.xlsx", DataFrames.columns(df), DataFrames.names(df)) # df is a DataFrame You can even export multiple…

---

## [XLSX package](https://discourse.julialang.org/t/xlsx-package/135513)

<div class="topic-metadata">

**Author:** [@Terry](https://discourse.julialang.org/u/Terry)\
**Replies:** 5\
**Last updated:** [February 6, 2026, 6:39pm UTC](https://discourse.julialang.org/t/xlsx-package/135513 "2026-02-06T18:39:37Z")

</div>

I am coming to Julia from R. I really like Julia, but it is limited by rather poor documentation. I could not find good documentation for the XLSX package. I found instructions online for creating an xlsx file from a d…

---

## [XLSX.jl ignores stop\_in\_empty\_row](https://discourse.julialang.org/t/xlsx-jl-ignores-stop-in-empty-row/134712)

<div class="topic-metadata">

**Author:** [@Eben60](https://discourse.julialang.org/u/Eben60)\
**Replies:** 5\
**Last updated:** [December 24, 2025, 12:39pm UTC](https://discourse.julialang.org/t/xlsx-jl-ignores-stop-in-empty-row/134712 "2025-12-24T12:39:56Z")

</div>

This is my file f3: an excel table, made with LibreOffice : id val1 val2 1 1.5 4.5 2 2.5 7.5 3 3.5 10.5 4 4.5 13.5 And that is what I get when I read it: julia\> DataFrame(XLSX.readtable(f3, "Sheet1"; header=…

---

## [\[ANN\] LibXLSXWriter.jl - Write XLSX files](https://discourse.julialang.org/t/ann-libxlsxwriter-jl-write-xlsx-files/128390)

<div class="topic-metadata">

**Author:** [@jaakkor2](https://discourse.julialang.org/u/jaakkor2)\
**Replies:** 0\
**Last updated:** [April 25, 2025, 5:43am UTC](https://discourse.julialang.org/t/ann-libxlsxwriter-jl-write-xlsx-files/128390 "2025-04-25T05:43:31Z")

</div>

Happy to announce LibXLSXWriter.jl, a lightweight, feature complete, and fast-loading package to write XLSX (“Excel”) files. This package provides a Julia interface to the libxlsxwriter C library, making it easy and eff…

---

## [Help needed with Documentation](https://discourse.julialang.org/t/help-needed-with-documentation/126417)

<div class="topic-metadata">

**Author:** [@TimG](https://discourse.julialang.org/u/TimG)\
**Replies:** 2\
**Last updated:** [February 28, 2025, 1:55pm UTC](https://discourse.julialang.org/t/help-needed-with-documentation/126417 "2025-02-28T13:55:40Z")

</div>

I’ve made a significant PR to XLSX.jl. It passes all tests except for the test for documentation. I’ve never done formal documentation before, and I don’t really understand what is going on. I’ve tried reading the help…

---

## [Read a .xlsx file](https://discourse.julialang.org/t/read-a-xlsx-file/122770)

<div class="topic-metadata">

**Author:** [@Dionysus](https://discourse.julialang.org/u/Dionysus)\
**Replies:** 15\
**Last updated:** [November 19, 2024, 4:54pm UTC](https://discourse.julialang.org/t/read-a-xlsx-file/122770 "2024-11-19T16:54:51Z")

</div>

Hello, I am encountering difficulties while trying to read a .xlsx file using Julia. Why is my code unable to find the sheet?

---

## [Using Excel as a GUI for data entry](https://discourse.julialang.org/t/using-excel-as-a-gui-for-data-entry/122290)

<div class="topic-metadata">

**Author:** [@rafael.guerra](https://discourse.julialang.org/u/rafael.guerra)\
**Replies:** 4\
**Last updated:** [November 5, 2024, 9:07pm UTC](https://discourse.julialang.org/t/using-excel-as-a-gui-for-data-entry/122290 "2024-11-05T21:07:48Z")

</div>

Can anyone tell me if the following is a ridiculous idea or not. For interactive manual data entry, Excel (or one of its free spreadsheet equivalents) seems like a very versatile kind of “GUI”. The following toy code w…

---

## [XLSX.writexlsx spends excessive time in gc on Windows](https://discourse.julialang.org/t/xlsx-writexlsx-spends-excessive-time-in-gc-on-windows/120687)

<div class="topic-metadata">

**Author:** [@TimG](https://discourse.julialang.org/u/TimG)\
**Replies:** 9\
**Last updated:** [October 4, 2024, 5:56pm UTC](https://discourse.julialang.org/t/xlsx-writexlsx-spends-excessive-time-in-gc-on-windows/120687 "2024-10-04T17:56:06Z")

</div>

I need to create many Excel files in a batch. I use a common template and populate with different data and then write out the file to an IOBuffer() using XLSX.jl. This remains slower than I expected, even after this PR w…

---

## [XLSX.jl cannot handle customXml elements correctly when opening files as templates](https://discourse.julialang.org/t/xlsx-jl-cannot-handle-customxml-elements-correctly-when-opening-files-as-templates/115778)

<div class="topic-metadata">

**Author:** [@TimG](https://discourse.julialang.org/u/TimG)\
**Replies:** 10\
**Last updated:** [September 12, 2024, 10:20am UTC](https://discourse.julialang.org/t/xlsx-jl-cannot-handle-customxml-elements-correctly-when-opening-files-as-templates/115778 "2024-09-12T10:20:56Z")

</div>

This is a cross post from an issue on github. My application uses XLSX.jl to open xlsx files as templates, add data and then write them out again. It stopped working when I moved the template files to a new directory. I…

---

## [No node name error with XLSX](https://discourse.julialang.org/t/no-node-name-error-with-xlsx/90849)

<div class="topic-metadata">

**Author:** [@Pino](https://discourse.julialang.org/u/Pino)\
**Replies:** 8\
**Last updated:** [September 12, 2024, 9:30am UTC](https://discourse.julialang.org/t/no-node-name-error-with-xlsx/90849 "2024-09-12T09:30:48Z")

</div>

Hi, I’m trying to write some code to import spreadsheets into julia, stack them together in an array, manipulate them a bit and save them into a csv. I’m however having problems in importing programmatically the excel …

---

## [Read DataFrame from Excel file skipping one line with units and "cleaning-up" column names](https://discourse.julialang.org/t/read-dataframe-from-excel-file-skipping-one-line-with-units-and-cleaning-up-column-names/114528)

<div class="topic-metadata">

**Author:** [@mjmat](https://discourse.julialang.org/u/mjmat)\
**Replies:** 11\
**Last updated:** [August 24, 2024, 6:14pm UTC](https://discourse.julialang.org/t/read-dataframe-from-excel-file-skipping-one-line-with-units-and-cleaning-up-column-names/114528 "2024-08-24T18:14:23Z")

</div>

I suspect this has been asked before, but I can’t seem to find an answer to this (apparently) simple problem. Let’s assume I have an Excel file with m columns, and the following rows: 1st row: variable names 2nd row: …

---

## [Writing data from Julia to an Excel Spreadsheet](https://discourse.julialang.org/t/writing-data-from-julia-to-an-excel-spreadsheet/53378)

<div class="topic-metadata">

**Author:** [@Peter-Jolly](https://discourse.julialang.org/u/Peter-Jolly)\
**Replies:** 18\
**Last updated:** [August 10, 2024, 6:39pm UTC](https://discourse.julialang.org/t/writing-data-from-julia-to-an-excel-spreadsheet/53378 "2024-08-10T18:39:44Z")

</div>

Hi, I am having some issues with exporting data to excel, using the XLSX package. In my Julia script I have a loop (I = 9000) whereby at each step (value oof i) I need to write out a vector y (130 elements) and several o…

---

## [\[ANN\] YAArguParser and GivEmXL](https://discourse.julialang.org/t/ann-yaarguparser-and-givemxl/117343)

<div class="topic-metadata">

**Author:** [@Eben60](https://discourse.julialang.org/u/Eben60)\
**Replies:** 0\
**Last updated:** [July 22, 2024, 2:01pm UTC](https://discourse.julialang.org/t/ann-yaarguparser-and-givemxl/117343 "2024-07-22T14:01:21Z")

</div>

Shortly introducing two newly registered packages: YAArguParser.jl and GivEmXL.jl: For details see the respective docs. YAArguParser.jl is yet another parsing command-line arguments to Julia programs, the other ones be…

---

## [Issues Importing Excel Files with XLSX.jl Package](https://discourse.julialang.org/t/issues-importing-excel-files-with-xlsx-jl-package/114717)

<div class="topic-metadata">

**Author:** [@phil25](https://discourse.julialang.org/u/phil25)\
**Replies:** 2\
**Last updated:** [May 27, 2024, 12:09pm UTC](https://discourse.julialang.org/t/issues-importing-excel-files-with-xlsx-jl-package/114717 "2024-05-27T12:09:29Z")

</div>

Dear all, I’m currently using the XLSX.jl package in Julia to import several Excel files. Unfortunately, I don’t have access to the original sources of these files and have to work with the existing versions. I’ve enco…

---

## [Using XLSX.jl to save DataFrames to multiple sheets](https://discourse.julialang.org/t/using-xlsx-jl-to-save-dataframes-to-multiple-sheets/69379)

<div class="topic-metadata">

**Author:** [@JackC](https://discourse.julialang.org/u/JackC)\
**Replies:** 4\
**Last updated:** [March 4, 2024, 5:40pm UTC](https://discourse.julialang.org/t/using-xlsx-jl-to-save-dataframes-to-multiple-sheets/69379 "2024-03-04T17:40:44Z")

</div>

I’ve been using XLSX.jl to save dataframes to an Excel workbook. I would like to save each DataFrame to a different sheet in the workbook. The documentation gives an example of such a case that works: df1 = DataFrames.D…

---

## [XLSX and DataFrame column type](https://discourse.julialang.org/t/xlsx-and-dataframe-column-type/110741)

<div class="topic-metadata">

**Author:** [@fdekerme](https://discourse.julialang.org/u/fdekerme)\
**Replies:** 3\
**Last updated:** [February 25, 2024, 6:50pm UTC](https://discourse.julialang.org/t/xlsx-and-dataframe-column-type/110741 "2024-02-25T18:50:10Z")

</div>

Hello everyone :grin:, I want to load an excel file with the XLSX.jl package and then convert it to DataFrame with DataFrame.jl with the following code: data = DataFrame(XLSX.readtable(path\_data, "Sheet1")) However, t…

---

## [Create excel file using data from two dataframes](https://discourse.julialang.org/t/create-excel-file-using-data-from-two-dataframes/110320)

<div class="topic-metadata">

**Author:** [@Sandy45](https://discourse.julialang.org/u/Sandy45)\
**Replies:** 5\
**Last updated:** [February 19, 2024, 3:03pm UTC](https://discourse.julialang.org/t/create-excel-file-using-data-from-two-dataframes/110320 "2024-02-19T15:03:45Z")

</div>

Hello, I have two Data Frames which has headers and data in them, and I want to write data from these two Data Frames into one single excel sheet. I know we can write each data frame data into separate sheet. Any advic…

---

## [MethodError in importing excel table using XLSX](https://discourse.julialang.org/t/methoderror-in-importing-excel-table-using-xlsx/110357)

<div class="topic-metadata">

**Author:** [@PeX](https://discourse.julialang.org/u/PeX)\
**Replies:** 1\
**Last updated:** [February 17, 2024, 10:38pm UTC](https://discourse.julialang.org/t/methoderror-in-importing-excel-table-using-xlsx/110357 "2024-02-17T22:38:20Z")

</div>

Hi everyone, I’m trying to import an excel table into a dataframe using: df\_data = DataFrame(XLSX.readtable(file\_path, "styles", columns="A:H", infer\_eltypes=true, first\_row=3)) But I’m getting MethodError: no met…

---

## [Converting XLSX.Worksheet to DataFrame](https://discourse.julialang.org/t/converting-xlsx-worksheet-to-dataframe/110300)

<div class="topic-metadata">

**Author:** [@PeX](https://discourse.julialang.org/u/PeX)\
**Replies:** 5\
**Last updated:** [February 16, 2024, 7:51pm UTC](https://discourse.julialang.org/t/converting-xlsx-worksheet-to-dataframe/110300 "2024-02-16T19:51:38Z")

</div>

Hi all, I imported an excel file to XLSX data variable named xf, now I’m trying to convert one of the worksheets xf\[2\] into a dataframe. The worksheet have two columns, one date in the form of 1993-04-30 and the other …

---

## [Updating an XLSX file simultaneously by more than one Julia script](https://discourse.julialang.org/t/updating-an-xlsx-file-simultaneously-by-more-than-one-julia-script/105397)

<div class="topic-metadata">

**Author:** [@math\_opt](https://discourse.julialang.org/u/math_opt)\
**Replies:** 5\
**Last updated:** [October 26, 2023, 12:05pm UTC](https://discourse.julialang.org/t/updating-an-xlsx-file-simultaneously-by-more-than-one-julia-script/105397 "2023-10-26T12:05:13Z")

</div>

I have a Julia script which does some calculations and in the end, the output is written to an Excel file using the following function: function populate\_spreadsheet(sol, instance\_number, sheet\_number, stat::Symbol) …

[Next page](https://discourse.julialang.org/tag/xlsx/511.md?match_all_tags=true&page=1&tags%5B%5D=xlsx)