struc2xls

Version 1.0.0.0 (2,34 ko) par Jeff Evans
Writes a data structure in MATLAB to an excel file.
4,6K téléchargements
Mise à jour 22 déc. 2008

Afficher la licence

Modified from Francisco de Castro's code, struc2xls lets you save data structures containing a mix of numeric and non-numeric data to an Excel file. This version runs faster than the original and has several extra output options.

STRUC2XLS (FILE,S) writes the data structure S to an Excel workbook named FILE in the current directory. Data fields can be numeric, non-numeric, or mixed. Output can be oriented vertically (field names in first column, data in rows) or horizontally (field names in first row, data in columns). I'm sure there's room for improvement here. Let me know...

EXAMPLES:
Create a sample structure 's' with two fields:
s=struct('Name',{'Jon','Jonathan','Johnny'},'Score',[85,100,75]);

Basic output to file 'demo.xls' in current directory:
struc2xls('demo',s)

Output beginning in cell D4 of Excel file:
struc2xls('demo',s,'Col','D','Row',4)

Output to specified worksheet 'Students':
struc2xls('demo',s,'Sheet','Students')

Output horizontal data (header row, data in columns):
struc2xls('demo',s,'Orientation','H')

Output to alternate directory
struc2xls('C:\Users\Johnny\Desktop\demo',s)

Citation pour cette source

Jeff Evans (2024). struc2xls (https://www.mathworks.com/matlabcentral/fileexchange/22510-struc2xls), MATLAB Central File Exchange. Récupéré le .

Compatibilité avec les versions de MATLAB
Créé avec R2008a
Compatible avec toutes les versions
Plateformes compatibles
Windows macOS Linux
Remerciements

Inspiré par : struc2xls

Community Treasure Hunt

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

Start Hunting!
Version Publié le Notes de version
1.0.0.0