Excel Error when using pandas and openpyxl: Repaired Part: /xl/worksheets/sheet1.xml part with XML error. HRESULT 0x8000ffff Line 1, column 0

0

I'm coming up with an error of opening up an excel file after writing to it. This is what I have so far:

#locate source document
Path = Path(r'C:\Users\username\Test\EXCEL_Test.xlsx')

# open doc and go to active sheet
wb = load_workbook(filename = Path)
ws = wb.active


#add drop down list to each cell in a certain column
dv_v = DataValidation(type="list", formula1='"Y,N"', allow_blank=True)
    for cell in ws['D']:
        cell = ws.add_data_validation(dv_v)
wb.save(Path)

And these are the two errors that comes up on opening the excel file:

First error popup: "We found a problem with some content in 'EXCEL_Test.xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes."

Second error popup: "Repaired Part: /xl/worksheets/sheet1.xml part with XML error. HRESULT 0x8000ffff Line 1, column 0."

My data validation is not showing up, and the file has the above errors when attempting to open the file to view the openpyxl changes.

Maybe if someone can help me find out why these errors are popping up? Python finishes with exit code 0, and why the data validation is coming up as blanks in the recovered file?

python
excel
pandas
openpyxl
asked on Stack Overflow Aug 3, 2020 by Gunter Herd

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0