Readtable for excel workbook file

1 次查看（过去 30 天）
Waqas Siddique
Waqas Siddique 2021-2-12
编辑： Cris LaPierre 2022-2-2
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?

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

回答（1 个）

Cris LaPierre
Cris LaPierre 2021-2-12
编辑：Cris LaPierre 2021-2-12
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.
  4 个评论
显示 2更早的评论
Alikouider
Alikouider 2022-2-2
do we have a Excel.Workbooks.activate?
Cris LaPierre
Cris LaPierre 2022-2-2
编辑：Cris LaPierre 2022-2-2
Not with readtable. You are asking about ActiveX syntax. For that, see this example and this Answers post.

请先登录，再进行评论。

类别

在 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