How can I change an xlsx file to a mat file?

I have a long column in a form of a .xlsx file and I am trying to convert to a .mat file in order to make a signal. what is the best way to go about this?

Answer 1

[Hank]

Try using

A = readmatrix('spreadsheet.xlsx')

to get the data. See the documentation for help on that. Check that the data loaded correctly.

If you need to save it as a mat file

save('data.mat','A')

[Yasmine Abdennadher]

I tried that, however the numbers in my matrix are small the elements in matrix A are seen as NaN. Do you know how to bypass that?

[Hank]

is the data numeric? Can you share and example of the data, or the file?

Answer 2

[Son]

I think using Import tool is the quickest way.

You can check it here: Import Spreadsheets - MATLAB & Simulink (mathworks.com)

readmatrix as Hank mention is also useful Read matrix from file - MATLAB readmatrix (mathworks.com)