Closed juweya closed 2 years ago
Repetitive call of function ws.cell is time consuming according to https://blog.dchidell.com/2019/06/24/openpyxl-poor-performance-optimisation/. Proposed solution was taken from there as well reducing the reading time of the impact categories in repo bw_recipe_2016 from 5+ hours to a few minutes.
Repetitive call of function ws.cell is time consuming according to https://blog.dchidell.com/2019/06/24/openpyxl-poor-performance-optimisation/. Proposed solution was taken from there as well reducing the reading time of the impact categories in repo bw_recipe_2016 from 5+ hours to a few minutes.