MATLAB: How to read the LAST sheet in excel

MATLABreading excel

Hi MATLAB experts,

I'd like to read the last sheet in excel spreadsheet. Although the sheet has a name, no matter what, I want to read the last sheet in the file.

Would you mind if I ask you to share your thoughts on this?

Thanks for your help. Jake

inputfolder = 'C:\Matlab\';
holdingfilename = [inputfolder,'prices.xls'];
sheet = 'random';
[numdata, txtdata] = xlsread(holdingfilename, sheet);

Best Answer

To get the name of the last sheet use xlsfinfo

[~,name]=xlsfinfo('file.xlsx') 
last_sheet=name{end}
N=xlsread('file.xlsx',last_sheet)

Related Solutions

MATLAB: How to rename a sheet in Excel using the COM interface in MATLAB

You can rename an Excel sheet using the "Name" property of a sheet object. For example the following renames the first sheet of an Excel file:

filename = 'C:\SomeExcelFile.xls';
% Open Excel Automation server
Excel = actxserver('Excel.Application');
% Make Excel visible
Excel.Visible=1;
% Open Excel file
Workbook = Excel.Workbooks.Open(filename);
% Get the list of sheets in the workbook
Sheets = Excel.ActiveWorkbook.Sheets;
% Rename the first sheet
Sheets.Item(1).Name = 'This is sheet 1';

The following code then saves the Workbook, quits Excel and removes the COM server:

% Save the file
Workbook.Save();
% Quit Excel, remove the COM server and delete the related objects
Excel.Quit();
Excel.delete();
clear Excel;
clear Workbook;
clear Sheets;

MATLAB: How to skip Excel files in a loop when special characters exist as sheet names

This doesn't solve the question but provides another solution to the need. Find length of the file and instead of trying to read the sheet name, we can read the sheet position by inputting the length into the sheet section of xlsread.

MS_xlsx=dir('*.xlsx');  % list of the files
for i=1:length(MS_xlsx)
    [~,file]=xlsfinfo(MS_xlsx(i).name);
    L=length(file);
    [~,txt]=xlsread(MS_xlsx(i).name,L,'B2');   % read the text
  if strcmp(txt,'Number:')
    delete(MX_xlsx(i).name)
  end
end

Best Answer

Related Solutions

MATLAB: How to rename a sheet in Excel using the COM interface in MATLAB

MATLAB: How to skip Excel files in a loop when special characters exist as sheet names

Related Question