COM_xlswrite

Write Microsoft Excel spreadsheet file using COM.

Syntax

  • COM_xlswrite(filename, v)

  • COM_xlswrite(filename, v, sheet)

  • COM_xlswrite(filename, v, range)

  • COM_xlswrite(filename, v, sheet, range)

  • status = COM_xlswrite(filename, v)

  • status = COM_xlswrite(filename, v, sheet)

  • status = COM_xlswrite(filename, v, range)

  • status = COM_xlswrite(filename, v, sheet, range)

  • [status, msg] = COM_xlswrite(filename, v)

  • [status, msg] = COM_xlswrite(filename, v, sheet)

  • [status, msg] = COM_xlswrite(filename, v, range)

  • [status, msg] = COM_xlswrite(filename, v, sheet, range)

Input argument

  • filename - a string: a full filename path.

  • v - a string, cell, matrix: values to save.

  • sheet - an integer or a string: sheet id or sheet name

  • range - an string: an range xx:xx

Output argument

  • status - a logical: true if save.

  • msg - a string: '' if no error or an error message.

Description

COM_xlswrite Writes Microsoft Excel spreadsheet file using COM.

Inf is converted by Excel as 65535.

Examples

COM_xlswrite([tempdir(), 'example_xlswrite_1.xlsx'], rand(3, 3))
data = {'Time', 'Temp'; 12 98; 13 99; Inf 97};
s = COM_xlswrite([tempdir(), 'example_xlswrite_2.xlsx'], data, 'Temperatures');

See also

COM_xlsread.

History

VersionDescription

1.0.0

initial version

Author

Allan CORNET

PreviousCOM_xlsreadNextSUMMARY

Last updated