MATLAB: Xlsread not reading data.

xlsread

I have an excel sheet that consists of two columns: the first contains time data and the second binary information (1,00 or 0,00).

When I type:

xlsread('....xlsx','','','basic')

only the time data is imported. When I type:

xlsread('....xlsx')

nothing is read in.

I am running R2016a

Suggestions?

Best Answer

Ask xlsread for three outputs:

[d,s,r] = xlsread('... .xlsx');

It should read everything, and you should see everything in the ‘r’ variable.

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

You could use xlsfinfo() to get the sheet names and then you'll get the last sheet name.

[A, DESCR, FORMAT] = XLSFINFO('FILENAME')

Normally, 'DESCR' will return all the sheet names in a cell array.

Best Answer

Related Solutions

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

MATLAB: Xlsread

Related Question