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.

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

MathWorks Support Team

2020 2 月 7

1 回答

回答採用済み

10 ビュー (30 日間)

1 投票

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.

サインインしてこの質問に回答する。

Follow Question

採用された回答

MathWorks Support Team 2020 年 2 月 7 日

1 投票

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.