Board index » delphi » Newby Question

Newby Question

I am trying to format some cells in an Excel SS via Delphi 3.
I know how to do Alignment but not how to set the font, size, stype,
textcolor, cell color etc.
Where can I get a comprehensive list of all commands that Excel will accept.
If it makes any difference, (1) I am doing this via DDE not OLE (bc I
couldn't ever get OLE to work!) and (2) I need the commands for Excel 97 and
Excel 2000.

Tia

 

Re:Newby Question


if you want more info on the excell com object just use the Visual Basic
Editor that comes with excell.

--

-----------------------------------------------------------------
PIQUOT Jr?me
A. WOLFF SA
6, rue de la Gare
67120 ERNOLSHEIM/BRUCHE
FRANCE
e-mail: wo...@media-net.fr
http://www.media-net.fr/wolff
-----------------------------------------------------------------
Tony Tooley <t...@infosearch.com> a crit dans le message :
UWuz3.110$jh7....@news.flash.net...

Quote
> I am trying to format some cells in an Excel SS via Delphi 3.
> I know how to do Alignment but not how to set the font, size, stype,
> textcolor, cell color etc.
> Where can I get a comprehensive list of all commands that Excel will
accept.
> If it makes any difference, (1) I am doing this via DDE not OLE (bc I
> couldn't ever get OLE to work!) and (2) I need the commands for Excel 97
and
> Excel 2000.

> Tia

Re:Newby Question


Try the microsoft news server: msnews.microsoft.com. There's probably
newsgroups on Excel there.

have fun
--
Binh Ly
Visit my COM Notes at http://www.castle.net/~bly/com

Quote
Tony Tooley <t...@infosearch.com> wrote in message

news:UWuz3.110$jh7.243@news.flash.net...
Quote
> I am trying to format some cells in an Excel SS via Delphi 3.
> I know how to do Alignment but not how to set the font, size, stype,
> textcolor, cell color etc.
> Where can I get a comprehensive list of all commands that Excel will
accept.
> If it makes any difference, (1) I am doing this via DDE not OLE (bc I
> couldn't ever get OLE to work!) and (2) I need the commands for Excel 97
and
> Excel 2000.

> Tia

Other Threads