Not sure how to use XLSX

General Usage
1

trying to put an xlsx into a dataframe for 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.

2

You want XLSX.readtable, not XLSX.readdata.

3

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

4

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