xlsx generation with charts, images, automated column width, customizable styles and full schema validation. Axlsx excels at helping you generate beautiful Office Open XML Spreadsheet documents without having to understand the entire ECMA specification. Check out the README for some examples of how easy it is. Best of all, you can validate your xlsx file before serialization so you know for sure that anything generated is going to load on your client's machine.
we're using Axlsx for generating rather large sheets (> 20k rows; > 50 columns).
I think that there could be some quick wins by by applying # frozen_string_literal: true to the CellSerializer class and adjust some of its methods to not modify frozen strings.
Some local profiling showed that this could safe ~1.000.000 object allocations for big sheets.
What do you think about it? If you're open to that, I could prepare a PR.
Hi,
we're using
Axlsxfor generating rather large sheets (> 20k rows; > 50 columns).I think that there could be some quick wins by by applying
# frozen_string_literal: trueto theCellSerializerclass and adjust some of its methods to not modify frozen strings.Some local profiling showed that this could safe ~1.000.000 object allocations for big sheets.
What do you think about it? If you're open to that, I could prepare a PR.
Best Alex