search

tealeg / xlsx

Go library for reading and writing XLSX files.
Other
5.81k stars 810 forks source link

OpenFile hangs while reading a StarCalc spreadsheet #728

Closed rbucker closed 2 years ago

rbucker commented 2 years ago

I recognize this is a longshot. I do not even know how to generate one of these files... but a friend asked me to convert one to CSV from XLSX but it used all RAM and all SWAP.... I would share the file if I could but I cannot. So let this be a placeholder for someone who might.

THANKS

tealeg commented 2 years ago

@rbucker high memory usage is a fairly common complaint, there is essentially one course of action you can try: pass xlsx.UseDiskVCellStore as the final parameter to OpenFIle.

Beyond that, the issue is fairly fundamental to the design of this library and is one of the key reasons it is no longer actively maintained.