Access Excel-File stored in Microsoft OneDrive

Question

Sebastian Stumpf 2024-2-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2080316-access-excel-file-stored-in-microsoft-onedrive

评论： Sebastian Stumpf 2024-4-12

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

4 个评论
显示 2更早的评论隐藏 2更早的评论

Sebastian Stumpf 2024-2-9

编辑：Cris LaPierre 2024-2-9

在 MATLAB Online 中打开

OneDriveExcelReadTable.mat

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 2024-2-9

Could you share the file or the link to it?

Also, please share what the expected output is.

Sebastian Stumpf 2024-2-27

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 2024-2-9

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2080316-access-excel-file-stored-in-microsoft-onedrive#answer_1405896

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

4 个评论
显示 2更早的评论隐藏 2更早的评论

Sebastian Stumpf 2024-2-28

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 2024-4-12