Why do i get an error when using readtable saying cannot open file
106 views (last 30 days)
Show older comments
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 Comments
Walter Roberson
on 29 Dec 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);
Answers (2)
Meindert Norg
on 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 Comments
Hiro Yoshino
on 26 Dec 2019
TRY - readmatrix instead:
1 Comment
Walter Roberson
on 26 Dec 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.
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!