Readtable for excel workbook file

What command can I use to read an excel workbook(xlsx) file as a table into MATLAB?Also, how do I skip the first 5 rows of the workbook as Headerlines?

[Walter Roberson]

readtable() with 'range', 'A6'

Answer 1

[Cris LaPierre]

https://www.mathworks.com/help/matlab/import_export/ways-to-import-spreadsheets.html

Also look at the Name-Value pair arguments for readtable. Note that, for Spreadsheet files, only these parameter names apply: FileType, ReadVariableNames, ReadRowNames, TreatAsEmpty, DatetimeType, Sheet, Range, UseExcel, and TextType.

[Waqas Siddique]

It is not giving information on how to skip the headerlines

[Cris LaPierre]

I might have bolded one of the options in my reply to point you in the right direction.

[Ali]

do we have a Excel.Workbooks.activate?

[Cris LaPierre]

Not with readtable. You are asking about ActiveX syntax. For that, see this example and this Answers post.