Excel Data with Column Names
95 views (last 30 days)
Show older comments
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
0 Comments
Answers (2)
Star Strider
on 17 Aug 2015
Edited: Star Strider
on 17 Aug 2015
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.
Pruthvi G
on 13 Apr 2020
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'}
0 Comments
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!