python操作excel

import math
import xlsxwriter
import xlrd
import xlwt
import calendar
import datetime
import os
import time
import sys
from openpyxl import Workbook
import calendar
import xlsxwriter
from datetime import date, timedelta
from xlrd import xldate_as_tuple
from xlrd import xldate_as_datetime

#读


def reads():
    file_path = r'' + qingjia + '.xlsx'
    data = xlrd.open_workbook(file_path)
    table = data.sheet_by_index(0)
    nrows = table.nrows
    for i in range(1, nrows):
        # 获取一行的数值，例如第5行
        rowvalue = table.row_values(i)


#写
workbook = xlsxwriter.Workbook('关爱通.xlsx')  # 创建一个Excel文件
cell_format = workbook.add_format()
cell_format.set_bg_color("#DB7093")
worksheet = create_title_row(workbook)
for iwrite, ivalue in enumerate(all_list):
    for index, value in enumerate(ivalue):
        try:
            if "red" in value:
                worksheet.write(iwrite + 1, index - 1, "", cell_format)
            elif "blue" in value:
                worksheet.write(iwrite + 1, index, "")
            else:
                worksheet.write(iwrite + 1, index, value)
        except:
            worksheet.write(iwrite + 1, index, value)
workbook.close()