Skip to content
GitLab
Projects Groups Snippets
  • /
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in / Register
  • O openpyxl
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 243
    • Issues 243
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 5
    • Merge requests 5
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Packages and registries
    • Packages and registries
    • Container Registry
  • Monitor
    • Monitor
    • Incidents
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Repository
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar

April 05-07 - Mercurial Paris Conference 2023 - One day of workshop dedicated to Heptapod and Mercurial usage and workflow. There are still places available for both workshops and talks!

  • openpyxl
  • openpyxl
  • Merge requests
  • !342

Drastically increase performance on deleting large amounts of rows/cols

  • Review changes

  • Download
  • Email patches
  • Plain diff
Merged Bitbucket Importer requested to merge bitbucket/merged-pr-342 into branch/2.6 Jun 21, 2019
  • Overview 0
  • Commits 2
  • Pipelines 0
  • Changes 1

Created originally on Bitbucket by René Neumann

Was already merged in Bitbucket before import, marked as merged by the import user

Drastically increase performance on deleting large amounts of rows.

Currently, min and max column are calculated once for each row to be deleted. And this calculation needs to iterate over every cell. Deleting lots of rows (say 19k of 75k rows in total) thus can take hours (sic!). After this patch, a couple seconds are sufficient.

(This is a redo of pull request #341 (closed), because I couldn’t update that one to use the correct branch)

Assignee
Assign to
Reviewers
Request review from
Time tracking
Source branch: bitbucket/merged-pr-342