MATLAB: How to read single sheet from multiple sheets of excel file

multiple sheetxlsread

I have imported an excel file with multiple sheets.

Using xlsinfo, i extract the sheet names in the excel file.

[~,sheetName]=xlsfinfo(file);

How can i choose the sheet to read after obtaining the sheetname?

I tried worksheet=xlsread(file,'Title');

but that would require me to input the title every single time.

Also, it only reads numeric, I would need to read characters as well.

Best Answer

num = xlsread(filename,sheet)

In the place of sheet, you specify the sheet number.

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: XLSread – multiple sheets

Hi, Pratha.

I'm not sure if it helps or not because I also have similar situation with you but my parameter can combine in one excel file.

TimeP1=xlsread('Book001.xlsx','PRN1','A:A');
PRNP1=xlsread('Book001.xlsx','PRN1','B:B');
S4P1=xlsread('Book001.xlsx','PRN1','C:C');
%_______________read PRN1_______________%
TimeP2=xlsread('Book001.xlsx','PRN2','A:A');
PRNP2=xlsread('Book001.xlsx','PRN2','B:B');
S4P2=xlsread('Book001.xlsx','PRN2','C:C');
%_______________read PRN2_______________%

In another word:

ParameterP1 = xlsread('your excel file with format','your tab name in that excel','column selected');

Best Answer

Related Solutions

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

MATLAB: XLSread – multiple sheets

Related Question