Re: [python-win32] Formatting parts of an excel cell

2009-04-27 Thread Mark Tolonen
"Baehr, Manuel" wrote in message news:737a64deb003704788e5ce515ed146054b6...@csmail.comsoft.de... Hi Mark, I got an error with that as well, but I figured out the correct way: import win32com.client xl = win32com.client.gencache.EnsureDispatch('Excel.Application') xl.Visible = True xl.Workb

Re: [python-win32] Formatting parts of an excel cell

2009-04-26 Thread Baehr, Manuel
Hi Mark, > I got an error with that as well, but I figured out the correct way: > > import win32com.client > xl = win32com.client.gencache.EnsureDispatch('Excel.Application') > xl.Visible = True > xl.Workbooks.Add() > c = xl.ActiveCell > c.FormulaR1C1 = 'Hello World' > c.GetCharacters(1,5).Font.C

Re: [python-win32] Formatting parts of an excel cell

2009-04-25 Thread Mark Tolonen
"Andrea Gavana" wrote in message news:d5ff27200904250628g433ae546xb0b683b1f32f4...@mail.gmail.com... On Sat, Apr 25, 2009 at 2:00 PM, Mark Tolonen wrote: > > "Baehr, Manuel" wrote in message > news:737a64deb003704788e5ce515ed146054b6...@csmail.comsoft.de... >> >> Hi John, >> >>> Check out the

[python-win32] Formatting parts of an excel cell

2009-04-25 Thread Andrea Gavana
-- Forwarded message -- From: Andrea Gavana Date: Sat, Apr 25, 2009 at 2:28 PM Subject: Re: [python-win32] Formatting parts of an excel cell To: Mark Tolonen Hi, On Sat, Apr 25, 2009 at 2:00 PM, Mark Tolonen wrote: > > "Baehr, Manuel" wrote i

Re: [python-win32] Formatting parts of an excel cell

2009-04-25 Thread Mark Tolonen
"Baehr, Manuel" wrote in message news:737a64deb003704788e5ce515ed146054b6...@csmail.comsoft.de... Hi John, Check out the thread "Multiple formats in a cell" in this group around 2009-03-06. thanks for the link! However, I can't use xlwt (and xlrd) because I have to modify an existing excel

Re: [python-win32] Formatting parts of an excel cell

2009-04-25 Thread Baehr, Manuel
Hi John, > Check out the thread "Multiple formats in a cell" in this > group around 2009-03-06. thanks for the link! However, I can't use xlwt (and xlrd) because I have to modify an existing excel sheet containing macros. Therefore I used the "win32com" module in python under Windows. This work

[python-win32] Formatting parts of an excel cell

2009-04-24 Thread Baehr, Manuel
Hi all, I want to format parts of a cell, i.e. change the color of some characters of the cell's content. Does anyone know how to do that? Thanks a lot, Manuel ___ python-win32 mailing list python-win32@python.org http://mail.python.org/mailman/listinf