Effacer les filtres
Effacer les filtres

xlsread returns empty when reading a cell with a formula

1 vue (au cours des 30 derniers jours)
Leonardo Wayne
Leonardo Wayne le 18 Mar 2016
Réponse apportée : Azzi Abdelmalek le 18 Mar 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')

Connectez-vous pour répondre à cette question.

Réponses (1)

Azzi Abdelmalek
Azzi Abdelmalek le 18 Mar 2016
[num,text,both] = xlsread('h&vlookup_if_and_or_Capacity_Planning.xlsx','Sheet1','B26','basic')

Catégories

En savoir plus sur Spreadsheets dans Help Center et File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by