No node name error with XLSX

Hi,

I’m trying to write some code to import spreadsheets into julia, stack them together in an array, manipulate them a bit and save them into a csv.

I’m however having problems in importing programmatically the excel files as I get a ‘no node name’ error.

Location = pwd() 
Directory = readdir(Location)

for ii in eachindex(Directory)
    excel = XLSX.readxlsx(Directory[ii])
end 

But I found that the following sort of works:

myexl=XLSX.openxlsx(Directory[1], enable_cache=false)

but then I don’t know how to make myexl into an array. So my question is why the no node error usinf readxlsx and other derivative xlsx functions?

What I can do better to achieve my task?

not sure where the error comes from but you can get the data by calling

myex.workbook.sheets[1][:]

Or if you want to use a DataFrame then

myexcel = DataFrame(XLSX.readtable(filename, sheet, Column))