python3 excel文件的读与写
1 from openpyxl import load_workbook 2 class RwExcelFile: 3 4 def read_Excel(self,file_path): 5 ''' 6 读取excel中所有数据并以列表形式返回 7 :param file_path: 8 :return: 9 ''' 10 excel_File = load_workbook(file_path) 11 sheet_names = excel_File.sheetnames 12 list_column = [] 13 list_row = [] 14 list_sheet = [] 15 for i in sheet_names: 16 excel_File_sheet=excel_File[i] 17 for j in range(1,excel_File_sheet.max_row+1): 18 for k in range(1,excel_File_sheet.max_column+1): 19 list_column.append(excel_File_sheet.cell(j,k).value) 20 list_row.append(list_column) 21 list_column = [] 22 list_sheet.append(list_row) 23 list_row = [] 24 excel_File.close() 25 return list_sheet 26 27 def write_Excel(self,file_path,sheetname,row,cloumn,T_value): 28 ''' 29 向excel指定位置写入值 30 :param file_path: 文件地址 31 :param sheetname: sheet名 32 :param row: 行 33 :param cloumn:列 34 :param T_value: 值 35 :return: 无返回 36 ''' 37 excel_File = load_workbook(file_path) 38 excel_File[sheetname].cell(row,cloumn,T_value) 39 excel_File.save(file_path) 40 excel_File.close()