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