python读取excel 文件

 python操作excel文件并获取特定单元格的内容：

#coding:utf-8
import xlrd
# data = xlrd.open_workbook('../dataconfig/interface.xlsx')
# tables = data.sheets()[0]
# print tables.nrows
# print tables.cell_value(2,3)

class OperationExcel:
	def __init__(self,file_name=None,sheet_id=None):
		if file_name:
			self.file_name = file_name
			self.sheet_id = sheet_id
		else:
			self.file_name = '../dataconfig/interface.xlsx'
			self.sheet_id = 0

		self.data = self.get_data()


	def get_data(self):
		data = xlrd.open_workbook(self.file_name)
		tables = data.sheets()[self.sheet_id]
		return tables

	def get_lines(self):
		tables = self.data
		return tables.nrows

	def get_cell_value(self,row,col):
		return self.data.cell_value(row,col)

if __name__ == '__main__':
	opres = OperationExcel()
	print opres.get_data().nrows
	print opres.get_lines()
	print opres.get_cell_value(1,1)

 

转载于:https://my.oschina.net/donngchao/blog/3083308