How can I read xlsx file in Matlab2014a ?
3 views (last 30 days)
Show older comments
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
Answers (1)
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?
0 Comments
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!