xlsread returns empty when reading a cell with a formula
Show older comments
using command below I get num as an empty array when the cell has a formula. how to get the value returned from Excel formula in the cell back into MATLAB: num = xlsread('h&vlookup_if_and_or_Capacity_Planning.xlsx','Sheet1','B26','basic')
Answers (1)
Azzi Abdelmalek
on 18 Mar 2016
[num,text,both] = xlsread('h&vlookup_if_and_or_Capacity_Planning.xlsx','Sheet1','B26','basic')
Categories
Find more on Whos in Help Center and File Exchange
on 18 Mar 2016
on 18 Mar 2016
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
