Comments (6)
I actually have the same exact problem. This would be appreciated!
from openpyxl.
Same problem for me, recently i'm doing a job to automate the slicer graph reports.
But whenever I updated the data and save it, the slicer will always missing.
Hope openpyxl to do something, would really appreciated.
from openpyxl.
This problem still persists. I have pivots, graphs, and slicers already set up on a whole different sheet. Doesn't get touched but I guess the whole workbook has to pass through the OOXML or something and can't read the slicer lists. Is it possible to just not delete the slicer lists since it doesn't get touched?
My next best bet for automating this part is to keep the pivots, graphs, and slicers on a whole different sheet and save a templated output .xlsx which gets referenced by the reporting .xlsx. Heres to hoping that works, and if not then hopefully this gets fixed. I really like openpyxl for its ease of use.
from openpyxl.
i have similar problem. I have an excel sheet with some pivot tables, slicers and pivotcharts and I just want to update the input data on another sheet but openpyxl is screwing up my charts as well. it seems its not able to process these charts correctly :( anyone knows of any workaround?
from openpyxl.
The excel slicers are still automatically removed when I update the input data on a different worksheet. I hope there will be a support for this. Thanks.
from openpyxl.
I would really appreciate a way to keep my slicers. Is there way to have openpyxl only edit the sheet that I select? That way the sheet with the slicers is preserved?
from openpyxl.
Related Issues (20)
- Inserting rows causes hyperlink targets to shift
- Opening and saving this workbook results in corrupt file HOT 2
- load_workbook works in Python 3.6.5 but gives error in 3.8.3
- to_excel throws AttributeError if parameter dt is None
- excel reserved \r\n
- Custom file extension loading
- Explicit extension when loading workbook
- Add Plan Maker's .xlsx support
- Case-sensitivity of rel.target
- Issue with Japanese characters
- Does not work for Mac OS, but it works for Ubuntu
- after calling ws.insert_rows(), the row dimension don't follow the new position
- Apache can't start up when I using openpyxl in Django HOT 1
- XLSM unable to be saved
- read_excel() cannot read excel files properly with openpyxl HOT 1
- load_workbook slow with a workbook containing chart sheet
- Openpyxl 'data_only=True' shows Excel formula filed value as 'None'
- Clustered chart elements being rendered on top of another
- insert_rows的BUG
- Locked Cells...
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from openpyxl.