When adding styles to a large number of cells, calling new Style() each time to check if the style exists is slow. Instead, the stringified style options are used as the lookup key before calling new Style().
For my use case, I had 35000+ rows, which 10 columns each. This optimization sped up generation by 30-40%.
When adding styles to a large number of cells, calling
new Style()
each time to check if the style exists is slow. Instead, the stringified style options are used as the lookup key before callingnew Style()
.For my use case, I had 35000+ rows, which 10 columns each. This optimization sped up generation by 30-40%.
Ran tests and all passed.