Python 读取Excel文件创建Xcode类 小demo

# -*- 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()