How to read in Excel Default headers ?

3 visualizzazioni (ultimi 30 giorni)
Sajid Afaque
Sajid Afaque il 3 Mar 2022
Modificato: Stephen23 il 3 Mar 2022
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 Commento
Stephen23
Stephen23 il 3 Mar 2022
Modificato: Stephen23 il 3 Mar 2022
Those are not headers, those are the column labels or column references (analagous to indices in MATLAB):
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:

Accedi per commentare.

Risposte (0)

Prodotti


Release

R2020b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by