# Why XLSX.readxlsx not working?

**URL:** <https://discourse.julialang.org/t/why-xlsx-readxlsx-not-working/84052>\
**Category:** General Usage\
**Tags:** question, dataframes, excel\
**Created:** [July 11, 2022, 2:53pm UTC](https://discourse.julialang.org/t/why-xlsx-readxlsx-not-working/84052 "2022-07-11T14:53:24Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Optimization](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/optimization/32/32462_2.png) [@Optimization](https://discourse.julialang.org/u/Optimization)\
**Post date:** [July 11, 2022, 2:53pm UTC](https://discourse.julialang.org/t/why-xlsx-readxlsx-not-working/84052/1 "2022-07-11T14:53:24Z")

</div>

I’m trying to read a first column of an excel file (from sheet2 column d2). This is my try:

```julia
using XLSX, , DataFrames

xf = XLSX.readxlsx("C:/Data/sample.xlsx")
sh = xf["sheet2"]
sh["d2"] ; sh[3]; # or any other similar things are not working 

```

Does anyone know how to read a whole column form specific sheet in an excel file?

 ![image](https://global.discourse-cdn.com/julialang/original/3X/0/e/0ea7d17195cfa354e0925c9befae402d1102a3ce.png)

---

<div class="post-metadata">

**Author:** ![Paul\_Soderlind](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/paul_soderlind/32/1753_2.png) [@Paul\_Soderlind](https://discourse.julialang.org/u/Paul_Soderlind)\
**Post date:** [July 11, 2022, 3:04pm UTC](https://discourse.julialang.org/t/why-xlsx-readxlsx-not-working/84052/2 "2022-07-11T15:04:26Z")

</div>

`xf["Sheet2"][:]` maybe? (Notice that your sheet name seems to start with an upper case S)

---

<div class="post-metadata">

**Author:** ![Optimization](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/optimization/32/32462_2.png) [@Optimization](https://discourse.julialang.org/u/Optimization)\
**Post date:** [July 11, 2022, 3:16pm UTC](https://discourse.julialang.org/t/why-xlsx-readxlsx-not-working/84052/3 "2022-07-11T15:16:15Z")

</div>

> [@Paul\_Soderlind](#):
>
> xf[“Sheet2”][:]

Hi @Paul_Soderlind`xf["Sheet2"][:]` shows all the stuff in sheet2. I’d like to assian a parameter all coulmn2 of sheet2

---

<div class="post-metadata">

**Author:** ![Paul\_Soderlind](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/paul_soderlind/32/1753_2.png) [@Paul\_Soderlind](https://discourse.julialang.org/u/Paul_Soderlind)\
**Post date:** [July 11, 2022, 3:21pm UTC](https://discourse.julialang.org/t/why-xlsx-readxlsx-not-working/84052/4 "2022-07-11T15:21:11Z")

</div>

Two ways (at least) to get element 1 of column 2

1. `xf[“Sheet2”][:][1,2]`
2. `xf[“Sheet2!B1”]`

---

<div class="post-metadata">

**Author:** ![Optimization](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/optimization/32/32462_2.png) [@Optimization](https://discourse.julialang.org/u/Optimization)\
**Post date:** [July 11, 2022, 3:35pm UTC](https://discourse.julialang.org/t/why-xlsx-readxlsx-not-working/84052/5 "2022-07-11T15:35:39Z")

</div>

> [@Paul\_Soderlind](#):
>
> xf[“Sheet2”][:][1,2]

1. `xf[“Sheet2”][:][:,2]` is working. Thanks for the help!