Skip to content
GitLab
Projects Groups Topics Snippets
  • /
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Register
  • Sign in
  • O openpyxl
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributor statistics
    • Graph
    • Compare revisions
  • Issues 283
    • Issues 283
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 7
    • Merge requests 7
  • 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
  • openpyxl
  • openpyxl
  • Issues
  • #1360
Closed
Open
Issue created Oct 30, 2019 by Bitbucket Importer@bitbucket_importerOwner

Unable to load workbook with charts (<TypeError: expected <class 'openpyxl.chart.axis.NumericAxis'>)

Created originally on Bitbucket by M'Beth Schoenfeld

Trying to open an excel sheet with the following python code:

import openpyxl
wb=openpyxl.load_workbook('PHPP_V9.6a_EN_Pathfinder_SI_tester.xlsx')
print("sucess")

here is the error I get:

Traceback (most recent call last):
File "C:\Users\ESchoenfeld\Desktop\PHPP Pathfinder\PHPP_excel_test.py", line 2, in
wb=openpyxl.load_workbook('PHPP_V9.6a_EN_Pathfinder_SI_tester.xlsx')
File "build\bdist.win-amd64\egg\openpyxl\reader\excel.py", line 312, in load_workbook
File "build\bdist.win-amd64\egg\openpyxl\reader\excel.py", line 274, in read
File "build\bdist.win-amd64\egg\openpyxl\reader\excel.py", line 249, in read_worksheets
File "build\bdist.win-amd64\egg\openpyxl\reader\drawings.py", line 38, in find_images
File "build\bdist.win-amd64\egg\openpyxl\packaging\relationship.py", line 161, in get_rel
File "build\bdist.win-amd64\egg\openpyxl\descriptors\serialisable.py", line 88, in from_tree
File "build\bdist.win-amd64\egg\openpyxl\descriptors\serialisable.py", line 88, in from_tree
File "build\bdist.win-amd64\egg\openpyxl\chart\plotarea.py", line 151, in from_tree
File "build\bdist.win-amd64\egg\openpyxl\descriptors\base.py", line 44, in set
TypeError: expected <class 'openpyxl.chart.axis.NumericAxis'>

I’ve tried deleting all the charts from the workbook, but it doesn’t seem to make a difference, what am I missing?

‌

‌

Attachments: PHPP_V9.6a_EN_Pathfinder_SI_tester.xlsx

Edited Aug 22, 2022 by CharlieC
To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information
Assignee
Assign to
Time tracking