MATLAB: Importing data from excel sheet

MATLABmatrix array

I want to import all the data from excel worksheets.

I tried using following command, >> Ans = xlsread(FILEPATH);

After executing this line, the data only from first sheet is getting uploaded.

Is there any other way to upload entire data using single command?

Best Answer

sheet={'sheet1','sheet2'}, %specify your sheets
out=cellfun(@(x) xlsread('book1.xlsx',x),sheet,'uni',false)

if you want one line command (for 4 sheets)

out=cellfun(@(x) xlsread('book1.xlsx',x),cellfun(@(y) ...
sprintf('sheet%d',y),num2cell(1:4),'uni',false),'uni',false)

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