Rossum CLI ImportError: cannot import name 'save_virtual_workbook' from openpyxl

TL;DR

For "ImportError: cannot import name 'savevirtualworkbook' from 'openpyxl.writer.excel'": the savevirtualworkbook helper was removed in openpyxl 3.1, and the Rossum CLI code still imported it, so any install with openpyxl >= 3.1 crashed on the export path. Pin openpyxl to a version that still has savevirtualworkbook: pip install openpyxl==3.0.10.

ImportError: cannot import name 'save_virtual_workbook' from 'openpyxl.writer.excel'

Steps

1. Running the Rossum CLI failed with "ImportError: cannot import name 'savevirtualworkbook' from 'openpyxl.writer.excel'". The savevirtualworkbook helper was removed in openpyxl 3.1, and the Rossum CLI code still imported it, so any install with openpyxl >= 3.1 crashed on the export path. The reporter confirmed the error disappeared after downgrading, and a second user confirmed the same workaround.
2. Pin openpyxl to a version that still has savevirtualworkbook: pip install openpyxl==3.0.10. The reporter confirmed the error disappeared after downgrading, and a second user confirmed the same fix for XLS exports. Longer term, the Rossum CLI needs to stop importing the removed helper (a code upgrade for openpyxl 3.1+). Source: https://github.com/rossumai/rossum/issues/42

When to use

You are seeing this: Running the Rossum CLI failed with "ImportError: cannot import name 'savevirtualworkbook' from 'openpyxl.writer.excel'". Use this skill when you run into "Rossum CLI ImportError: cannot import name 'savevirtualworkbook' from openpyxl".

When not to use

If your error message or symptom does not match what is described above, this is probably not your fix. Search for your exact error text instead of forcing this one to fit.

Versions

Versions mentioned in the source: openpyxl 3.0.10. If you are on something much newer or older, the details may have shifted.

Why this happens

The original report does not dig into a root cause. It documents the symptom and the fix that resolved it.

Sources

• https://github.com/rossumai/rossum/issues/42

Question asked in the thread: Running the Rossum CLI failed with "ImportError: cannot import name 'savevirtualworkbook' from 'openpyxl.writer.excel'". The savevirtualworkbook helper was removed in openpyxl 3.1, and the Rossum CLI code still imported it, so any install with openpyxl >= 3.1 crashed on the export path. The reporter confirmed the error disappeared after downgrading, and a second user confirmed the same workaround.

Verified answer: Pin openpyxl to a version that still has savevirtualworkbook: pip install openpyxl==3.0.10. The reporter confirmed the error disappeared after downgrading, and a second user confirmed the same fix for XLS exports. Longer term, the Rossum CLI needs to stop importing the removed helper (a code upgrade for openpyxl 3.1+). Source: https://github.com/rossumai/rossum/issues/42

Thread: https://vectle.com/threads/thr_R2B8YeSL2jVhJEzAZYdINQ