Cell formatting functions

[zoquda]

It would be really great if additional functions for changing cell formatting could be implemented. In my personal opinion the most important cell formatting characteristics that are currently still unsupported are:

• font type
• font size
• font style (bold / italic / underline)
• font color
• text alignment
• borders

[fzumstein]

sure, it's on the list, it's also at the top here

[surfmaverick]

Hi Felix - this page is emtpy:

http://docs.xlwings.org/missing_features.html

[fzumstein]

It changed to: http://docs.xlwings.org/en/stable/missing_features.html, I'll update it on uservoice

[zoquda]

Thanks for pointing out the uservoice page. I've added my vote.

[LiaungYip]

More detail on the workarounds is at: http://nbviewer.jupyter.org/github/pybokeh/jupyter_notebooks/blob/master/xlwings/Excel_Formatting.ipynb
which includes specific examples i.e. how to apply borders, change font size, colours, etc.

[LiaungYip]

@fzumstein , suppose that someone wanted to add formatting support to xlwings.

What should the API look like?

Refer #302 where some preferences were expressed.

[fzumstein]

I think that comment is still right, the whole api is now very close to the original, so no need to deviate for font etc.

[rkpatel33]

Does anyone have examples similar to the Jupyter notebook above but for OSX/Mac Excel? Specifically I'm trying to set the font color of a cell or range. Even just that snippet would be helpful, thanks!

[fzumstein]

You can workaround like this:

import xlwings as xw

rgb_tuple = (255, 0, 0)
xw.Range('A1').api.font_object.color.set(rgb_tuple)

[rkpatel33]

​Th​anks!

…

_________________________ Rishi Patel | mail@rishinyc.com

On Wed, Apr 26, 2017 at 2:44 AM, Felix Zumstein ***@***.***> wrote: You can workaround like this: import xlwings as xw rgb_tuple = (255, 0, 0) xw.Range('A1').api.font_object.color.set(rgb_tuple) — You are receiving this because you commented. Reply to this email directly, view it on GitHub <https://github.com/ZoomerAnalytics/xlwings/issues/559#issuecomment-297323024>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ADn5wXs2iqvNDdRsIKp03u4IBmqVqUCKks5rzxHugaJpZM4J0U4E> .

[fzumstein]

0.23.0 added support for these:

• font type, aka name
• font size
• font style (bold / italic)
• font color

so only the following missing from this list:

• font style (underline)
• text alignment
• borders