I am trying to import largish Excel files (~2MB) that are generated by an analysis program that we run. I am running into an issue where the open operation is exhausting the memory on my computer (I start with about 8 GiB free).
I have tried both Roo and the underlying Spreadsheet gem. Has anyone had any luck opening larger files?
Turns out the issue was really with irb:
https://github.com/zdavatz/spreadsheet/issues/8
Seems to work fine from scripts.
I am trying to import largish Excel files (~2MB) that are generated by an analysis program that we run. I am running into an issue where the open operation is exhausting the memory on my computer (I start with about 8 GiB free).
I have tried both Roo and the underlying Spreadsheet gem. Has anyone had any luck opening larger files?