How to also read the first row correctly with 'readtable'
59 次查看(过去 30 天)
显示 更早的评论
Hello,
I am trying to import an Excel table to Matlab. I used the following command:
T = readtable('Stoomtabellen Excel.xlsx','ReadRownames',true);
In which 'Stoomtabellen Excel.xlsx' is the Excel file. The first row of the table is the variable 'p' (for pressure). You can see this in the attached image. But when it's converted (see other image), the first row shows up correctly, only the variable 'p' is missing. I used 'Readrownames', true, so why doesn't it read the first row correctly 'p'. My question is: how can I make the row 'p' separate from the first row (the 1,2,3, etc. row). I also tried using 'xlsread' and put the 'p' row in a separate row but it didn't include the row names. Thanks in advance.


0 个评论
采纳的回答
Guillaume
2018-4-9
You seem to be confusing rows and columns. 'ReadRowNames', true means use the values in the 1st column to name the rows. In your case, it should be:
T = readtable('Stoomtabellen Excel.xlsx','ReadVariableNames',true);
or simply
T = readtable('Stoomtabellen Excel.xlsx');
since 'ReadVariableNames' is true by default.
0 个评论
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
产品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!