Excel Write Format

バージョン (22 KB) 作成者: Tom
Write data to Excel through MATLAB and format the spreadsheet.
ダウンロード: 1.2K
更新 2013/6/27


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.


Tom (2024). Excel Write Format (https://www.mathworks.com/matlabcentral/fileexchange/42385-excel-write-format), MATLAB Central File Exchange. 取得済み .

MATLAB リリースの互換性
作成: R2012a
Windows macOS Linux
Help Center および MATLAB AnswersSpreadsheets についてさらに検索

Community Treasure Hunt

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

Start Hunting!
バージョン 公開済み リリース ノート