Path: news.mathworks.com!not-for-mail
From: "Chris " <checkeraz69@yahoo.com>
Newsgroups: comp.soft-sys.matlab
Subject: Re: Excel Through ActiveX - Command list?
Date: Tue, 13 Nov 2007 19:11:46 +0000 (UTC)
Organization: Glendale Community College
Lines: 28
Message-ID: <fhcsti$p66$1@fred.mathworks.com>
References: <fh9cq0$l0k$1@fred.mathworks.com>
Reply-To: "Chris " <checkeraz69@yahoo.com>
NNTP-Posting-Host: webapp-05-blr.mathworks.com
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit
X-Trace: fred.mathworks.com 1194981106 25798 172.30.248.35 (13 Nov 2007 19:11:46 GMT)
X-Complaints-To: news@mathworks.com
NNTP-Posting-Date: Tue, 13 Nov 2007 19:11:46 +0000 (UTC)
X-Newsreader: MATLAB Central Newsreader 246177
Xref: news.mathworks.com comp.soft-sys.matlab:437343



"James Delph" <ziv_parizat@amat.com> wrote in message
<fh9cq0$l0k$1@fred.mathworks.com>...
> Hi,
> 
> I'm working with Matlab and I'm trying to automate a 
> report creation. All suggested builtin functions can't 
> help me because this report is very non-standart.
> 
> Do you know where I can find the command list that 
> corresponds to Excel?
> (i.e: to create a black border around a cell selsction, 
> the Matlab syntax would be: 
>         ActivesheetRange.Borders.Weight=2;
>         ActivesheetRange.Borders.LineStyle=1;
>         ActivesheetRange.Borders.ColorIndex=1;
> )
> 
> What other commands are available?
> Thanks!

James,

My standard answer to this type of question is to proto the
commands in excel/vba thru a macro.  Then examine the macro
and search VB help to determine the underlying constants. 
Then translate the whole bit to matlab syntax.

-Chris