PyExcelerate issues

Question about optimizing cell merge

2

Hi there, thanks for your great work! I got a large dataframe 30*10000 for example, and about 100 groups for each column to merge. Like ```python for i in range(30):...

winterfell2021

Large dataframes containing strings generate invalid xlsx files

15

For large dataframes containing strings with 500k rows and 60+ columns, pyexcelerate generates invalid .xlsx files that cannot be opened in Excel. Excel gives the error message: "We found a...

EdGaere

pyexcelerate consumes lot of memory when huge data needs to be written

11

I have a business need where I have huge data , more than 3 lac rows per worksheet. Writing to xlsx file using pyexcelerate is very fast , but it...

Anuradha-26

Replaced Part: /xl/worksheets/sheet1.xml part with XML error. A document must contain exactly one root element. Line 1, column 0.

6

![L_FB55 tmp](https://user-images.githubusercontent.com/19677928/96452198-44242a00-124b-11eb-8d7a-c82273eaf551.png) Here is my code when using PyExcelerate ```python from pyexcelerate import Workbook def to_excel(df, path, sheet_name="Documents"): data = [ df.columns.tolist(), ] + df.values.tolist() wb = Workbook() wb.new_sheet(sheet_name, data=data)...

amzar96

performance when serializing pandas DataFrames

11

the function __get_cell_data (https://github.com/kz26/PyExcelerate/blob/dev/pyexcelerate/Worksheet.py#L227) operates on each cell individually. when serializing a pandas.DataFrame, most of the time, the columns are of a unique type (dtype) and could benefit from some...

sdementen

When I use openpyxl to read the xlsx file generated by pyexcelerate, openpyxl prompts "Workbook contains no default style"?

5

I save the same file as another file with excel, and then it can be read with openpyxl, so I suspect that there is a problem with the pyexcelerate export...

TibbersGo

Handling NaN values

10

Thank you for this great project! Would it be better to replace NaN values with empty string instead of #NUM! ?

ghost

Cannot save large file .xlsx - ZipFile raise Exception('File size unexpectedly exceeded ZIP64 limit'

1

After inspect code ZipFile could handle large file if param "force_zip64" ( zipfile.py:open() ) was set to True. From API of PyExcelerate I cannot set this param. Could you add...

wciurzynski