Read Excel file stored in One Drive Using Console Application.Is it Possible or not if possible then how? RRS feed

  • Question

  • Read Excel file stored in One Drive Using Console application. Is It Possible or not If possible then how?

    I want to read Excel file and Get Excel sheet Data  in JSON Format.

    Friday, November 16, 2018 8:00 AM

All replies

  • It depends. If the file is residing on the user's One Drive account and One Drive is turned on in Windows such that the user can see it from Windows Explorer then it is just a file path. If you go to Windows Explorer and find the Excel file of interest and double click the address bar you'll get the file path to it. You can use that in .NET anywhere a file path is normally allowed including connection strings and the File API.

    If One Drive is not wired up to Windows then you'd need to use the One Drive API (or REST) to download the file. Then open it normally from a temp location.

    Michael Taylor http://www.michaeltaylorp3.net

    Friday, November 16, 2018 3:01 PM