Forum Discussion

Emal amiri's avatar
Emal amiri
Copper Contributor
Aug 14, 2017

Powershell for reading data from excel survey

Hello Community,

I need help for a powershell script to read data of excel survey form, I am planning some automation and I love to see if its possible connect to a sharepoint excel survevy form and get those information then I can use it for AD purpose.

thanks 

powershell
SharePoint Online

3 Replies

  • jcgonzalezmartin's avatar
    jcgonzalezmartin
    MVP
    Aug 15, 2017
    Not sure if this is possible since I'm not aware of how you can get Excel Survey Data by means of an API you could use in PowerShell
    • Emal amiri's avatar
      Emal amiri
      Copper Contributor
      Aug 15, 2017
      Hi Juan,
      The Excel Survey data is going to an excel file at either onedrive or sharepoint not the only thing remain is to have a powershell script running on sharepoint module to get the data out of that excel file.
      • Rati Ranjan's avatar
        Rati Ranjan
        Copper Contributor
        Jan 30, 2020
        Check if Graph's Drive API workbook endpoint can be of use.
        https://docs.microsoft.com/en-us/graph/api/resources/excel?view=graph-rest-1.0

Resources