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

27 次查看（过去 30 天）
Yasmine Abdennadher
回答： Son 2024-6-21
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?

请先登录，再回答此问题。

回答（2 个）

Hank
Hank 2020-6-1
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')
  2 个评论
Yasmine Abdennadher
Yasmine Abdennadher 2020-6-1
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
Hank 2020-6-3
is the data numeric? Can you share and example of the data, or the file?

请先登录，再进行评论。

Son
Son 2024-6-21
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)

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by