Forum Discussion

Mcinwwl's avatar
Mcinwwl
New Contributor
4 years ago

Data Connecion to Excel online file

Hi, is there a way to use Excel online file as a data source? No way to do this via Excel wizard, as it requires links to mounted drives and will not accept any URI.

  • nmrao's avatar
    nmrao
    4 years ago
    Yes, one can upload the file using HTTP Request.

    If the directory is shared in the remote service, it should be possible to upload.
  • nmrao's avatar
    nmrao
    Champion Level 3
    Is the online file is updated frequently? Is that why you want the online file?

    There is no out-of-the-box functionality to have that directly in data source.

    However, one can use HTTP Request test step, so that the latest file is downloaded and use that in data source step.
    • Mcinwwl's avatar
      Mcinwwl
      New Contributor

      Ok, seems legit, but as a follow-up, how can one later update results to another excel online file? Simply uploading another file is doable, but will create extra link and extra file in O365 which is what will fit my needs.

      • nmrao's avatar
        nmrao
        Champion Level 3
        Yes, one can upload the file using HTTP Request.

        If the directory is shared in the remote service, it should be possible to upload.