Kevin Wang

It should be `auto_filters`, not `auto_filter`.

Ah I actually misspoke, it should be `auto_filter`, however we haven't pushed that code out yet. I guess we should do that since it's been a while. Glad you're finding...

Hey @vaebhav thanks for the offer! I believe the gist of the problem is PyExcelerate doesn't generate cell data for rows with no data (intentionally) here: https://github.com/kz26/PyExcelerate/blob/dev/pyexcelerate/Worksheet.py#L352 This doesn't work...

You can try compressing the xlsx file with an alternate compression algorithm. We use ZIP_DEFLATED but ZIP_LZMA might give you better results at a performance penalty. If you do find...

You will need to modify the constant here: https://github.com/kz26/PyExcelerate/blob/247406dc41adc7e94542bcbf04589f1e5fdf8c51/pyexcelerate/Writer.py#L45

Yes this is partially an optimization. When we were implementing it, we found that building that table was nontrivially expensive for large sheets, so we opted to ignore it hoping...

Thank you for your contribution! For a little more context, what's the motivation for this method instead of requiring the user to explicitly iterate over the range?

Can you link to some discussions that this is something pandas users are hitting? I would like to see use cases where users are directly exporting data (ie not touching...

> If what you mean is that the user does not export directly a data frame to excel but writes it to excel and then modify the excel before saving,...

I am not too keen on adding pandas-specific functionality because PyExcelerate isn't an officially supported engine. Ultimately PyExcelerate is used a lot outside pandas as well, and integrating pandas is...