Fails due to missing `calcPr` property. - Githubissues

dgorissen / pycel

A library for compiling excel spreadsheets to python code & visualizing them as a graph

GNU General Public License v3.0

570 stars 149 forks source link

Fails due to missing `calcPr` property. #88

Closed andreif closed 4 years ago

andreif commented 4 years ago

What actually happened

  File "/Users/andrei/parsers/xlsx.py", line 141, in _load_pycel_workbook
    return ExcelCompiler(filename)
  File "/Users/andrei/venv/lib/python3.8/site-packages/pycel/excelcompiler.py", line 95, in __init__
    wb_cycles = bool(self.excel.workbook.calculation.iterate)
AttributeError: 'NoneType' object has no attribute 'iterate'

What was expected to happen

It should work.

Problem description

When a workbook package is missing calcPr property then ExcelCompiler is failing to process the document.