Why do i get an error when using readtable saying cannot open file
106 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentare
Walter Roberson
am 29 Dez. 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);
Antworten (2)
Meindert Norg
am 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 Kommentare
Hiro Yoshino
am 26 Dez. 2019
TRY - readmatrix instead:
1 Kommentar
Walter Roberson
am 26 Dez. 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.
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!