How to read in Excel Default headers ?

4 次查看（过去 30 天）

显示更早的评论

Sajid Afaque 2022-3-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1662670-how-to-read-in-excel-default-headers

编辑： Stephen23 2022-3-3

在 MATLAB Online 中打开

Hello ,

I am trying to read data from excel using readtable

data = readtable('filename.xlsx');

Now if i want to read in deafult column name of excel (highlighted one)

How may i acheive this ?

Thanks in advance

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Stephen23 2022-3-3

编辑：Stephen23 2022-3-3

Those are not headers, those are the column labels or column references (analagous to indices in MATLAB):

https://docs.microsoft.com/en-us/office/troubleshoot/excel/numeric-columns-and-rows

The concept of "default" is not very meaningful as the column order is fixed and the labels cannot be changed (other than between A1 and R1C1 style references). Because they don't change I doubt that any Excel-processing app bothers to "import" them. As far as I can tell, they are not even stored explicitly in an XLSX file (references to individual cells or ranges certainly are, but I cannot find a list of column labels anywhere).

You can derive the column labels yourself from the column number, for example:

https://www.mathworks.com/matlabcentral/answers/248797-i-need-to-convert-a-number-into-its-column-name-equivalent#answer_405713

请先登录，再进行评论。

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