Opening gnumeric with pandas lib

Question

I tried to run a simple xlsx file and open it with gnumeric.

The code:

python
import pandas as pd

df = pd.DataFrame({'Data': [10, 20, 30, 20, 15, 30, 45]})
writer = pd.ExcelWriter('pandas_simple.xlsx', engine='xlsxwriter')
df.to_excel(writer, sheet_name='Sheet1')
writer.save()

The code runs correctly and indeed when I open it via Excel I am able to see the data. On the other hand, when opening with gnumeric, it fails with message:

Unsupported file format.

I did try to open an xlsx file not from the Python and gnumeric opened it correctly.

I don't know where the problem could be.

On an other note, is there another way to save a multiple sheet gnumeric file from Python without using pandas ExcelWriter?

Answer 1

XlsxWriter files should work without any issue in Gnumeric. They are essentially 100% the same as Excel files.

I ran your sample code and was able to open the file in Gnumeric:

Versions:

• gnumeric: 1.12.35
• xlsxwriter: 1.2.8
• os: ubuntu 18.04