Write structure array into Excel sheet

Version 1.0 (6.68 KB) by Wei-Rong Chen
Write a structure array into Excel sheet
481 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 (2024). Write structure array into Excel sheet (https://www.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

Community Treasure Hunt

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

Start Hunting!
Version Published Release Notes
1.0