"Slicer list extension" warning message

Bill St. Louis

unread,

Jul 27, 2017, 1:00:35 PM7/27/17

to openpyxl-users

I'm using Openpyxl against a workbook that uses pivot slicers on some of the worksheets. When I run my code, I get:

/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/openpyxl/reader/worksheet.py:307: UserWarning: Slicer List extension is not supported and will be removed

warn(msg)

It's a warning, so everything still works fine. Is there ay way to get rid of this? I'm not even accessing the sheet with the slicer - this one is a regular, flat worksheet.

Stephen

unread,

Oct 18, 2018, 3:45:15 PM10/18/18

to openpyxl-users

I actually have the same use case, where I'm not touching a worksheet with the pivot table on it, but it seems my slicers are getting destroyed when saving the workbook. Is there any workaround for this?

Charlie Clark

unread,

Oct 19, 2018, 5:05:17 AM10/19/18

to openpyx...@googlegroups.com

Am .10.2018, 21:45 Uhr, schrieb Stephen <sanders...@gmail.com>:

> I actually have the same use case, where I'm not touching a worksheet
> with the pivot table on it, but it seems my slicers are getting
> destroyed when
> saving the workbook. Is there any workaround for this?

Slicers are *not* part of the OOXML specification which is why they're
lost. There is currently no workaround for this. It should be possible to
add support for such extensions to openpyxl at some point but it's not a
priority for me.

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

rac...@gmail.com

unread,

Aug 5, 2020, 10:11:05 AM8/5/20

to openpyxl-users

Any update on this one. Do we support slicers now? I have a similar scenario and all slicers are getting removed after save.

Charlie Clark

unread,

Aug 5, 2020, 10:12:44 AM8/5/20

to openpyxl-users

On 5 Aug 2020, at 16:11, rac...@gmail.com wrote:

> Any update on this one. Do we support slicers now? I have a similar
> scenario and all slicers are getting removed after save.

No, there is no change.

Mohammad Shareef

unread,

Oct 7, 2020, 7:24:05 AM10/7/20

to openpyxl-users

Any update on this one.

Charlie Clark

unread,

Oct 7, 2020, 8:36:23 AM10/7/20

to openpyxl-users

On 7 Oct 2020, at 13:24, Mohammad Shareef wrote:

> Any update on this one.

Have you checked the change log?

No, unless someone does the work themselves or contracts me to do this,
then things will stay as they are.

Mai Ibrahim

unread,

Jun 28, 2021, 5:10:06 PM6/28/21

to openpyxl-users

i'm a kinda new to Python although i'm trying to automate some Excel sheets that i'm using daily so i have the same issue currently of destroyed slicers after appending new dataframe to Excel sheet .

I can see it's been discussed for along time so I wish if anybody can help!

Reply all

Reply to author

Forward