Access Excel-File stored in Microsoft OneDrive

Hello all,

I have an Excel-File which is stored in Microsoft OneDrive, but no locally. I have the web-link which leads to the Excel-File. How can I access and store the data in my Matlab Workspace?

xlsread is not working and also websave does not do what I want.

Which code or function may help me to achieve this?

I am using matlab R2023b.

Thank you very much for your help.

Kind regards,

Sebastian

[Dyuman Joshi]

Try readtable or readmatrix, specify the full url as the filename.

[Sebastian Stumpf]

Hi, thanks for the advise. I tried and there is no error. But the ouput is not very useful. Please have a look at the attached file. This is what I get from readtable. Readmatrix only produces NaN values.

Kind regards

load OneDriveExcelReadTable.mat
whos

  Name         Size            Bytes  Class    Attributes

  ans         88x4             68931  table              
  cmdout       1x33               66  char               

ans

ans = 88×4 table
                    margin_0                                                                  Var2                                                     Var3          Var4   
    _________________________________________    _______________________________________________________________________________________________    __________    __________

    {'}'                                    }    {0×0 char                                                                                     }    {0×0 char}    {0×0 char}
    {'#sdx_ow_iframe'                       }    {0×0 char                                                                                     }    {0×0 char}    {0×0 char}
    {'{'                                    }    {0×0 char                                                                                     }    {0×0 char}    {0×0 char}
    {'position:absolute'                    }    {0×0 char                                                                                     }    {0×0 char}    {0×0 char}
    {'width:100%'                           }    {0×0 char                                                                                     }    {0×0 char}    {0×0 char}
    {'height:100%'                          }    {0×0 char                                                                                     }    {0×0 char}    {0×0 char}
    {'background:#fff'                      }    {0×0 char                                                                                     }    {0×0 char}    {0×0 char}
    {'}'                                    }    {0×0 char                                                                                     }    {0×0 char}    {0×0 char}
    {'.sdx_mp_top_pad'                      }    {0×0 char                                                                                     }    {0×0 char}    {0×0 char}
    {'{'                                    }    {0×0 char                                                                                     }    {0×0 char}    {0×0 char}
    {'margin:0!important'                   }    {0×0 char                                                                                     }    {0×0 char}    {0×0 char}
    {'}'                                    }    {0×0 char                                                                                     }    {0×0 char}    {0×0 char}
    {'</style>'                             }    {0×0 char                                                                                     }    {0×0 char}    {0×0 char}
    {'<link rel="icon" href="https&#58'     }    {'//c1-excel-15.cdn.office.net/x/_layouts/resources/FavIcon_Excel.ico" type="image/x-icon" />'}    {0×0 char}    {0×0 char}
    {'<link rel="mask-icon" href="https&#58'}    {'//p.sfx.ms/images/mask_icon.svg" color="#0078D4">'                                          }    {0×0 char}    {0×0 char}
    {'</head>'                              }    {0×0 char                                                                                     }    {0×0 char}    {0×0 char}

cmdout

cmdout = 
    '2b292f7c2184b62a1fdb1177ca9a1882
     '

[Dyuman Joshi]

Could you share the file or the link to it?

Also, please share what the expected output is.

[Sebastian Stumpf]

Hello,

sorry for the late response. I was on vacation. Please find the link here: LiftCalc License.xlsx

I expect a Matlab Table to look like this:

Thank you for the support.

Kind regards,

Sebastian

Answer 1

[Walter Roberson]

You need to first use websave() or urlread() to read the contents of the file into local memory.

[Sebastian Stumpf]

Hello,

thanks for the advise. I tried this code:

url = 'https://1drv.ms/x/c/5cfb564fd848e4ae/EckeTGIRX3JMoMfCMYCRDhkBeT-S1ZJb1EII4SVXXtzWnw?e=fCcAHE';
urlread(url)

But the output is not very heplful (See attached file).

What did I do wrong?

Thank you and kind regards,

Sebastian

[Walter Roberson]

That link is to a URL that is a bunch of javascript, in which the function of the javascript does the bulk of the work. It would be difficult to analyze it.

[Sebastian Stumpf]

Ok, I understand. This is bad news. Do you have any other idea how to create an Excel-File or similiar table and store it online but in a way that Matlab can access the information stored in this online-table? Reading is enough. No need to write something from Matlab to the table. Thanks

[Sebastian Stumpf]

I figuered out, that it's working with DropBox. If you have a public link and change the last value db=0 to db=1, you can access the files directly.