Home › Forums › Discussion Forum › Project Online (PWA) – Writing data back to OData
Tagged: OData, Project Online, PWA
Hello,
I have been asked to update Project Online (PWA) using Excel spreadsheets. Not knowing if this is possible, has caused a large amount of effort for me to manually update the environment.
Is there a way to update existing project data, that resides in the cloud, from an Excel spreadsheet?
Thank you.
Hey Norman. Not to be cruel but you’re supposed to go the other way around. Sorry I know, I’ve been there before…! Unfortunately you can’t without a lot of development.
There is quite a few articles out there on how to update using Powershell. So read your file in through powershell and then update PWA using CSOM. Here are some links.