Re: problem writing excel sheet using python

2016-07-14 Thread Mirage Web Studio
On July 14, 2016 2:59:09 AM GMT+05:30, vineeth menneni 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 term

Re: problem writing excel sheet using python

2016-07-13 Thread vineeth menneni
The belwo is the code, I have also tried writing it row by row with xlsxwrites passing argument constant_memory:True. I donot know if my looping code is ineffective. for req_param in request.GET.get("Req-Tables").split(","): sheet_names.append(req_param) title.append(req_p

Re: problem writing excel sheet using python

2016-07-13 Thread Lawrence D’Oliveiro
On Thursday, July 14, 2016 at 9:29:23 AM UTC+12, vineeth menneni wrote: > > .. I am finding it difficult to create a excel sheet using openpyxl or > xlsxwriter. How about writing ODF using odfpy instead? Microsoft Office is supposed to be ISO-26300-compliant, isn’t

Re: problem writing excel sheet using python

2016-07-13 Thread Chris Angelico
On Thu, Jul 14, 2016 at 7:29 AM, vineeth menneni 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 > termin

problem writing excel sheet using python

2016-07-13 Thread vineeth menneni
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 po