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.
I don't know for sure, but think it maybe has a relation with labels, and formatting that cell. Take a look at there. I have never experienced this wonder. Hope I said all right.
On Mon, Jan 4, 2010 at 8:02 AM, moss8299 <phko...@gmail.com> wrote: > To anyone out there who has the solution,
> 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.
> --
> 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-excel@googlegroups.com. > To unsubscribe from this group, send email to > python-excel+unsubscribe@googlegroups.com<python-excel%2Bunsubscribe@google groups.com> > . > For more options, visit this group at > http://groups.google.com/group/python-excel?hl=en-GB.
moss8299 wrote: > 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.
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.
On Jan 5, 4:34 pm, Chris Withers <ch...@simplistix.co.uk> wrote:
> moss8299 wrote: > > 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.
Another thing that I was hoping to do was to do post processing via 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.
On Jan 6, 4:01 pm, moss8299 <phko...@gmail.com> wrote:
> 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.
> On Jan 5, 4:34 pm, Chris Withers <ch...@simplistix.co.uk> wrote:
> > moss8299 wrote: > > > 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.
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 :-(
> 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.
