# \#excel

**URL:** https://discourse.julialang.org/tag/excel/616.md

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

---

## [Excel files & Julia?](https://discourse.julialang.org/t/excel-files-julia/91253)

<div class="topic-metadata">

**Author:** [@BLI](https://discourse.julialang.org/u/BLI)\
**Replies:** 6\
**Last updated:** [September 1, 2026, 6:14am UTC](https://discourse.julialang.org/t/excel-files-julia/91253 "2026-09-01T06:14:51Z")

</div>

It’s exam time, and I need to script the reading of content from a number of Excel files, put the information into a DataFrame, compute grades, and write the result to an Excel file. Last time I did this, I used package…

---

## [How can I read an excel named table in Julia?](https://discourse.julialang.org/t/how-can-i-read-an-excel-named-table-in-julia/103984)

<div class="topic-metadata">

**Author:** [@Emmanouil\_Bakirtzis](https://discourse.julialang.org/u/Emmanouil_Bakirtzis)\
**Replies:** 6\
**Last updated:** [August 30, 2026, 12:46am UTC](https://discourse.julialang.org/t/how-can-i-read-an-excel-named-table-in-julia/103984 "2026-08-30T00:46:17Z")

</div>

Is there a way to read an excel named table in Julia? By “excel named table” I mean the object that is created in office excel you go insert → table (it is different that a named cell range) I have tried all julia exce…

---

## [Generate excel spreadsheet from julia equations?](https://discourse.julialang.org/t/generate-excel-spreadsheet-from-julia-equations/92444)

<div class="topic-metadata">

**Author:** [@OliverEvans96](https://discourse.julialang.org/u/OliverEvans96)\
**Replies:** 1\
**Last updated:** [August 29, 2026, 5:43pm UTC](https://discourse.julialang.org/t/generate-excel-spreadsheet-from-julia-equations/92444 "2026-08-29T17:43:11Z")

</div>

Hi all, Imagine a spreadsheet with columns A, B, C. Suppose A are observations, and B = B(A), C = C(A, B) are defined by excel formulas involving the previous columns. This is a pretty common scenario in excel. I was j…

---

## [A few questions on exporting charts and formatted output to Excel](https://discourse.julialang.org/t/a-few-questions-on-exporting-charts-and-formatted-output-to-excel/56001)

<div class="topic-metadata">

**Author:** [@yet\_another\_pythonis](https://discourse.julialang.org/u/yet_another_pythonis)\
**Replies:** 8\
**Last updated:** [August 27, 2026, 1:06pm UTC](https://discourse.julialang.org/t/a-few-questions-on-exporting-charts-and-formatted-output-to-excel/56001 "2026-08-27T13:06:57Z")

</div>

I am trying to understand if I can move part of my code from Python to Julia, at least the part which cannot be optimised with Numba, and have a few questions on exporting data from Julia to Excel. This is crucial becau…

---

## [Is the FileIO.jl ecosystem still alive?](https://discourse.julialang.org/t/is-the-fileio-jl-ecosystem-still-alive/133880)

<div class="topic-metadata">

**Author:** [@TimG](https://discourse.julialang.org/u/TimG)\
**Replies:** 5\
**Last updated:** [August 25, 2026, 11:10pm UTC](https://discourse.julialang.org/t/is-the-fileio-jl-ecosystem-still-alive/133880 "2026-08-25T23:10:32Z")

</div>

I saw a reference to FileIO.jl in the thread announcing UFFFiles.jl and followed it up out of curiosity. Is FileIO.jl still in widespread use? I ask because, according to its registry, it officially supports Excel thro…

---

## [Julia for Excel users](https://discourse.julialang.org/t/julia-for-excel-users/135599)

<div class="topic-metadata">

**Author:** [@technocrat](https://discourse.julialang.org/u/technocrat)\
**Replies:** 4\
**Last updated:** [February 13, 2026, 5:23pm UTC](https://discourse.julialang.org/t/julia-for-excel-users/135599 "2026-02-13T17:23:30Z")

</div>

Use your own spreadsheet instead of the demo, and if you do, the fake data will be bypassed # ============================================================================== # Julia Starter Template for Excel Users # Mis…

---

## [Excel's pivot table equivalent with DataFramesMeta](https://discourse.julialang.org/t/excels-pivot-table-equivalent-with-dataframesmeta/123456)

<div class="topic-metadata">

**Author:** [@HenriDeh](https://discourse.julialang.org/u/HenriDeh)\
**Replies:** 2\
**Last updated:** [December 4, 2024, 2:44pm UTC](https://discourse.julialang.org/t/excels-pivot-table-equivalent-with-dataframesmeta/123456 "2024-12-04T14:44:33Z")

</div>

Hello, So I have a table like df = DataFrame(a= \[1,1,2,2\], b = \[1,2,1,2\], c = \[1,2,3,4\]) And I would like to create a table that, if I were to work in Excel, I could obtain with a pivot table with a for the Rows and b …

---

## [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…

---

## [\[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…

---

## [University proposing Excel training to analyse data :-/](https://discourse.julialang.org/t/university-proposing-excel-training-to-analyse-data/115229)

<div class="topic-metadata">

**Author:** [@sylvaticus](https://discourse.julialang.org/u/sylvaticus)\
**Replies:** 1\
**Last updated:** [June 5, 2024, 12:24pm UTC](https://discourse.julialang.org/t/university-proposing-excel-training-to-analyse-data/115229 "2024-06-05T12:24:23Z")

</div>

From our university newsletter: “Cette formation s’adresse à tous les personnels de l’Université (doctorants, enseignants-chercheurs, …) qui souhaitent utiliser le logiciel Excel pour le traitement de leurs données.” E…

---

## [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…

---

## [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 …

---

## [Transpose columns to rows](https://discourse.julialang.org/t/transpose-columns-to-rows/105508)

<div class="topic-metadata">

**Author:** [@davide445](https://discourse.julialang.org/u/davide445)\
**Replies:** 9\
**Last updated:** [October 30, 2023, 6:37pm UTC](https://discourse.julialang.org/t/transpose-columns-to-rows/105508 "2023-10-30T18:37:23Z")

</div>

To prepare the import into an ERP system of a list of customers (identified from an id) and their related 10 years historical usage data of a system, I needed to shift the data from customer1, y1:value1, y2:value2, … y…

---

## [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) …

---

## [How to directly specify datatype when reading from excel? Matrix{Any} to Vector{Int64}](https://discourse.julialang.org/t/how-to-directly-specify-datatype-when-reading-from-excel-matrix-any-to-vector-int64/88853)

<div class="topic-metadata">

**Author:** [@Mike\_comen](https://discourse.julialang.org/u/Mike_comen)\
**Replies:** 4\
**Last updated:** [October 18, 2022, 9:51pm UTC](https://discourse.julialang.org/t/how-to-directly-specify-datatype-when-reading-from-excel-matrix-any-to-vector-int64/88853 "2022-10-18T21:51:45Z")

</div>

I’d like to have some coulmns of an excel sheet in Julia in a Vector{Int64} format. However, it gives me Matrix{Any}. My try: xf = XLSX.readxlsx(\`"C:/Data/sales.xlsx"\`) A = xf\["sheet1!A2:A100"\]) A\_vec = vec(A) …

---

## [Why XLSX.readxlsx not working?](https://discourse.julialang.org/t/why-xlsx-readxlsx-not-working/84052)

<div class="topic-metadata">

**Author:** [@Optimization](https://discourse.julialang.org/u/Optimization)\
**Replies:** 4\
**Last updated:** [July 11, 2022, 3:35pm UTC](https://discourse.julialang.org/t/why-xlsx-readxlsx-not-working/84052 "2022-07-11T15:35:39Z")

</div>

I’m trying to read a first column of an excel file (from sheet2 column d2). This is my try: using XLSX, , DataFrames xf = XLSX.readxlsx("C:/Data/sample.xlsx") sh = xf\["sheet2"\] sh\["d2"\] ; sh\[3\]; # or any other simila…

---

## [Set Up Julia Pro](https://discourse.julialang.org/t/set-up-julia-pro/81530)

<div class="topic-metadata">

**Author:** [@brett\_knoss](https://discourse.julialang.org/u/brett_knoss)\
**Replies:** 0\
**Last updated:** [May 23, 2022, 7:26pm UTC](https://discourse.julialang.org/t/set-up-julia-pro/81530 "2022-05-23T19:26:15Z")

</div>

Is it still possible to set up JuliaPro? I’d like to use JuliaInXL. If this is not valid, is there another option to integrate Julia into Excel?

---

## [How to convert comma-seperated number to number?](https://discourse.julialang.org/t/how-to-convert-comma-seperated-number-to-number/76906)

<div class="topic-metadata">

**Author:** [@yummy527](https://discourse.julialang.org/u/yummy527)\
**Replies:** 7\
**Last updated:** [February 23, 2022, 3:47am UTC](https://discourse.julialang.org/t/how-to-convert-comma-seperated-number-to-number/76906 "2022-02-23T03:47:59Z")

</div>

Data are read from excel xls file in which some numbers are stored as text and comma-seperated. excel screenshot: Dataframe sreenshot (read using ExcelFiles.jl): I have tried function tryparse or parse, but it doe…

---

## ["Skip" parameter XLSX package](https://discourse.julialang.org/t/skip-parameter-xlsx-package/72239)

<div class="topic-metadata">

**Author:** [@jnewbie](https://discourse.julialang.org/u/jnewbie)\
**Replies:** 2\
**Last updated:** [November 30, 2021, 8:04am UTC](https://discourse.julialang.org/t/skip-parameter-xlsx-package/72239 "2021-11-30T08:04:26Z")

</div>

Hi everyone, I am basically “translating” a R code into a Julia code, here is one of the line of the R code : read\_excel(‘Results.xlsx’, sheet = ‘x’, col\_names = FALSE, col\_types = “numeric”, na = “”, skip = 0) To d…

---

## [Excel data to dataframes](https://discourse.julialang.org/t/excel-data-to-dataframes/65264)

<div class="topic-metadata">

**Author:** [@mjanun](https://discourse.julialang.org/u/mjanun)\
**Replies:** 16\
**Last updated:** [July 25, 2021, 7:21pm UTC](https://discourse.julialang.org/t/excel-data-to-dataframes/65264 "2021-07-25T19:21:39Z")

</div>

I have some data in different columns of an Excel sheet. I want to read the different columns into separate dataframes. I know the the column name/number where the data for each dataframe starts but not number of rows of…

---

## [How to write matrix data to Excel in separate worksheets?](https://discourse.julialang.org/t/how-to-write-matrix-data-to-excel-in-separate-worksheets/64557)

<div class="topic-metadata">

**Author:** [@adikaagas](https://discourse.julialang.org/u/adikaagas)\
**Replies:** 4\
**Last updated:** [July 17, 2021, 1:05am UTC](https://discourse.julialang.org/t/how-to-write-matrix-data-to-excel-in-separate-worksheets/64557 "2021-07-17T01:05:57Z")

</div>

I have matrix data type that stored in atom workspace called sheet1 = \[1 2 3; 4 5 6\] and sheet2 = \[1 1 1; 2 2 2\] how do i write this variable into excel workbook with a different worksheet? xlxs.addsheet! didnt work , …

---

## [How do I recreate excel's index match function in Julia?](https://discourse.julialang.org/t/how-do-i-recreate-excels-index-match-function-in-julia/63144)

<div class="topic-metadata">

**Author:** [@Mitch](https://discourse.julialang.org/u/Mitch)\
**Replies:** 2\
**Last updated:** [June 18, 2021, 3:00pm UTC](https://discourse.julialang.org/t/how-do-i-recreate-excels-index-match-function-in-julia/63144 "2021-06-18T15:00:31Z")

</div>

Hey, thanks for the help! I need to match the rows from column x in dataframe two, with the correct rows in data frame 1 to form a new column. The problem is visually described and solved in Python in the link below. I…

---

## [Model of accounts](https://discourse.julialang.org/t/model-of-accounts/62912)

<div class="topic-metadata">

**Author:** [@elgator](https://discourse.julialang.org/u/elgator)\
**Replies:** 1\
**Last updated:** [June 15, 2021, 7:54am UTC](https://discourse.julialang.org/t/model-of-accounts/62912 "2021-06-15T07:54:11Z")

</div>

Hi, I need a piece of architecture advice. I am trying to implement a DSL for financial modelling (3 statement financial model, not the asset-valuaion one). Conceptually the model is quite straitforward: given a number …

---

## [\[ANN\] ExcelUtilities.jl](https://discourse.julialang.org/t/ann-excelutilities-jl/55907)

<div class="topic-metadata">

**Author:** [@Alec\_Loudenback](https://discourse.julialang.org/u/Alec_Loudenback)\
**Replies:** 10\
**Last updated:** [May 7, 2021, 4:08pm UTC](https://discourse.julialang.org/t/ann-excelutilities-jl/55907 "2021-05-07T16:08:40Z")

</div>

In my line of work, I’m in and out of Excel a lot and wanted to be able to go back and forth between Excel and Julia. So ExcelUtilities.jl enables you to copy and paste to and from Excel: I spiked this out of it’s ori…

---

## [Writing a dataframe to Excel XLSX](https://discourse.julialang.org/t/writing-a-dataframe-to-excel-xlsx/59748)

<div class="topic-metadata">

**Author:** [@Smith](https://discourse.julialang.org/u/Smith)\
**Replies:** 5\
**Last updated:** [April 21, 2021, 9:32pm UTC](https://discourse.julialang.org/t/writing-a-dataframe-to-excel-xlsx/59748 "2021-04-21T21:32:35Z")

</div>

Can we write a dataframe (without headers) to a specified sheet and specified cell in Excel? I have a dataframe that I want to write to a specific sheet in a spreadsheet. Consider this dataframe df = DataFrame(Name=\["aa…

---

## [Setting number of threads and parsing arguments](https://discourse.julialang.org/t/setting-number-of-threads-and-parsing-arguments/57904)

<div class="topic-metadata">

**Author:** [@mjanun](https://discourse.julialang.org/u/mjanun)\
**Replies:** 6\
**Last updated:** [March 25, 2021, 6:36pm UTC](https://discourse.julialang.org/t/setting-number-of-threads-and-parsing-arguments/57904 "2021-03-25T18:36:34Z")

</div>

I understand that to launch Julia with multithreading from command prompt (on Windows), one has to pass the following command before launching Julia: set JULIA\_NUM\_THREADS=4 I am calling Julia from Excel/VBA using the S…

---

## [16000 cases lost in UK Covid reporting](https://discourse.julialang.org/t/16000-cases-lost-in-uk-covid-reporting/47783)

<div class="topic-metadata">

**Author:** [@johnh](https://discourse.julialang.org/u/johnh)\
**Replies:** 16\
**Last updated:** [October 15, 2020, 11:21am UTC](https://discourse.julialang.org/t/16000-cases-lost-in-uk-covid-reporting/47783 "2020-10-15T11:21:00Z")

</div>

This is being reported by the media as a failure with Excel. It seems more likely it is a problem with CSV Format files being used for data exchange. Should have been using Julia of course!