# Not sure how to use XLSX

**URL:** https://discourse.julialang.org/t/not-sure-how-to-use-xlsx/36410
**Category:** General Usage
**Created:** [March 23, 2020, 11:41pm UTC](https://discourse.julialang.org/t/not-sure-how-to-use-xlsx/36410 "2020-03-23T23:41:38Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![brett\_knoss](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/brett_knoss/32/13050_2.png) [@brett\_knoss](https://discourse.julialang.org/u/brett_knoss)
#### Post date: [March 23, 2020, 11:41pm UTC](https://discourse.julialang.org/t/not-sure-how-to-use-xlsx/36410/1 "2020-03-23T23:41:38Z")

</div>

trying to put an xlsx into a dataframe for Julia

```julia
using DataFrames
using XLSX
df = DataFrame(XLSX.readdata("C:/Users/Brett/Documents/FemaleLabourData.xlsx",Sheet1")...)

```

I get an error that my sheet is not recognized, although this is a part of my workbook.

---

<div class="post-metadata">

### Author: ![pdeffebach](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/pdeffebach/32/10320_2.png) [@pdeffebach](https://discourse.julialang.org/u/pdeffebach)
#### Post date: [March 23, 2020, 11:57pm UTC](https://discourse.julialang.org/t/not-sure-how-to-use-xlsx/36410/2 "2020-03-23T23:57:32Z")

</div>

You want `XLSX.readtable`, not `XLSX.readdata`.

---

<div class="post-metadata">

### Author: ![kevbonham](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/kevbonham/32/216165_2.png) [@kevbonham](https://discourse.julialang.org/u/kevbonham)
#### Post date: [March 24, 2020, 1:15am UTC](https://discourse.julialang.org/t/not-sure-how-to-use-xlsx/36410/3 "2020-03-24T01:15:14Z")

</div>

Also, not sure if it was a typo putting it into discourse, but you appear to be missing a quote before `Sheet1`.

---

<div class="post-metadata">

### Author: ![brett\_knoss](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/brett_knoss/32/13050_2.png) [@brett\_knoss](https://discourse.julialang.org/u/brett_knoss)
#### Post date: [March 24, 2020, 1:30am UTC](https://discourse.julialang.org/t/not-sure-how-to-use-xlsx/36410/4 "2020-03-24T01:30:14Z")

</div>

Yes, but I know how to deal with that error. 😊