Unable to read the data in excel file from MATLAB online.

Question

Swathi 2024-6-13

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2128121-unable-to-read-the-data-in-excel-file-from-matlab-online

评论： Cris LaPierre 2024-6-18

CODE:
filename = '/MATLAB Drive/SvsT.xlsx'; 
data = readtable(filename);
ERROR:
Error using readtable (line 517)
Unable to find or open '/MATLAB Drive/SvsT.xlsx'. Check the path and filename or file permissions.
Error in SvsT1234 (line 8)
data = readtable(filename);

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

Cris LaPierre 2024-6-18

How did you upload the data to MATLAB Drive? Did you use MATLAB Drive Connector or did you drag and drop the file into your MATLAB Online current folder?

Try syncing your file using MATLAB Drive Connector or upload it directly into MATLAB Drive here:

https://drive.mathworks.com/

请先登录，再进行评论。

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

Answer 1

Shivani 2024-6-13

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2128121-unable-to-read-the-data-in-excel-file-from-matlab-online#answer_1471261

编辑：Shivani 2024-6-13

在 MATLAB Online 中打开

Hello @Swathi,

From what I understand, you may be encountering this error because you are trying to access a file from the MATLAB Drive directly through the path. You will need to use the 'matlabdrive' function to programatically open the file. You can refer to the MATLAB documentation for more details: https://www.mathworks.com/help/matlab/ref/matlabdrive.html

The code to open the file will look something like the following code snippet

filename = fullfile(matlabdrive,'SvsT.xlsx');
data = readtable(filename);

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

Swathi 2024-6-13

still unable to read using the above code

请先登录，再进行评论。

Answer 2

Ganesh 2024-6-13

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2128121-unable-to-read-the-data-in-excel-file-from-matlab-online#answer_1471291

Hi @Swathi,

If the "matlabdrive" path indeed points to "/MATLAB Drive/", it's possible that the issue with your file lies with permission. It is possible that it is saved as a "Read-Only" file.

Would suggest you to remove all file protections and then re-upload the file to "MATLAB Drive". In case the file is too large, ensure that the file is completely uploaded before you try to access it.

If you have MATLAB Access offline, then try to read the file locally to ensure the issue does not exist with the file.

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

Ganesh 2024-6-13

Hi @Swathi,

I tried uploading a large file through MATLAB Drive, and then accessing it in MATLAB Online, and alas, I am unable to do it. In fact, I am unable to see the file on the "Files" panel either. Instead, I tried to upload it by right-clicking on the "Files" panel and then uploading the file.

This seems to have worked.

The same does not happen with smaller ".xlsx" files.

Swathi 2024-6-13