Pandas version checks

  • [X] I have checked that this issue has not already been reported.

  • [X] I have confirmed this bug exists on the latest version of pandas.

  • [X] I have confirmed this bug exists on the main branch of pandas.

Reproducible Example

df = pd.read_excel(self.file_path, sheet_name=self.sheet_name, header=None)

Issue Description

Use XlsxWriter to create an XLSX file that a user can fill out and re-upload. However, if the user enter data or even if I just try to read the Excel file without ever opening it in Excel, it gives this error: "Colors must be aRGB hex values".

I just pip installed the latest pandas to see if that corrected it and it did not.

Expected Behavior

Pandas can read XlsxWriter created file.

Installed Versions

pandas==1.5.3 XlsxWriter==3.0.9 Python= 3.10

Comment From: acknowledgeHim

found an issue in the xml, not pandas related