When use 'xlsread' , error 'Eror using Interface.​Microsoft_​excel_12.0​_Object_Li​brary._Wor​kSheet/set​' ,please help!

2 views (last 30 days)
The error as follows: Error using Interface.Microsoft_excel_12.0_Object_Library._WorkSheet/set
Invoke Error, Dispatch Exception:
Source:Microsoft Office Excel
Description:不能设置类Worksheet的Visible属性
Help File :C:\Program Files\microsoft office\office12\2052\Xlmain11.chm
Help Comtext ID:0
Error in xlsreadCOM>activate_sheet(line 88)
set(TargetSheet,'Visible','xlsheetvisible');
Error in xlsreadCOM(line 36)
actuvate_sheet(Excel,sheet);
There is Encrypting File System in my computer,I do not know whether it affects. Thank you !

Accepted Answer

Ken Atwell
Ken Atwell on 18 Jan 2013
Do the names of any of the sheets in the file you are trying to read contain any non-ASCII characters, such as Chinese characters? If so, try renaming those sheets to contain only 7-bit ASCII characters. This is an acknowledged limitation in MATLAB in today.
If that does not help, can you provide more information:
  1. The exact command you are typing in MATLAB.
  2. The specific version of Windows, MATLAB, and Office you are running.

More Answers (1)

Image Analyst
Image Analyst on 18 Jan 2013
Do you have Excel installed on your computer? I'd guess that you don't. Or you have only the Excel "Starter" edition.

Categories

Find more on Data Import from MATLAB 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!