With xlsappend8 you can write a matrix to an existing Excel spreadsheet (in format v97-2003). It's native, so *no* ActiveX server (Excel) needs to be loaded (or even be installed).
- XLSAPPEND8( M, 'FILENAME', SHEET )
- XLSAPPEND8( M, 'FILENAME', SHEET, R, C )
- XLSAPPEND8( M, 'FILENAME', SHEET, R, C, HEAD, COL, SHEET )
The matrix M can be of type double, int32, char, cell or struct. SHEET indicates the sheet in which the data will be written, possible are a name or an index. If SHEET is omitted the first sheet is used.
R and C allow you to define an offset, with HEAD and COL a header and a columnheader is added.
*IMPORTANT*: xlsappend8 needs the dynamic library "xlsWrite8DLL.dll" to work. If you didn't already download xlswrite8.zip please do it now.
More details in xlsappend8.m and in the example/test file append8test.m.
See also: xlsread8, xlswrite8
· MATLAB Release: R13