How to read a cell from excel that contains a vector

Hello,

I need to read a cell from an excel file, say D4.

The content of D4 is "[2 4 7]" (the doublequotes are just for specification of the cell content, they are not in the cell)

How can I read this cell in Matlab and create a vector A=[2 4 7]?

Thank you

Answer 1

[Khushi Yadav]

Hi @Robert Jones,

I understand that you are trying to read the content of a specific cell (D4) from an Excel file in MATLAB and create a vector with the value from this cell. You can use the 'readcell' function to read data from an Excel file into a cell array in MATLAB.

Here’s an example code that you can use:

   data = readcell('filename.xlsx');
   A = str2num(data{4,4}(2:end-1));
   

The indexing (2:end-1) is used to remove the square brackets from the string before conversion.

You can refer to the following documentation for more information:

1. Create cell array from file - MATLAB readcell - MathWorks India
2. Convert character array or string to numeric array - MATLAB str2num - MathWorks India

I hope this addresses your question!

[Robert Jones]

perfect,thank you