Why does "readtable" fail to read a file from OneDrive?

19 次查看（过去 30 天）
MathWorks Support Team
回答： MathWorks Support Team 2020-3-31

I am using OneDrive for storing my Microsoft Excel spreadsheets. I noticed one issue when trying to read data from it:

  • When my spreadsheet is not open by any application, then MATLAB successfully loads the data from the spreadsheet.
  • When my spreadsheet is open in Microsoft Excel, then MATLAB fails to read data from it using "readtable". The error message is below.
>> readtable('mydata.xlsx', 'UseExcel', true)

Unable to open file 'C:\Users\<user>\OneDrive ....' as a workbook. Check that the file exists, read access is available, and the file is a valid spreadsheet file.

请先登录，再回答此问题。

采纳的回答

MathWorks Support Team
The issue is likely to be with OneDrive locking the file for editing purposes, although our development team is aware of the issue and investigating.
For now, the workaround is to close the application which uses the file in OneDrive, and then use MATLAB to load the file. Alternatively, the file can be moved or copied to a local directory, ensuring OneDrive does not lock it.

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2018b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by