import xlrd from xlutils.copy import copy class ExcelUtil(object): def __init__(self, excel_path=None, index=None): if excel_path == None: excel_path = r"D:\PycharmProjects\2020study\config\keyword.xls" if index == None: index = 0 self.data = xlrd.open_workbook(excel_path) self.table = self.data.sheets()[index] # 行数 # self.rows = self.table.nrows #[[],[],[]] # 获取excel数据按照每一行一个lisit添加到 def get_data(self): result = [] rows = self.get_lines() if rows !=None: for i in range(rows): col = self.table.row_values(i) result.append(col) return result return None # 获取行 def get_lines(self): rows = self.table.nrows if rows >= 1: return rows return None # 获取单元格 def get_col_value(self, row, cell): if self.get_lines() > row: data = self.table.cell(row, cell).value return data return None # 写入数据 def write_value(self, row, value): read_value = self.data write_data = copy(read_value) write_data.get_sheet(0).write(row, 6, value) write_data.save(r"D:\PycharmProjects\2020study\config\keyword.xls") if __name__ == '__main__': ec = ExcelUtil() print(ec.get_data()) print(ec.get_col_value(3, 2)) print(ec.write_value(6, "test"))
python使用xlrd模块读写excel文件
最新推荐文章于 2024-08-26 22:58:59 发布