MATLAB: How do i read an excel file with differnt sheets in an easy way

importing excel dataxlsread

I need to structure up some execl files containing 4 diffrent sheets and i wondet how I in the most effective way does this.

Best Answer

xlsinfo can be used to find the name of the sheets or the number of sheets. After that you loop reading one sheet at a time.

Or if you already know the names of the sheets, just make four xlsread() calls passing in the appropriate sheet information.

Related Solutions

MATLAB: Xlswrite to create file with xlsx extension

xlswrite('file.xls',Your_data)

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;

Best Answer

Related Solutions

MATLAB: Xlswrite to create file with xlsx extension

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

Related Question