Skip to content

Deferred loading of openpyxl.worksheet.datavalidation.DataValidation.cells

Bitbucket Importer requested to merge bitbucket/declined-pr-226 into branch/default

Created originally on Bitbucket by jusdino (Justin Frahm)

Changesets for this Pull Request have not been imported, because it had been already declined on Bitbucket. Marked as closed by the import user.

This change lets large workbooks with data validation set for entire columns to load in a reasonable amount of time. DataValidation.cells is not populated all at load_workbook. Instead, each DataValidation object only loads its cells when they are needed.

Related StackOverflow post:

https://stackoverflow.com/questions/48470434/openpyxl-how-to-troubleshoot-opening-a-workbook

Merge request reports