Python2(2):Python之读取Excel例子
#!/usr/bin/env python
# -*- coding: utf-8 -*-
# author:Meifen
# 基础包:excel读取数据的封装
import xlrd
class readData():
def __init__(self, path):
self.path = path
def getSheet(self):
# 获取sheet索引(0代表第1个sheet)
data = xlrd.open_workbook(self.path)
sheet = data.sheet_by_index(0)
# sheet=data.sheets()[0]
return sheet
def getRows(self):
# 获取行数
row = self.getSheet().nrows
return row
def getCols(self):
# 获取列数
col = self.getSheet().ncols
return col
# 以下是分别获取每1列的数值
def getmediaName(self):
MediaName = []
for i in range(0, self.getRows()):
MediaName.append(self.getSheet().cell_value(i, 3))
return MediaName
def getmediaName_zhiwen(self):
MediaName = []
for i in range(0, self.getRows()):
MediaName.append(self.getSheet().cell_value(i, 2))
return MediaName
"""
def getValues(self): #每个数都取出来放入列表
Values=[]
for i in range(1, self.getRows()):
for j in range(0,self.getCols()):
cellValue=""
cellValue=self.getSheet().cell_value(i,j)
if j == 0:
cellValue=int(cellValue)
Values.append(cellValue) #每个数都取出来放入列表
return Values
"""
def getRowsValue(self): #这个也可以,但如果有整型数据会变成浮点型
sheetValue=[]
rowValues=[]
for i in range(0, self.getRows()):
rowValues= self.getSheet().row_values(i) #某一行数据
sheetValue.append(rowValues) #每行都存成列表
return sheetValue