How can I export the entirety of an excel table to a matlab table/matrix?

2 次查看（过去 30 天）
Vanessa Hernandez-Cruz
回答： Shubham Khatri 2021-7-30
I am trying to post-process data that can be found in a .xlsm file. First, I am trying to successfully export the data into MATLAB. I am not receiveng any error messages, the issue is that the output is not the specified range I am asking for. I tried using readtable, readmatrix, xlsread: they all have the same issue. I also tried the import tool, but that was also unsuccessful. I suspect the issue is that some cells are empty so that is somehow cofusing the command I am calling to import a range of the .xlsm file I am using. For reference, the range I am asking for is A147:RS1057. When I go back to double check the table MATLAB gives me with that actual range in the excel file, it is not the same. Any help would be appreicated, thank you!

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

回答（1 个）

Shubham Khatri
Shubham Khatri 2021-7-30
Hello,
It is slightly unclear what issue you are facing. I will be able to assist you better, if you can share some more details or the file. I As of now, I tried reproducing your issue. I created an xlsm file with multiple some cells empty and some with numeric and alphabetical values. I was able to import files with some unimportable values replaced by NaN (or some other value of choice). Please take a look at this answer, which might be of some help.
Also, take a look at documentaiton of import tool.
Hope it helps

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by