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?