ecohealthalliance / eidith-cleaning-reports

0 stars 2 forks source link

Speed up xlsx writing #1

Closed noamross closed 5 years ago

noamross commented 5 years ago

1) Change styles to be one per color, rather than one per styled cell 2) Use a modified version of openxlsx which uses stringi rather than base functions (https://github.com/noamross/openxlsx/commit/d7f7f6fc2e61c80bb4a377c526728ad6c57c255b) 3) Reset the build cache by incrementing the cache name so that new packages install

Local total build time down to a little more than 3 minutes on my machine now