Excel Data with Column Names

Hi, I need to read data from an excel file in which each column has a heading. The command 'xlsread' only fetches the data, without the column names. Thanks, Preetam

Answer 1

[Star Strider]

Actually, xlsread fetches everything, and will give it to you if you ask it to. To get all the string data, including column names, ask for a second output:

[d,s] = xlsread('file.xls')

The string data are in the ‘s’ output.

EDIT — If you have R2013b or later, the readtable function will import the Excel file data and create a table with the column names automatically.

[Anurag Pujari]

Thanks

Answer 2

[Pruthvi G]

Download Link :: https://in.mathworks.com/matlabcentral/fileexchange/74993-get-sheet-names-from-excel-file

%%********************************************************************************
%   Name          : xl_xlsfinfo
%   Author        : Pruthvi Raj G
%   Version       : Version 1.0 - 2011b Compactible
%   Description   : Finds all the sheets in the Excel file (.xls,.xlsm,.xlsx)
%   Input         : File_Name with path included.
%   Date          : 11-Feb-2020
%
%   Examples      : xl_xlsfinfo('D:\Pruthvi\Test_file.xls')
%*********************************************************************************

Use the Below Lines of Code ::

sheets = xl_xlsfinfo('D:\Pruthvi\Test_file.xls')

 sheets =
  1×5 cell array
    {'Sheet1'}    {'Sheet2'}    {'Sheet3'}    {'Sample'}    {'Data'}