So there is a way to manually import a excel sheet into a SP list, but is there a way of doing this automatically.
So - Excel documents are stored in document library, then nintex workflow is run to pull the data in to the relevant columns on a existing list.
I have managed to use query excel services to pull one column correctly A2:A5, but as soon as I try and capture the next column A2:B5 all the results (variables) from column 1 and 2 end up in the first column.
Any ideas? Vadim Tabakman any ideas?
FYI- I want a way where scripts are not used.
When trying some WF-I received :The error: