Hello, Has anyone had success in reading Excel files residing on a Sharepoint? Any pointer or suggestions would be appreciated.
Thanks,
Scott
Solved
Sharepoints and Excel files
Best answer by mohammadansari
One way I fixed this was by syncing the SharePoint file. This way, a copy of the file will be created in a folder in your PC/Laptop. Any changes by other users on the file will be reflected in the synced file as well. A lot like OneDrive/G-Drive/Dropbox/...
+5Hi
You will need the absolute or relative path of the file from your AIMMS project directory, and the file needs to be on disk.
One way I fixed this was by syncing the SharePoint file. This way, a copy of the file will be created in a folder in your PC/Laptop. Any changes by other users on the file will be reflected in the synced file as well. A lot like OneDrive/G-Drive/Dropbox/...
Sign up
Already have an account? Login
Please use your business or academic e-mail address to register
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.