transmit a Excel file in a vector or matrix

Hi,

i'm searching for information to transmit a Excel file in a vector or matrix.

Thanks

[Alex Mcaulley]

What do you mean by "transmit"? Maybe xlsread??

Answer 1

[BN]

I think you want to import an excel file into Matlab.

You can use xlsread if your excel format is .xls

myfile = xlsread('filename.xlsx') %or xls (it depends on format of your excel file)

or csvread if your excel file is .csv

myfile = csvread('filename.csv')

Alternatively, I recommend you to import your excel file using one of these commands:

myfile = readtable('filename.xlsx') %or filename.csv or filename.xls

you can read your excel file as a matrix:

A = readmatrix('filename.xlsx')

Or even read it as cell structure:

C = readcell('filename.xlsx')

once data is read into the workspace using any of the above-mentioned commands, you can do whatever you want.

https://www.mathworks.com/help/matlab/ref/xlsread.html

https://www.mathworks.com/help/matlab/ref/readmatrix.html