MATLAB: Reading from an Excel File using MATLAB

MATLABread data

Can I read .xlsx files using MATLAB?

Best Answer

Hi,

on windows 100% yes using xlsread. In Linux/MAC you need 12a and newer in order to be able to read in xlsx format with the xlsread command.

Cite from the 12a Release Notes:

"xlsread Reads XLSX Files on All PlatformsThe xlsread function now reads data from XLSX files on all platforms, including support for specifying the range and worksheet number. Previously, this functionality was available only on Microsoft Windows systems with Excel software."

Related Solutions

MATLAB: Excel reading – xlsread

Use the third output of xlsread:

[data, txt, raw] = xlsread(...);

The "raw" output is a cell array which contains all of 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: Excel reading – xlsread

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

Related Question