清空筛选条件
清空筛选条件

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

3 次查看（过去 30 天）
Lisa Wu
Lisa Wu 2013-1-18
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 !

请先登录，再回答此问题。

采纳的回答

Ken Atwell
Ken Atwell 2013-1-18
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.

更多回答（1 个）

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

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by