I need to close excel file before importing data

Question

Roohollah 2023-10-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2032309-i-need-to-close-excel-file-before-importing-data

评论： Roohollah 2023-10-13

I recently started using MATLAB R2023a.

When I use functions such as xlsread or readtable to read data from an excel file, the file must be closed before calling function.

Previously, when I was using MATLAB R2019 or older versions, this was not the case.

Can this issue be fixed?

3 个评论
显示 1更早的评论隐藏 1更早的评论

Jon 2023-10-12

编辑：Jon 2023-10-12

I am using R2023b on a Windows machine.

For me this behavior seems to depend upon the location of the Excel file. When I have the current MATLAB directory and the .xlsx file both in, for example, in C:\TEMP\Matlab then I can use readtable successfully whether the .xlsx file is open or not. When I put exactly the same .xlsx file in my One Drive folder, I can use readtable when the file is closed but if it is open then I get the error :

Error using readtable

Unable to open file 'C:\Users\jxxx.xxx\OneDrive - xxxx\myfile.xlsx'

as a workbook. Check that the file exists, read access is available, and the file is a

valid spreadsheet file.

When I look at the permissions for the file in the One Drive folder they seem to be the same as when it is in the C:\Temp\Matlab location, but somehow there must be some difference.

I would also like to know if there is a solution for this, as it can be annoying if I just want to read the file and I forget to close it. At the least, it would be nice if I could get it to throw an error that indicated that the problem was that the file was open, rather than the more obscure error that it now reports

Roohollah 2023-10-13