Now some cells in spreadsheet has background color and want to get the background color too.
My actual plan is read the cell info along with background color and then display the cell data along with background color in html web page .
I am able to display the info but could not able to get the background color property.
Could you please help me in this regard?
- Code: Select all
wb = openpyxl.load_workbook(filename = r'empty.xlsx')
sheet_ranges = wb['range']