xlsread returns empty when reading a cell with a formula

3 Ansichten (letzte 30 Tage)
Leonardo Wayne
Leonardo Wayne am 18 Mär. 2016
Beantwortet: Azzi Abdelmalek am 18 Mär. 2016
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')

Melden Sie sich an, um diese Frage zu beantworten.

Antworten (1)

Azzi Abdelmalek
Azzi Abdelmalek am 18 Mär. 2016
[num,text,both] = xlsread('h&vlookup_if_and_or_Capacity_Planning.xlsx','Sheet1','B26','basic')

Kategorien

Mehr zu Data Import from MATLAB finden Sie in Help Center und File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by