# -*- coding: utf-8 -*-
import xlrd
file_path = r"/Users/****/Desktop/*****.xlsx"
file_path = file_path.decode('utf-8')
data = xlrd.open_workbook(file_path)
sheet_path = "工作表1"
sheet_path = sheet_path.decode('utf-8')
table = data.sheet_by_name(sheet_path)
nrows = table.nrows
ncols = table.ncols
eventStr = table.col_values(4)
event = table.col_values(5)
info = table.col_values(6)
# info1 = table.col_values(7)
print(eventStr)
print(event)
print(info)
File = open("eventhandle.h", "a+")
File.write(""+"\n")
for index,value in enumerate(event):
infoSSS = eventStr[index]
File.write('// ' + infoSSS.encode("utf8") + "\n")
File.write("#define ProXcodeEvent" + value.encode("utf8") + " " + '@"' + value.encode("utf8") + '"' + "\n")
File.write(" " + "\r\n")
File.close()