# How can I read an excel named table in Julia?

**URL:** https://discourse.julialang.org/t/how-can-i-read-an-excel-named-table-in-julia/103984
**Category:** General Usage
**Tags:** excel
**Created:** [September 18, 2023, 1:46pm UTC](https://discourse.julialang.org/t/how-can-i-read-an-excel-named-table-in-julia/103984 "2023-09-18T13:46:54Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![Emmanouil\_Bakirtzis](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/emmanouil_bakirtzis/32/11456_2.png) [@Emmanouil\_Bakirtzis](https://discourse.julialang.org/u/Emmanouil_Bakirtzis)
#### Post date: [September 18, 2023, 1:46pm UTC](https://discourse.julialang.org/t/how-can-i-read-an-excel-named-table-in-julia/103984/1 "2023-09-18T13:46:54Z")

</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 excel packages but I can’t make it work.  
Thanks.

---

<div class="post-metadata">

### Author: ![lmiq](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/lmiq/32/18314_2.png) [@lmiq](https://discourse.julialang.org/u/lmiq)
#### Post date: [September 18, 2023, 4:08pm UTC](https://discourse.julialang.org/t/how-can-i-read-an-excel-named-table-in-julia/103984/2 "2023-09-18T16:08:53Z")

</div>

I guess this is the package that people use to read Excel files: [Home · XLSX.jl](https://felipenoris.github.io/XLSX.jl/stable/)

(I don´t know if you tried it and if it solves your specific problem)

---

<div class="post-metadata">

### Author: ![Emmanouil\_Bakirtzis](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/emmanouil_bakirtzis/32/11456_2.png) [@Emmanouil\_Bakirtzis](https://discourse.julialang.org/u/Emmanouil_Bakirtzis)
#### Post date: [September 19, 2023, 12:42pm UTC](https://discourse.julialang.org/t/how-can-i-read-an-excel-named-table-in-julia/103984/3 "2023-09-19T12:42:48Z")

</div>

Thanks for the suggestion, but I have tried it and I have not found the way to do it.

---

<div class="post-metadata">

### Author: ![nilshg](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/nilshg/32/2283_2.png) [@nilshg](https://discourse.julialang.org/u/nilshg)
#### Post date: [September 19, 2023, 1:01pm UTC](https://discourse.julialang.org/t/how-can-i-read-an-excel-named-table-in-julia/103984/4 "2023-09-19T13:01:20Z")

</div>

Could you explain what exactly you are trying to do, what the output is, and how it is different from what you are expecting? I’m not a massive Excel user but I thought a named table is just a regular table except you can refer to it by name in Excel formulas, but for just reading out the data into some other program (eg Julia) I don’t see how that makes it different from any other table?

---

<div class="post-metadata">

### Author: ![acxz](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/acxz/32/16759_2.png) [@acxz](https://discourse.julialang.org/u/acxz)
#### Post date: [March 31, 2024, 1:28am UTC](https://discourse.julialang.org/t/how-can-i-read-an-excel-named-table-in-julia/103984/5 "2024-03-31T01:28:55Z")

</div>

Here is my use case for being able to reading Excel tables rather than Excel sheets.

Often times I’ll use cells that are adjacent to the Excel table as comments or notes when I am working on the sheet. I’d like for these comments to not be available during an export. You can also have two tables in a single sheet.

As an Excel user, there is a difference to me about what a “table” is and what a “sheet” is, and ideally I’d like this api to be exposed in the corresponding Julia libraries that have Excel read/write functionality.

Here is functionality that a python package: [openpyxl](https://foss.heptapod.net/openpyxl/openpyxl) provides regarding Excel tables: [Worksheet Tables — openpyxl 3.1.2 documentation](https://openpyxl.readthedocs.io/en/stable/worksheet_tables.html)

---

<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 26, 2026, 4:55pm UTC](https://discourse.julialang.org/t/how-can-i-read-an-excel-named-table-in-julia/103984/6 "2026-08-26T16:55:15Z")

</div>

This functionality was added to XLSX.jl in v0.12.2.

---

<div class="post-metadata">

### Author: ![acxz](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/acxz/32/16759_2.png) [@acxz](https://discourse.julialang.org/u/acxz)
#### Post date: [August 30, 2026, 12:46am UTC](https://discourse.julialang.org/t/how-can-i-read-an-excel-named-table-in-julia/103984/7 "2026-08-30T00:46:17Z")

</div>

Woot Woot!!! Thanks!
