MATLAB: How to read xlsx file after importing the file from UGI

xlsread

The first step of the code was:

[file,path,filter] = uigetfile({'*.xlsx'},'Select the Excel file');

Im looking for the second step, and i tried these but they didnt work:

[num]= xlsread(file);
num = xlsread(file,'','','basic');
[num,txt,raw]= xlsread (file);

please can anybody help?

Best Answer

[file,filepath,filter] = uigetfile({'*.xlsx'},'Select the Excel file');
filename = fullfile(filepath, file);
[num] = xlsread(filename);

Related Solutions

MATLAB: User input from an excel file

BaseDir = 'C:\Temp';  % Set as you need
[FileName, FilePath] = uigetfile('*.xlsx', ...
                  'Please choose an Excel file', BaseDir);
if isequal(filename, 0)
   disp('User aborted file choosing.');
   return;  % Assuming this is a function
end
File = fullfile(FilePath, FileName);
[Num, Txt, Raw] = xlsread(File);

Now it is not clear where the wanted values are found in the Excel file. I assume you find the values in a column of Num.

MATLAB: How to save tables to different sheets in one xlsx file

Have you done a step-by-step execution of your code to be sure that there are multiple files read?

Looking at it like that, I would just remore the square brakets to the sheet name:

writetable(R1,F_xlsx,'Sheet',files(i).name);

Personnally, I'm using writematrix() the same way on different tables without any problem.

Best Answer

Related Solutions

MATLAB: User input from an excel file

MATLAB: How to save tables to different sheets in one xlsx file

Related Question