holgerbrandl / krangl

krangl is a {K}otlin DSL for data w{rangl}ing
MIT License
560 stars 50 forks source link

Use SXSSFWorkbook for writing excel files for better support of large… #126

Closed ayvazj closed 3 years ago

ayvazj commented 3 years ago

… datasets

With these changes I can write DataFrames with 200+K rows. Before these changes my machine would run out of memory.

holgerbrandl commented 3 years ago

Thanks @ayvazj a ton for this great patch.

Is a similar approach applicable when reading excel-sheets?