xlsread - Undefined function 'dec2base27

2 次查看（过去 30 天）
Andre Labuschagne
Andre Labuschagne 2016-10-12
评论： Walter Roberson 2017-2-2
Hi I am running R2013a on Windows 7 Prof. I have been successfully using xlsread in a script to read .xlsx spreadsheets (Excel 2010) - worked 100%. Last night I accidentally opened another instance of Matlab, my pc slowed down dramatically, but the script was still executing. I then closed both instances of Matlab and opened only one instance. Since then I have been getting this error: Undefined function 'dec2base27' for input arguments of type 'double'. Searches via Google show quite a few similar problems. I have tried the following (without success): (I used the function as follows: [~,~,RAW]=xlsread(FILE,SHEET,RANGE)) a] Have relevant spreadsheet open/closed will running the script. b] Removing the 'Range' argument. c] Added the 'basic' argument. d] Changing spreadsheet to Excel 97 format. e] Disabling Excel add-ins: - Send to Bluetooth" (btsendto_office.dll) - I do not have this add-in: ADTAPLib.ApproveItAddin
Please advise Thanks Andre
  3 个评论
显示 1更早的评论
MEBARA TANGA Serge
MEBARA TANGA Serge 2016-11-13
编辑：MEBARA TANGA Serge 2016-11-13
Hi @ Jan Simon,
i have the same problem. I think it is like you can see in this pic. For me, when i use xlsread on other laptop it doesnt work. But in mine it works well. I developed my app with my laptop.
PS:Sorry for my English, i am French. My matlab version :8.2.0.701 (R2013b)
thanks
Jan
Jan 2016-11-13
@MEBARA TANGA Serge: Please post the message as text, not as screen shot. It is much easier to ask an internet search engine for details, when I can use copy&paste, instead of typing the text by my own.

请先登录，再进行评论。

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

回答（3 个）

Walter Roberson
Walter Roberson 2016-11-13
In R2013b, dec2base27 was a function inside of xlswrite.m and xlsread.m did not use dec2base27 at all.
You should be checking for the possibility that you are using an old version of xlsread.m . In R2013b, line 105 of xlsread.m should say
% $Revision: 1.23.4.43 $ $Date: 2012/12/10 23:52:43 $
Pritesh Shah
Pritesh Shah 2016-10-12
Dear Andre,
Restart the laptop. It may work.. :))
  1 个评论
MEBARA TANGA Serge
MEBARA TANGA Serge 2016-11-13
Hi, I have the same problem. I have already restart the laptop but it doesnt work.
Can you help me?

请先登录，再进行评论。

Jen
Jen 2017-1-31
Hi, I have the same problem. The error message is:
Error using xlsread (line 248)
Undefined function 'dec2base27' for input arguments of type 'double'.
Line 105 of xlsread.m says exactly:
% $Revision: 1.23.4.43 $ $Date: 2012/12/10 23:52:43 $
Thank you for your answer!
  6 个评论
显示 4更早的评论
Jen
Jen 2017-2-2
Yes, it seems that I have a newer version of xlsreadCOM :
% Copyright 1984-2015 The MathWorks, Inc.
Walter Roberson
Walter Roberson 2017-2-2
A 2015 copyright certainly should not have been present in R2013b. You might need to reinstall MATLAB to get the correct version.
Had you installed a Mathworks patch at some point?

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Introduction to Installation and Licensing 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by