Setting an excel cell to bold using OleAutomationObject

[cjaouhar]

I control an excel spreadsheet in smalltalk using OleAutomationObject. I can write data to cell using "aRange propertyAt: 'Value' put: myString". Which property can I use in order to set a cell as Bold and what is the valid value?

CJ

[marten]

I control an excel spreadsheet in smalltalk using OleAutomationObject. I can write data to cell using "aRange propertyAt: 'Value' put: myString". Which property can I use in order to set a cell as Bold and what is the valid value?

CJ

I do not know it, but when googling around one seem to have to execute something like

mysheet.cells(1, 1).font.bold = True

...actually this should give one a hint, where to search for the solution. In one of my books I read:

Range("B15").Font.Bold = true ...

Marten

[cjaouhar]

Using the "Bold" property works fine to make a cell bold. Now which property can I use in order to put a color on a particular cell?

[marten]

Using the "Bold" property works fine to make a cell bold. Now which property can I use in order to put a color on a particular cell?

Perhaps a look at:

http://www.cpearson.com/excel/colors.htm

should give you a help ?

Marten