On Thu, Jul 14, 2016 at 7:29 AM, vineeth menneni <vineethmennen...@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 -- https://mail.python.org/mailman/listinfo/python-list