How can I read xlsx file in Matlab2014a ?

When I am reading a xlsx file having some hidden sheet following error comes up:

Unreadable Excel file: Invoke Error, Dispatch Exception: Source: Microsoft Office Excel Description: Open method of Workbooks class failed Help File: C:\Program Files (x86)\Microsoft Office\Office12\1033\XLMAIN11.CHM Help Context ID: 0

What exactly this error is? I tried converting it into xls format and unhiding the hidden sheets mentioned but same error comes. Also there are multiple sheets in this file and I dont want to convert it into single csv files or so.

[Ilham Hardy]

HOw do you read the xlsx file? Can you post the script here as well?

Answer 1

[Ken Atwell]

That error looks to be coming from Excel itself. Try xlsread with the 'basic' switch as described at http://www.mathworks.com/help/matlab/ref/xlsread.html -- this methods reads the file without using Excel to do so.

It is possible to upload the problematic file so others can take a look?