problem writing excel sheet using python

Chris Angelico rosuav at gmail.com
Wed Jul 13 17:41:28 EDT 2016


On Thu, Jul 14, 2016 at 7:29 AM, vineeth menneni
<vineethmenneni33 at gmail.com> wrote:
> Hi I am finding it difficult to create a excel sheet using openpyxl or xlsxwriter. The problem is that i am loading a table data from MYSQL db which has 600k rows and 15 columns (approximately 100mb data). The error that the terminal shows is that "MemoryError". I just wanted to know if it is possible to create a excel sheet with the above said data in less than one minute using any packages in python.
>

You can probably build it progressively, row by row. That way, you
shouldn't need to keep everything in memory at once. But beyond that,
I can't say without seeing your code.

ChrisA



More information about the Python-list mailing list