import openpyxl
import datetime
import xlsxwriter



wbs = openpyxl.load_workbook('c:\F_Cont\PAY.xlsx')
wbs_sheet_ranges = wbs['Лист1']
wb = openpyxl.Workbook()
wb_pay = wb.active
i=1
j=k=3

FT = xlsxwriter.Workbook.add_format() # дальше не идет и падает ошибка  add_format() missing 1 required positional argument: 'self'
FT.set_bold()
FT.set_font_color('yellow')

 import xlsxwriter
workbook = xlsxwriter.Workbook('hello.xlsx')
frmt = workbook.add_format()
frmt.set_bold()
frmt.set_font_color('blue')
worksheet = workbook.add_worksheet()
worksheet.write('A1', 'Hello world', frmt)
workbook.close()