Comments (5)
I think it is a challenge to the underlying library: openpyxl. The boundary condition is related to local computer's memory capacity and the number of cells to be written. So the condition to throw an exception would vary per computer per writing task. To be honest, I do not know how to find the universal boundary condition.
I found a couple of threads relevant for this top in stackoverflow:
http://stackoverflow.com/questions/21328884/openpyxl-writing-large-excel-files-with-python
http://stackoverflow.com/questions/16608028/set-cell-format-and-style-using-optimized-writer-in-openpyxl
So to handle huge data, either optimized writer in openpyxl or xlsxwriter could be provide some hope. Will look at it later.
from flask-excel.
Please try this plugin pyexcel-xlsxw as it tries to use constant memory:
pip uninstall pyexcel-xlsx
pip install https://github.com/pyexcel/pyexcel-xlsxw/archive/master.zip
from flask-excel.
Thanks! I'll give it a try.
from flask-excel.
So far, so good. Requests which crashed my flask api server yesterday (in development) are running without issue ... and much faster too. We'll continue to test. Thanks for finding a solution so quickly!
from flask-excel.
released it to pypi. raise an issue if any problem that will emerge.
from flask-excel.
Related Issues (20)
- Only in wsgi environment, occur response type error HOT 3
- How can I make the query result collection incrementally join the file stream of the flask-excel interface HOT 2
- docs build failure
- Where does Flask-Excel save uploaded file? HOT 2
- How can I used make_response_from_query_sets() where column_names change to new name HOT 3
- Sheet: Category does not match any given tables.Please be aware of case sensitivity. HOT 3
- csv utf8-sig HOT 1
- auto_commit=False in save_to_database and save_book_to_database to allow rollback HOT 3
- IndexError: Index out of range HOT 2
- AttributeError: 'Request' object has no attribute 'get_array' HOT 1
- Interoperability with uWSGI? HOT 8
- How to change the sheet name when using make_response() (or its variants) HOT 2
- Multiple Sheet using Flask Excel HOT 1
- Update existing rows in database HOT 1
- Export Template HOT 1
- New Line HOT 1
- write a csv file using semicolon as delimiter HOT 1
- make_response_from_records sorts keys
- AttributeError for quickstart sample
- SQLAlchemy's Enum-Type unsupported
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 flask-excel.