MATLAB: How to select automaticaly a header of excel sheet and read the header row with xlread

xlsread

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.

Best Answer

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

Related Solutions

MATLAB: Reading a special sheet of an EXCEL file with knowing the row numbers of that

use [Num,Txt,Raw]=xlsread(ExcelFile,SheetName)

then size(Raw) will tell you how many rows and columns of data are in that sheet.

MATLAB: Xlsread function: How to only get certain info from Excel Spreadsheets

>> help xlsread
  xlsread Read Microsoft Excel spreadsheet file.
    [NUM,TXT,RAW]=xlsread(FILE) reads data from the first worksheet in the Microsoft
    Excel spreadsheet file named FILE and returns the numeric data in array NUM.
    Optionally, returns the text fields in cell array TXT, and the unprocessed data
    (numbers and text) in cell array RAW.
 
    [NUM,TXT,RAW]=xlsread(FILE,SHEET) reads the specified worksheet.
 
    [NUM,TXT,RAW]=xlsread(FILE,SHEET,RANGE) reads from the specified SHEET and RANGE.
    Specify RANGE using the syntax 'C1:C2', where C1 and C2 are opposing corners of
    the region. Not supported for XLS files in BASIC mode.

Best Answer

Related Solutions

MATLAB: Reading a special sheet of an EXCEL file with knowing the row numbers of that

MATLAB: Xlsread function: How to only get certain info from Excel Spreadsheets

Related Question