Publisher review:writeexcel - Writes data to an Excel xml file on any system (NO Excel or ActiveX required!). Usage: writeexcel(file, varlist) Writes data to an Excel xml file on any system (NO Excel or ActiveX required!). Scalars will end up on a sheet called "Scalars" as name (in the first column) and value (in the second column) pairs. Arrays and cell arrays are saved on individual sheets, named by the variable name. If you find any errors, please let me know at peder at axensten dot se. This is still pretty much work in progress, see 'to do', below. ARGUMENTS: file File name path. If prefixed with a '>' (see example, below), the data will be added to an existing file (that was generated by this macro!). varlist List of variables, expressions, and/or strings. Variables and expressions will be written to the file, expressions must be preceded by a 'ame', below. A special case is if a variable of type structure is called DocumentProperties, its field names and values will set the document properties (see the example). Strings can be of the following: - 'ame' sets the name of the next variable or expression, names must be unique. EXAMPLE: DocumentProperties= struct('Title','My Title', 'Author', 'Me', 'Subject', 'very interesting'); astring= 'Hi ya!'; ascalar= pi; anarray= [1 2 3; 4 5 6]; acellarr= {'abc', 'def'; pi, NaN; -Inf Inf}; writeexcel('Workbook.xml', anarray, ascalar, astring, acellarr); writeexcel('>Workbook.xml', 'another scalar', 2*pi/5); Requirements: ยท MATLAB Release: R2007a
writeexcel is a Matlab script for Scientific/Engineering scripts design by Peder Axensten.
It runs on following operating system: Windows / Linux / Mac OS / BSD / Solaris.
Operating system:Windows / Linux / Mac OS / BSD / Solaris