Code covered by the BSD License  

Highlights from
Simple Excel sheet editing program

Be the first to rate this file! 7 Downloads (last 30 days) File Size: 2.12 KB File ID: #26209

Simple Excel sheet editing program

by Peter Lindberg

 

28 Dec 2009

Simple Excel sheet editing program

| Watch this File

File Information
Description

With this program you can edit simple things in an Excel sheet like:
Bold, Fontsize, border, font

Write in command prompt
>> params.Bold = 1;params.FontName = 'Arial';params.FontSize = 10;params.ColorIndex = 56;params.NumberFormat = 4;params.Int_ColorIndex = 0;params.Border = 1;params.BorderWeight = 1;xlcontrol('A1:D1',params,'c:\temp\test.xls','November')

Or paste the code into a script, tryout what happens when you change the params fields. See 'help xlcontrol' for options

The excelfile must exist or be created beforehand

MATLAB release MATLAB 7.7 (R2008b)
Tags for This File  
Everyone's Tags
Tags I've Applied
Add New Tags Please login to tag files.
Please login to add a comment or rating.
Tag Activity for this File
Tag Applied By Date/Time
excel Peter Lindberg 28 Dec 2009 09:35:55
format Peter Lindberg 28 Dec 2009 09:35:55
activex Peter Lindberg 28 Dec 2009 09:35:55
fontsize Peter Lindberg 28 Dec 2009 09:35:55
border Peter Lindberg 28 Dec 2009 09:35:55
format manjunatha reddy 15 Feb 2011 04:34:36
fontsize manjunatha reddy 15 Feb 2011 04:34:40

Contact us at files@mathworks.com