Problems with xlsread function

I am using Matlab R2012a.

I do the following example from your documentation:

values = {1, 2, 3 ; 4, 5, 'x' ; 7, 8, 9}
headers = {'First', 'Second', 'Third'}
xlswrite('myExample.xlsx', [headers; values]);

This creates an excel file no problem which I can open in excel.

When I do:

A = xlsread('myExample.xlsx')

I get the following error messages:

Error: Object returned error code: 0x800AC472

Error in xlsreadCOM (line 2)
    Excel.DisplayAlerts = 0;

Error in xlsread (line 230)
        [numericData, textData, rawData, customOutput] = xlsreadCOM(file, sheet,
        range, Excel, customFun);

What is going on?

Answer 1

[Jonathan Sullivan]

I can't seem to recreate the problem. Try clearing and closing everything:

values = {1, 2, 3 ; 4, 5, 'x' ; 7, 8, 9}
headers = {'First', 'Second', 'Third'}
xlswrite('myExample.xlsx', [headers; values]);

clear all; close all
xlsread('myExample.xlsx')

[Ed]

clearing and closing did not make any difference.

[Image Analyst]

Is your version of Excel modern enough to read .xlsx files? Sounds like it. What version is it? What happens if you ask for all 3 outputs that xlsread can return?