How can I select automaticaly a header of excel sheet and read the header row with xlread?

hello,

i have an excel sheet with sensor measurment data . I use xlsread to read the data my question is how can i select the header name of the row and read the data. the header name is always the same but the coulmn number is different therefore i want to give the header name and the program should select the data and plot the result. Do you have idea? thanks in advance.

Answer 1

[Walter Roberson]

We would suggest using readtable(), after which you can access the columns by name.

[Nahom Nigatu]

thanks Walter but readtable() give me all info but i want to find first the header name after that i read the column could you give me example i am new for matlab

[Walter Roberson]

xlsx files store the data as text . Reading one column of them inherently requires reading all of the columns and throwing away the parts that you do not want . You might as well readtable and access the part you want out of the result .

xls files can be implemented more than one way, one of which is a binary file that might possibly be faster to read just one column . For that use xlsread or readtable and pass it an excel style range like A1:XFD1 . You can then search for your known header in what is returned .

[Nahom Nigatu]

thanks Walter, my problem is how i select the header name with right range i have still done this

data = xlsread(File,'Sheet1','A2:A100');

I can read from this sheet a specified range 'A2:A100' in range 'A1:A1' exist header name 'Test1' but header name Test1 is not always in the same range some times in range B or C . The header name is always the same but the range postion is not thats why i want to get first search the header first and read the apropriert range. Is there any oportunity to do this? I can select every time manually but i wannt to select the range automaticly. Thanks in advance!