I am working on requirement on spreadsheet in python scripting.
I have a spreadsheet containing cell values and with background color.
I am able to read the value value but unable to get the background color of that particular cell.
Actually my requirement is to read the cell value along with the background color and display the same in html table.
Here I am able to display the cell value but not with background color.
Could you please suggest the required library which suits my requiremnet with some example code.
import openpyxl
wb = openpyxl.load_workbook(filename = r'empty.xlsx')
sheet_ranges = wb['range']
print sheet_ranges['D18'].value