How do I read an excel file and plot graphs?
4 次查看(过去 30 天)
显示 更早的评论
fileName = 'test.xls';
a=xlsread(fileName);
These commands are not working for me. Can anyone help? I get an error that the file not found.
0 个评论
采纳的回答
Image Analyst
2016-8-26
'test.xls' is not in your current folder. Perhaps it's really called 'test.xlsx' or perhaps it's in a different folder. You can specify the folder it lives in and then use fullfile() to create the full file name.
folder = 'c:/whatever'
fullFileName = fullfile(folder, 'test.xls');
a = xlsread(fullFilename);
OR use the following to have the user manually locate it:
% Have user browse for a file, from a specified "starting folder."
% For convenience in browsing, set a starting folder from which to browse.
startingFolder = 'C:\Program Files\MATLAB';
if ~exist(startingFolder, 'dir')
% If that folder doesn't exist, just start in the current folder.
startingFolder = pwd;
end
% Get the name of the file that the user wants to use.
defaultFileName = fullfile(startingFolder, '*.xl*');
[baseFileName, folder] = uigetfile(defaultFileName, 'Select a file');
if baseFileName == 0
% User clicked the Cancel button.
return;
end
fullFileName = fullfile(folder, baseFileName)
a = xlsread(fullFilename);
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 File Operations 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!