Skip to content

GitLab

  • Menu
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 235
    • Issues 235
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 3
    • Merge requests 3
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Monitor
    • Monitor
    • Incidents
  • Packages & Registries
    • Packages & Registries
    • Container Registry
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Repository
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar
  • openpyxl
  • openpyxl
  • Issues
  • #1577

Closed
Open
Created Dec 27, 2020 by barbalion@barbalion

Read-only workbook is not serializable

A workbook being loaded with read_only=True cannot be serialized by pickler (pickle.dump()). This breaks the parallel processing of the books data.

to reproduce:

book = openpyxl.load_workbook('filename.xlsx', read_only=True, data_only=True)
with open('dump.bin', 'wb') as f:
  pickle.dump(book, f)

Results with the exception: TypeError: cannot pickle '_io.BufferedReader' object

The 'regular' book (without read_only flag) works fine.

Edited Dec 27, 2020 by barbalion
To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information
Assignee
Assign to
Time tracking