Excel Data with Column Names

141 次查看（过去 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.
Pruthvi G
Pruthvi G 2020-4-13
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'}

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by