# -*- coding: UTF-8 -*-
import xlrd
import xlwt
#只能读不能写
openexcel = xlrd.open_workbook('11.xlsx')#打开一个excel
sheet = openexcel.sheet_by_index(0)#根据顺序获取sheet
#sheet2 = book.sheet_by_name('1')#根据sheet页名字获取sheet
#print(sheet.ncols)#获取excel里面有多少列
#print(sheet.nrows)#获取excel里面有多少行
#print(sheet.get_rows())#
#for i in sheet.get_rows():#0,1,2.3列
# print(i)#获取每一行的数据
#print(sheet.row_values(0))#获取第一行
newsheet=[]
for i in range(sheet.nrows):#0 1 2 3 4 5行
newsheet.append(sheet.row_values(i))#获取第几行的数据
#print(sheet.col_values(1))#取第一列的数据
#for i in range(sheet.ncols):
#print(sheet.col_values(i))#获取第几列的数据
sheetlie=[]
for i in range(sheet.ncols):
sheetlie.append(sheet.col_values(i))
print(newsheet)
sheetlie2 = (sheetlie[1])
del sheetlie2[0]
print(sheetlie2)
for i in range (0,len(sheetlie2)):
'Liebiao '+ i = list()
path = 'ceshi.xls'
sheet_name = '1'
value = newsheet
print(newsheet[1])
转载于:https://www.cnblogs.com/zhujunsheng/p/10845561.html