image thumbnail

xls2mat

version 1.1.0.0 (2.45 KB) by Matthew Kelly
converts a spreadsheet file to a Matlab struct

202 Downloads

Updated 13 Dec 2015

View License

% DATA = xls2mat(In_File_Name,Out_File_Name)
%
% Take an excel spreadsheet and convert it to a matlab struct,
% with a field for each column in the spreadsheet.
%
% This function xls2mat, assumes a special structure in the spreadsheet
% file, described in detail below.
%
%
%
% INPUTS:
% In_File_Name must be a .xls extension
% Out_File_Name must be a .mat extension
%
%
% OUTPUTS:
% DATA = a struct with one field for each column in the spreadsheet, and
% the name of the field will be the name of the column. If the data in
% the given column is strings, then the corresponding field will be a
% cell array. If it is numeric, then the field will be a column vector.
%
% If the second argument is present, then DATA will be written to a .mat
% file.
%
%
%
% NOTES:
%
%
% This function assumes a special structure in the spreadsheet:
%
% 1) The first row is a header row of strings. These strings must be valid
% matlab variable names, and they must be unique (or they will be
% overwritten).
%
% 2) Each column has a consistent data type (numerical or string)
%
% 3) There must be no blank columns, or blanks in the first row of data
%
%
%
% This function is built around xlsread(), and thus will work on any files
% that are correctly recognized by xlsread(). Type
% >> help xlsread
% for additional details regarding this.
%

Cite As

Matthew Kelly (2021). xls2mat (https://www.mathworks.com/matlabcentral/fileexchange/54461-xls2mat), MATLAB Central File Exchange. Retrieved .

MATLAB Release Compatibility
Created with R2012a
Compatible with any release
Platform Compatibility
Windows macOS Linux
Acknowledgements

Inspired by: XLS2STRUCT, xls2struct, xls2struct

Community Treasure Hunt

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

Start Hunting!