xlsread returns empty when reading a cell with a formula
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
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')
0 Commenti
Risposte (1)
Azzi Abdelmalek
il 18 Mar 2016
[num,text,both] = xlsread('h&vlookup_if_and_or_Capacity_Planning.xlsx','Sheet1','B26','basic')
0 Commenti
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!