xlsread uses ''basic mode'' on windows with excel

2 次查看（过去 30 天）
Kokalz
Kokalz 2012-7-12
回答： Xiaolong Jin 2018-2-7
Hey guys! Everytime I do:
endnumData=xlsread('data.xlsx')
I get an error,that says:
Warning: Could not start Excel server for import, 'basic' mode will be used. Refer to HELP
XLSREAD for more information.
> In xlsread at 186
Going to line 186 in the editor and changing the string value
basicMode = true;
only gives more mistakes. Any way to fix this ,so that I don't have to use basic mode all the time.

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

回答（4 个）

Nirmal
Nirmal 2012-7-13
I think it is because you used xlsx file if you use xls you should be fine.
Kokalz
Kokalz 2012-7-16
I tried both .xlsx and .xls, the problem still persists. The issue seems to be with the COM server that Matlab uses for Excel. I am using 32-bit Excel and 64-bit Matlab on Windows XP 64-bit PC. The bit difference is probably not the reason as this is an exe COM server not the dll one. Could someone help me out please??? It's really important!!!
Simon Woodward
Simon Woodward 2014-9-23
I have the same problem. I have Matlab R2009b and Excel Professional 2010. My IT guy said it could be DLLs hanging around from old versions of Excel and confusing Office.
  1 个评论
Image Analyst
Image Analyst 2014-9-23
Tell your IT guy to uninstall any old versions of Excel. Also try to upgrade your 5 year old version of MATLAB if you can. I have MATLAB R2014a and Excel 2010 and it all works fine.

请先登录，再进行评论。

Xiaolong Jin
Xiaolong Jin 2018-2-7
I solved this problem by changing the properties of Excel. Right click on Excel--select properties--click the 'compatibility'Tab--tick the 'run this program in compatibility mode for'-- select 'windows 7' or other options. Hope it works!

类别

在 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