Borrar filtros
Borrar filtros

xlsread returns empty when reading a cell with a formula

1 visualización (últimos 30 días)
Leonardo Wayne
Leonardo Wayne el 18 de Mzo. de 2016
Respondida: Azzi Abdelmalek el 18 de Mzo. de 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')

Iniciar sesión para responder a esta pregunta.

Respuestas (1)

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

Categorías

Más información sobre Spreadsheets en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by