correction:
...ColorIndex = 3
(i think the value, that ColorIndex gets is an integer not a string)
________________________________
Von: [EMAIL PROTECTED] im Auftrag von [EMAIL PROTECTED]
Gesendet: Mi 24.09.2008 15:00
An: [EMAIL PROTECTED]; python-win32@python.org
Betreff: Re: [python-win32] Controlling Excel via COM: errors
withconditionalformatting
How about this?:
channamesSheet.Cells(6, 3).Font.FontSize = 10
channamesSheet.Cells(6, 3).Font.ColorIndex = "blue"
channamesSheet.Cells(6, 3).Value = "something..."
channamesSheet.Cells(6, 3).Font.Name = "Arial"
...
I am not 100% sure whether it works, but i would try that!
Regards,
Solomon Z.
Von: [EMAIL PROTECTED] im Auftrag von kurt munson
Gesendet: Mi 24.09.2008 14:47
An: python-win32@python.org
Betreff: [python-win32] Controlling Excel via COM: errors with
conditionalformatting
I have written a Python program to control MS Excel via win32com.client. This
allows me to create and control an Excel spreadsheet.
I want to use Excel's conditional formatting to color certain cells, but I
can't get it to work.
Here's the code I use:
import win32com.client
xl= win32com.client.Dispatch("Excel.Application")
....
....
....
channamesSheet.Cells(6,3).FormatConditions.Add() Type:=1, Operator:=4,
Formula1:="=C5"
channamesSheet.Cells(6,3).FormatConditions(1).Interior.ColorIndex = 3
I got this code from a record and replay macro in Excel, then swapped out the
xl constants for numeric values (1 and 4).
This gives me a syntax error when running.
I have tried both .Add and .Add(), since sometimes these () are necessary.
What am I doing wrong?
________________________________
Get more out of the Web. Learn 10 hidden secrets of Windows Live. Learn Now
<http://windowslive.com/connect/post/jamiethomson.spaces.live.com-Blog-cns!550F681DAD532637!5295.entry?ocid=TXT_TAGLM_WL_getmore_092008>
_______________________________________________
python-win32 mailing list
python-win32@python.org
http://mail.python.org/mailman/listinfo/python-win32
_______________________________________________
python-win32 mailing list
python-win32@python.org
http://mail.python.org/mailman/listinfo/python-win32
