Excel Data with Column Names

조회 수: 227(최근 30일)
Preetam Pal
Preetam Pal 2015년 8월 17일
답변: Pruthvi G 2020년 4월 13일
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

답변(2개)

Star Strider
Star Strider 2015년 8월 17일
편집: Star Strider 2015년 8월 17일
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.
  댓글 수: 1
Anurag Pujari
Anurag Pujari 2017년 1월 7일
Thanks

댓글을 달려면 로그인하십시오.


Pruthvi G
Pruthvi G 2020년 4월 13일
%%********************************************************************************
% 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'}

Community Treasure Hunt

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

Start Hunting!

Translated by