MATLAB and Simulink resources for Arduino, LEGO, and Raspberry Pi
Learn moreOpportunities for recent engineering grads.
Apply TodayNew to MATLAB?
MATLAB Central > MATLAB Newsreader > Reading Excel xlsread cell with formula in them 

Subject: Reading Excel xlsread cell with formula in them From: Dez Date: 29 Mar, 2012 15:16:18 Message: 1 of 10 
Hi, 
Subject: Reading Excel xlsread cell with formula in them From: John Smith Date: 29 Mar, 2012 20:41:30 Message: 2 of 10 
"Dez" wrote in message <jl1uc2$de9$1@newscl01ah.mathworks.com>... 
Subject: Reading Excel xlsread cell with formula in them From: TideMan Date: 29 Mar, 2012 19:10:06 Message: 3 of 10 
On Friday, March 30, 2012 4:16:18 AM UTC+13, Dez wrote: 
Subject: Reading Excel xlsread cell with formula in them From: YUC hu Date: 16 Apr, 2012 03:29:08 Message: 4 of 10 
I have similar problem lately. Where the cell formula is Bloomberg's BDP function 
Subject: Reading Excel xlsread cell with formula in them From: Dez Date: 16 Apr, 2012 08:08:06 Message: 5 of 10 
"YUC hu" <k9999@56.com> wrote in message <jmg3m4$d9p$1@newscl01ah.mathworks.com>... 
Subject: Reading Excel xlsread cell with formula in them From: tolsthoorn@gmail.com Date: 17 Jun, 2013 07:24:34 Message: 6 of 10 
Whenever I read excel data info Matlab, and a cell contains a formula that yields a text value, I get a NaN in Matlab. This happens even if I change the format of the excel sheet cell to text. This way I can never read dynamic texts from Excel, which largely reduces the value of xlsread. 
Subject: Reading Excel xlsread cell with formula in them From: Steven_Lord Date: 17 Jun, 2013 14:37:58 Message: 7 of 10 

Subject: Reading Excel xlsread cell with formula in them From: Marc Date: 18 Jun, 2013 02:17:09 Message: 8 of 10 
"Steven_Lord" <slord@mathworks.com> wrote in message <kpn707$e2u$1@newscl01ah.mathworks.com>... 
Subject: Reading Excel xlsread cell with formula in them From: Marc Date: 18 Jun, 2013 02:28:16 Message: 9 of 10 
"Marc" wrote in message <kpofv5$qoj$1@newscl01ah.mathworks.com>... 
Subject: Reading Excel xlsread cell with formula in them From: Marc Date: 23 Jul, 2013 05:03:10 Message: 10 of 10 
"Marc" wrote in message <kpogk0$s1j$1@newscl01ah.mathworks.com>... 
A tag is like a keyword or category label associated with each thread. Tags make it easier for you to find threads of interest.
Anyone can tag a thread. Tags are public and visible to everyone.