View License

Download apps, toolboxes, and other File Exchange content using Add-On Explorer in MATLAB.

» Watch video

Highlights from
Excel Write Format

Be the first to rate this file! 9 Downloads (last 30 days) File Size: 22 KB File ID: #42385 Version: 1.0
image thumbnail

Excel Write Format


Tom (view profile)


Write data to Excel through MATLAB and format the spreadsheet.

| Watch this File

File Information

Note: this uses a COM interface and so is for Windows only.

This function lets you export multiple sets of data to spreadsheets and apply formatting.
The program is suited to formatting the font (size, name, etc.), changing the cell interior (colour, pattern) , cell range (column width, text alignment) and borders (line style, weight, colour), as some processing/ checks are performed before these are applied. However, formatting can be applied to other fields of the Range interface.

The properties are defined using a structure based on the COM interface. Hopefully this is fairly straightforward, and there is a function to display the options for the interfaces as well as an example covering a wide range of formatting options.

Required Products MATLAB
MATLAB release MATLAB 7.14 (R2012a)
Other requirements Microsoft Excel
Tags for This File   Please login to tag files.
Please login to add a comment or rating.

Contact us