import xlrd
import xlwt

# 打开excel文件,获取工作簿对象
wb = xlrd.open_workbook('normal.xlsx')

# 创建写入excel文件,
workbook = xlwt.Workbook(encoding = 'utf8')
# 单页写入255条 多余的分页
worksheet = workbook.add_sheet('My Worksheet')
staticNumber = -1

# 获取指定的表单
sheet3 = wb.sheet_by_name('Sheet1')
# 获取A列单元格中的值内容

titleArray = sheet3.col_values(0)[1:]
colArray   = sheet3.col_values(1)[1:]