Read Excel sheet into a structure array

Read Excel sheet into a structure array

You are now following this Submission

% outstruct=xls2struct(xlsFName,sheetnum)
% This function reads the sheet of 'sheetnum' of the input Excel file('xlsFName') and convert it into a
% 1x1 structure array 'outstruct' containing column fields.
% Each field in the output structure containes the data of the
% corresponding column in the input Excel sheet.
% The input Excel sheet MUST content a header row as the first row, which
% will serve as the field name of the output struct.
% 'sheetnum' : the number of the sheet in the input Excel file from which
% the data are read. Default = 1
% Example:
% xls2struct('text.xlsx');
%
% See also 'WriteXlsFromStruct.m'

Cite As

Wei-Rong Chen (2026). Read Excel sheet into a structure array (https://se.mathworks.com/matlabcentral/fileexchange/50464-read-excel-sheet-into-a-structure-array), MATLAB Central File Exchange. Retrieved .

General Information

MATLAB Release Compatibility

  • Compatible with any release

Platform Compatibility

  • Windows
  • macOS
  • Linux
Version Published Release Notes Action
1.0