How can I read xlsx file in Matlab2014a ?

3 次查看（过去 30 天）
Surajeet
Surajeet 2014-5-19
回答： Ken Atwell 2014-5-19
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 个）

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

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by