MATLAB: Importing data from excel

excelr2007b

Greetings,

I have been following instructions while trying to import text data in the form of hex values into matlab. I have one column of data 192 rows deep and I have been using

alpha12_data = importdata('alpha12_data.xlsx')
alpha12_data = 
      'PK'
alpha12_data = xlsread('alpha12_data.xlsx', 'A1:A192')
alpha12_data =
       []

neither of these two commands work. Can anyone help me by explaining why? The file alpha12_data is in current directory

Thanks

Best Answer

It seems that R2007b wasn't still able to import .xlsx files.

I found the first reference to this type only from R2009a!

http://www.mathworks.co.uk/help/releases/R2009a/techdoc/index.html?/help/releases/R2009a/techdoc/ref/xlsread.html

The workaround

Save it as .xls with excel.

Related Solutions

MATLAB: How to open an existing Excel file and communicate with it using ActiveX

This bug has been fixed in Release 14 Service Pack 3 (R14SP3). For previous product releases, read below for any possible workarounds:

The following provides an example of opening an existing Excel file named example.xls and proceeding to write and read with it:

% Specify file name
file = 'D:\Applications\MATLAB701\work\example.xls'; % This must be full path name
% Open Excel Automation server
Excel = actxserver('Excel.Application');
Workbooks = Excel.Workbooks;
% Make Excel visible
Excel.Visible=1;
% Open Excel file
Workbook=Workbooks.Open(file);
% Specify sheet number, data, and range to write to 
sheetnum=1;
data=rand(4);  % use a cell array if you want both numeric and text data
range = 'F10:I13';
% Make the first sheet active
Sheets = Excel.ActiveWorkBook.Sheets;
sheet1 = get(Sheets, 'Item', sheetnum);
invoke(sheet1, 'Activate');
Activesheet = Excel.Activesheet;
% Put MATLAB data into Excel
ActivesheetRange = get(Activesheet,'Range',range);
set(ActivesheetRange, 'Value', data);
% Here you might manipulate the data in Excel
% Now read the data from the sheet; you could specify a new range here
Range = get(Activesheet,'Range',range);
out = Range.value;
% Save file
invoke(Workbook,'Save')
% Close Excel and clean up
invoke(Excel,'Quit');
delete(Excel);
clear Excel;

MATLAB: Can matlab R2009a hold an input value greater than 65336 values

This magic number has been a limitation of old Excel versions, but not of Matlab. Are you using a pre-Office2007 version of Excel to import an XLS file written with a modern Excel version?

Best Answer

Related Solutions

MATLAB: How to open an existing Excel file and communicate with it using ActiveX

MATLAB: Can matlab R2009a hold an input value greater than 65336 values

Related Question