Download All

Code covered by the BSD License

4.5

4.5 | 2 ratings Rate this file 19 Downloads (last 30 days) File Size: 3.61 KB File ID: #26968

MAT2XLS v2.0

16 Mar 2010 (Updated 02 Jun 2010)

Stores and customizes numeric array or cell array in Excel workbook using ActiveX interface.

File Information
Description	The function allows to create MS Excel documents and assigns the specified properties and values to customize the output in excel. Use usually known standard properties like "backgroundcolor", "fontname", "HorizontalAlignment" and many other to customize the output in excel.
Acknowledgements	The author wishes to acknowledge the following in the creation of this submission: write2excel
MATLAB release	MATLAB 7.10 (2010a)
Other requirements	- Excel should be installed on your machine.

Tags for This File
Everyone's Tags	activex, api, automation, com, excel, external, interface, object, oop, oriented, xls, xlsread, xlswrite, xslx(2)
Tags I've Applied
Add New Tags	Please login to tag files.

Comments and Ratings (4)
04 May 2010	LP	BUG in function ind2range : If passing column index 26 ('Z'), rolls back to 'A' and then goes to 'AA' for column index 27
02 Jun 2010	Elmar Tarajan	BUG FIXED!
15 Jun 2010	Mike	This program is great and it works really well. I was just wondering if there was some way I could make the borders not occur completely around the cell, but have the option to individually choose "left", "top", "right", "bottom", etc~ Sorry I'm a little new to MATLAB. Thx!
24 Jun 2010	Elmar Tarajan	Mike, > option to choose the border individually I already work on it. Coming soon! :) Elmar

Please login to add a comment or rating.

Updates
17 Mar 2010	- fixed cosmetic bug
02 Jun 2010	fixed bug while calculating the excel value range