Multiple format of text in a single cell
moss8299
I have a need to highlight some text in a cell by making them bold
but I'm not sure how to. I've looked at the tutorials and
documentation and couldn't find a solution. So I was wondering if it
is possible to do so?
I would appreciate if someone could help me out here. It would
really make my day more special.
Gabriel Lima de Oliveira
Take a look at there.
I have never experienced this wonder.
Hope I said all right.
Thks
--
You received this message because you are subscribed to the Google Groups "python-excel" group.
To post to this group, send an email to python...@googlegroups.com.
To unsubscribe from this group, send email to python-excel...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/python-excel?hl=en-GB.
Chris Withers
> I have a need to highlight some text in a cell by making them bold
> but I'm not sure how to. I've looked at the tutorials and
> documentation and couldn't find a solution. So I was wondering if it
> is possible to do so?
Formatting the contents of a cell is easy enough.
Having multiple formats within a single cell is not something that's
been implemented. This has been discussed before on this list, search
the archives.
It would be great to have this feature, but someone would need to come
up with the code or stump up the cash to get it done for them.
cheers,
Chris
--
Simplistix - Content Management, Batch Processing & Python Consulting
- http://www.simplistix.co.uk
moss8299
I've dug around the archive and stumbled upon a discussion back in
March started by Rob, in one of the replies, Rob mentioned that he got
it working by implementing "Rich Text".
I'm not quite sure how he did it, but after reading through open
office's Excel File Format, I still couldn't figure out how it can be
done. Would really appreciate if you could shed some light on this.
Thank you in anticipation.
moss8299
win32com.
something like 'c.GetCharacters(1,5).Font.ColorIndex = 3'. That was
until when I discovered that I need win32.client which is not present
in my linux Python 2.4 - I know, it's old, but somehow my company is
sticking to it for reasons beyond me.
So, right now, I think i'm going the win32 way, is it possible to get
it for Linux?
Thanks.
Chris Withers
> So, right now, I think i'm going the win32 way, is it possible to get
> it for Linux?
No, win32com, as it's name implies, only runs on win32.
While there is Mono that I seem to remember is com-like on Linux, I'm
pretty sure you won't see MS releasing Excel on Linux any time soon.
I'd postulate that changing the formatting you want to do is going to be
a lot easier than trying to get a Windows VM AND Excel AND Python on
Windows talking to is via COM AND a process for communicating with that
Python from the Linux host OS reliably...
Of course, you or anyone else is more than welcome to stump up either a
patch or cash to have the patch written that will implement this in
xlrd/xlwt/xlutils. Sadly, I seem to remember it being a far-from-small
task :-(
John Machin
> moss8299 wrote:
>> So, right now, I think i'm going the win32 way, is it possible to get
>> it for Linux?
>
> No, win32com, as it's name implies, only runs on win32.
> While there is Mono that I seem to remember is com-like on Linux, I'm
> pretty sure you won't see MS releasing Excel on Linux any time soon.
>
> I'd postulate that changing the formatting you want to do is going to be
> a lot easier than trying to get a Windows VM AND Excel AND Python on
> Windows talking to is via COM AND a process for communicating with that
> Python from the Linux host OS reliably...
>
> Of course, you or anyone else is more than welcome to stump up either a
> patch or cash to have the patch written that will implement this in
> xlrd/xlwt/xlutils. Sadly, I seem to remember it being a far-from-small
> task :-(
See my message entitled "Rich text (was etc etc)" a few minutes ago.
Please reply to that message if necessary, not this one.