I am having the hardest time using data from an existing Excel spreadsheet in a stored process created in Enterprise Guide. I don't understand how to create a stored process which imports my current Excel data and uses that in the process to get new output. Any help would be appreciated!
Since your stored process executes on either the Stored Process server or the Workspace server, these servers do not generally have visibility of or access to files on your local computer's C: drive.
I'm having a similar issue. I'd like to be able to execute a stored process from an Excel spreadsheet and have the stored process pick up the data in the spreadsheet as the starting point to the process.
It sounds like that's not possible because the stored process server won't recognize the location of the data? So the user will have to store the data out on a drive and then run the stored process and direct it to the location of the data?