Excel: Set Background Color using some _EXCEL_* ?

[rudi]

Hello,

I used the various "_Excel_*()" funktions to open workbooks, read and write cells.

 

I was looking through the helpfile for the _EXCEL_* funktions, if there is a direkt way to set background color or text color -- if there is one, then I missed it?

 

Searching the forum I found this posting demonstrating how to do this task using ...

ObjCreate("Excel.Application")

 

Is there a way to set the background color etc. with the native "_EXCEL_*" as well?

 

Regards, Rudi.

 

[Subz]

$oExcel = _Excel_Open returns the same object as ObjCreate("Excel.Application") in fact if you replace ObjCreate("Excel.Application") in the post you referenced with:

#include <Excel.au3>
$oExcel = _Excel_Open()

You'll see that it will work exactly the same.

[rudi]

Hi.

And what is (or is not) the difference between $oExcel and $oWB?

#include <Excel.au3>


$XLWB="C:\temp\Excel-Background-Test.xlsx" ; the Excel file does exist already

$oExcel = _Excel_Open()
$oWB = _Excel_BookOpen($oExcel, $XLWB)

$oWB.ActiveSheet.Range("A1").Value = "Blue on Red" ; Text
$oWB.ActiveSheet.Range("A1").Interior.ColorIndex=3 ; red background
$oWB.ActiveSheet.Range("A1").Font.ColorIndex=5 ; blue text color

 

Thanks a lot!

 

Regards, Rudi.

Edited March 15, 2018 by rudi

[water]

$oWB.ActiveSheet.Range("A1").Interior.Color = <ColorValue>