xlsread returns empty when reading a cell with a formula
古いコメントを表示
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')
回答 (1 件)
Azzi Abdelmalek
2016 年 3 月 18 日
[num,text,both] = xlsread('h&vlookup_if_and_or_Capacity_Planning.xlsx','Sheet1','B26','basic')
カテゴリ
ヘルプ センター および File Exchange で Whos についてさらに検索
2016 年 3 月 18 日
2016 年 3 月 18 日
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
