Why do i get an error when using readtable saying cannot open file
106 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
T=readtable('Technology.xlsx')
Error using readtable (line 223)
Unable to open file 'Technology.xlsx' as a workbook. Check that the file exists, read access is available, and the file is a valid spreadsheet file.
I have made sure i have used the file name correctly and imported the data. But still cannot call for the data.
4 commentaires
Walter Roberson
le 29 Déc 2019
I have no problem reading the file with readtable() on Mac with R2019b.
If you have R2018b or later, try
T = readtable('Technology.xlsx', 'UseExcel', false);
Réponses (2)
Meindert Norg
le 7 Jan 2021
I received the same error while reading a .xlsx from a drive sync'd to OneDrive. I worked around it by first copying the file, and then reading the file with readtable, using this simple script. Hope that helps.
function data = CopyAndReadTable(FullFilename)
%COPYANDREADTABLE copies file and reads table.
%
% Copies a file to the 'tempdir' , then used readtable to
% read the contents. Afterwards the temp file is deleted.
%
% Meindert Norg, 2021.
[~,name,ext] = fileparts(FullFilename);
tempFullFilename = fullfile(tempdir,[name,ext]);
copyfile(FullFilename,tempFullFilename);
data = readtable(tempFullFilename);
delete(tempFullFilename);
end
0 commentaires
Hiro Yoshino
le 26 Déc 2019
TRY - readmatrix instead:
1 commentaire
Walter Roberson
le 26 Déc 2019
readmatrix() uses the same code as readtable() to open the xlsx file and read values from it. I would not expect it to work when readtable() does not work.
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!