How to extract labels from a xlsx graph in matlab

2 次查看（过去 30 天）
Amanda
Amanda 2022-10-30
编辑： Star Strider 2022-10-31
I am trying to extract labels from a excel file. I can get it to give me the label for one data cell but when i try doing it for more then one it doesn't work. This is what i have so far but I dont know how to fix this problem

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

回答（1 个）

Star Strider
Star Strider 2022-10-30
It depends how you’re importing the Excel file. If you use readtable, the header line (assuming only one) will be ‘VN’ in:
T1 = readtable('Your ExcelFile.xlsx', 'VariableNamingRule','preserve')
VN = T1.Properties.VariableNames;
If you’re using xlsread, it should be in the second output.
If you’re using readmatrix, all is lost, since the header lines will not be imported.
.
  2 个评论
Star Strider
Star Strider 2022-10-31
编辑：Star Strider 2022-10-31
The second output should be a cell array of non-numeric information. You need to request the second and third outputs specifically. By default, only the first output will result if you only ask for one output. (The third output is a cell array of all the information.) You will need to extract the labels from the second or third output.
EDIT — (31 Oct 2022 at 16:26)
If you post the Escel file, I might be able to help with this. I cannot do anything without it.

请先登录，再进行评论。

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by