'read an excel file with Openpyxl
I have a python code to download an excel file, but when I try to open it through the use of this code, it gives me the following error (*ValueError: Colors must be aRGB hex values *). What's weird is when I save it in another excel file it works fine.
if resp.status_code==200:
resp.raw.decode_content=True
with open("file_excel.xlsx",'wb') as f:
shutil.copyfileobj(resp.raw,f)
wb = openpyxl.load_workbook('file_excel.xlsx')
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
