OpenPyXl & Table Style

860 views
Skip to first unread message

valery.o...@gmail.com

unread,
Feb 2, 2016, 8:20:14 AM2/2/16
to openpyxl-users
Is there any possibility to set Table Style (decribed here https://support.office.com/en-us/article/Format-an-Excel-table-6789619F-C889-495C-99C2-2F971C0E2370) via OpenPyXL? I used Table Style in Excel to alternate row colors. Now I alternate row colors in OpenPyXl manually, without using any Table Styles. 

Charlie Clark

unread,
Feb 2, 2016, 8:37:27 AM2/2/16
to openpyx...@googlegroups.com
Hi Valery,

I'm sorry that this is currently not possible with openpyxl. Version 2.4
will probably have the necessary machinery but not the plumbing. In the
meantime, as long as you are only creating files, you can do this with
xlsxwriter:
https://xlsxwriter.readthedocs.org/en/latest/working_with_tables.html

Charlie
--
Charlie Clark
Managing Director
Clark Consulting & Research
German Office
Kronenstr. 27a
Düsseldorf
D- 40217
Tel: +49-211-600-3657
Mobile: +49-178-782-6226

Shyran tankian

unread,
Sep 25, 2018, 3:30:27 AM9/25/18
to openpyxl-users
Hi Charlie,

i don't found this issue on bitbucket, it's planned for next releases ?

rRgards,

Charlie Clark

unread,
Sep 25, 2018, 4:17:04 AM9/25/18
to openpyx...@googlegroups.com
Am .09.2018, 09:30 Uhr, schrieb Shyran tankian <shyr...@gmail.com>:

> i don't found this issue on bitbucket, it's planned for next releases ?

https://openpyxl.readthedocs.io/en/stable/worksheet_tables.html

Shyran tankian

unread,
Sep 26, 2018, 2:41:23 AM9/26/18
to openpyx...@googlegroups.com
nice! thanks!

--
You received this message because you are subscribed to a topic in the Google Groups "openpyxl-users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/openpyxl-users/GIr15hDBcl8/unsubscribe.
To unsubscribe from this group and all its topics, send an email to openpyxl-user...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Reply all
Reply to author
Forward
0 new messages