kurt munson wrote:
> 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:
>
> |im
An interesting read is http://msdn.microsoft.com/en-us/library/bb776904.aspx
- it shows that lots of interesting state is communicated via SetData calls
with custom formats. The IAsyncOperation interface is also an interesting
distraction.
Cheers,
Mark
From: [EMAIL PROTECTED]
[mailto:[
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]
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, bu
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.clientxl=
win32com.clien
>The last arg is output, and will be returned from the function.
>
In that case I am confused about the output coming out of DoDragDrop().
The output that I get for different cases:
drag canceled: 0
copy succeed: 1
move succeed: 0
I expect that move succeed would give me a value of 2
(shellcon.