readtable can read Excel XLS but not XLSX on OneDrive?
Hello!
Unable to open file ‘C:UsersjuansOneDriveJuanMatlabBook5.xlsx’ as a workbook. Check that the file exists, read access is available, and the file is a valid spreadsheet file.
A while ago, it was identified that there was an issue with OneDrive blocking Excel files, and you have to close the file on Excel in order for MATLAB to open it, which is very inconvenient for the workflow. Another workaround I found is to use XLS, which is also not always a good solution. I could not find whether this issue has been solved.
What is the current status of this issue? (I have 2023a)
Cheers!Hello!
Unable to open file ‘C:UsersjuansOneDriveJuanMatlabBook5.xlsx’ as a workbook. Check that the file exists, read access is available, and the file is a valid spreadsheet file.
A while ago, it was identified that there was an issue with OneDrive blocking Excel files, and you have to close the file on Excel in order for MATLAB to open it, which is very inconvenient for the workflow. Another workaround I found is to use XLS, which is also not always a good solution. I could not find whether this issue has been solved.
What is the current status of this issue? (I have 2023a)
Cheers! Hello!
Unable to open file ‘C:UsersjuansOneDriveJuanMatlabBook5.xlsx’ as a workbook. Check that the file exists, read access is available, and the file is a valid spreadsheet file.
A while ago, it was identified that there was an issue with OneDrive blocking Excel files, and you have to close the file on Excel in order for MATLAB to open it, which is very inconvenient for the workflow. Another workaround I found is to use XLS, which is also not always a good solution. I could not find whether this issue has been solved.
What is the current status of this issue? (I have 2023a)
Cheers! onedrive, excel, readtable MATLAB Answers — New Questions