Write structure array into Excel sheet

Version 1.0 (6.68 KB) by Wei-Rong Chen
Write a structure array into Excel sheet
489 Downloads
Updated 11 Apr 2015

View License

% usage: xlscell=WriteXlsFromStruct(DataStruct, outXlsName, sheet, ifOvewriteExist);
% This function writes a 1x1 structure array into Excel file.
% Each field in the input structure containes the data of a column in the output Excel sheet.
% See the sample 'xlsStruct.mat' for the format of the input structure array.
% The data struct conforms to the output struct generated by 'xls2struct.m'.
% 'ifOvewriteExist': Whether or not overwrite existing output Excel file.
% See also 'xls2struct.m'

Cite As

Wei-Rong Chen (2026). Write structure array into Excel sheet (https://au.mathworks.com/matlabcentral/fileexchange/50465-write-structure-array-into-excel-sheet), MATLAB Central File Exchange. Retrieved .

MATLAB Release Compatibility
Created with R2008a
Compatible with any release
Platform Compatibility
Windows macOS Linux
Tags Add Tags
Version Published Release Notes
1.0