problem writing excel sheet using python

Mirage Web Studio miragewebstudio12 at gmail.com
Thu Jul 14 04:54:02 EDT 2016



On July 14, 2016 2:59:09 AM GMT+05:30, 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. 
>
>Thanks,
>Vineeth
>-- 
>https://mail.python.org/mailman/listinfo/python-list


Try saving data in csv format an then import it in excel 

George 


More information about the Python-list mailing list