Out of memory while reading excel file

Mahmood Naderan nt_mahmood at yahoo.com
Thu May 11 04:50:58 EDT 2017


Thanks. That code is so simple and works. However, there are things to be considered. With the CSV format, cells in a row are separated by ',' and for some cells it writes "" around the cell content.

So, if the excel looks like 


CHR1      11,232,445


The output file looks like

CHR1,"11,232,445"


Is it possible to use <space> as the delimiting character and omit ""? I say that because, my java code which has to read the output file has to do some extra works (using space as delimiter is the default and much easier to work). I want

a[0][0] = CHR
a[0][1] = 11,232,445

And both are strings. Is that possible?
 
Regards,
Mahmood



More information about the Python-list mailing list