Path: news.mathworks.com!not-for-mail
From: <HIDDEN>
Newsgroups: comp.soft-sys.matlab
Subject: Re: Using the Microsoft Office Spreadsheet object
Date: Wed, 7 Oct 2009 14:39:02 +0000 (UTC)
Organization: The MathWorks, Inc.
Lines: 36
Message-ID: <hai966$jgb$1@fred.mathworks.com>
References: <hagf27$fhi$1@fred.mathworks.com> <haglge$5m$1@fred.mathworks.com>
Reply-To: <HIDDEN>
NNTP-Posting-Host: webapp-02-blr.mathworks.com
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit
X-Trace: fred.mathworks.com 1254926342 19979 172.30.248.37 (7 Oct 2009 14:39:02 GMT)
X-Complaints-To: news@mathworks.com
NNTP-Posting-Date: Wed, 7 Oct 2009 14:39:02 +0000 (UTC)
X-Newsreader: MATLAB Central Newsreader 1560446
Xref: news.mathworks.com comp.soft-sys.matlab:575630


Thanks Cynthia. I actually used this file to get a lot of what I wanted to do but I can't find any instance where the autoformat features of excel are used...
Does anyone know a link, maybe Microsoft where I can get the info that i need?


"Cynthia " <remove.this.cynthia.bell@asu.edu> wrote in message <haglge$5m$1@fred.mathworks.com>...
> Conrad,
> 
> There's an example of how to draw borders around cells in this post:  
> http://www.mathworks.com/matlabcentral/fileexchange/6889 
> 
> Cindy
> 
> 
> 
> "Conrad " <conrad7@gmx.net> wrote in message <hagf27$fhi$1@fred.mathworks.com>...
> > Hi,
> > 
> > I'm trying to format an MS-Excel table from within Malab and I'm a bit stuck at the moment. I've managed to create the table using 'OWC11.Spreadsheet.11' and I have populated it. I don't know how to format the table from within Matlab as one would from an excel macro using the following commands:
> > 
> >   Range("A1:V26").Select
> >   Selection.AutoFormat Format:=xlRangeAutoFormatList1, Number:=True, Font:= _
> >         True, Alignment:=True, Border:=True, Pattern:=True, Width:=True
> > 
> > I also want to draw some lines between different columns as shown in the following excel macro example:
> > 
> >    Range("B1:B26").Select
> >    Selection.Borders(xlDiagonalDown).LineStyle = xlNone
> >     Selection.Borders(xlDiagonalUp).LineStyle = xlNone
> >     Selection.Borders(xlEdgeLeft).LineStyle = xlNone
> >         With Selection.Borders(xlEdgeRight)
> >         .LineStyle = xlContinuous
> >         .Weight = xlThin
> >         .ColorIndex = xlAutomatic
> >     End With
> > 
> > Any help on this would be appreciated.Thanks