title: How to write big set of data to xls file?
body: <p>I have really big database which I want write to <strong>xlsx/xls</strong> file. I already tried to use <strong>xlwt</strong>, but it allows to write only 65536 rows (some of my tables have more than 72k rows). I also found <strong>openpyxl</strong>, but it works too slow, and use huge amount of memory for big spreadsheets. Are there any other possibilities to write excel files?</p>
  
  <p>edit:
  Following kennym's advice i used Optimised Reader and Writer. It is less memory consuming now, but still time consuming. Exporting takes more than hour now (for really big tables- up to 10^6 rows). Are there any other possibilities?  Maybe it is possible to export whole table from <strong>HDF5 database</strong> file to <strong>excel</strong>, instead of doing it <strong>row after row</strong>- like it is now in my code?</p>