Python中的Excel表数据导入功能

import xlrd
import xlwt

rd = xlrd.open_workbook("data.xls")       #获取excel表
rdsheet1Index = rd.sheet_by_index(0)      # 获取sheet1的索引
rdsheet1name = rdsheet1Index.name  # 获取sheet1的名称
rdsheet1rowname = rdsheet1Index.nrows  # 获取行数

number = 0
num = []
while number < rdsheet1rowname:
    num.append(rdsheet1Index.row_values(number))
    number = number + 1

wb = xlwt.Workbook()              #创建excel表
ws = wb.add_sheet(rdsheet1name)   #填写sheet1的名称
                                  #将sheet1的数据全部填入到sheet1中
for i, item in enumerate(num):
    for j, val in enumerate(item):
        ws.write(i, j, val)
        
wb.save("cesi.xls")