How can I read xlsx file in Matlab2014a ?

2 views (last 30 days)
Surajeet
Surajeet on 19 May 2014
Answered: Ken Atwell on 19 May 2014
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.
  1 Comment
Ilham Hardy
Ilham Hardy on 19 May 2014
HOw do you read the xlsx file? Can you post the script here as well?

Sign in to comment.

Answers (1)

Ken Atwell
Ken Atwell on 19 May 2014
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?

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!