python3 excel文件的读与写

时间：2023-03-09 16:45:27
python3 excel文件的读与写 
 from openpyxl import load_workbook

 class RwExcelFile:

     def read_Excel(self,file_path):

         '''

         读取excel中所有数据并以列表形式返回

         :param file_path:

         :return:

         '''

         excel_File = load_workbook(file_path)

         sheet_names = excel_File.sheetnames

         list_column = []

         list_row    = []

         list_sheet  = []

         for i in sheet_names:

             excel_File_sheet=excel_File[i]

             for j in range(1,excel_File_sheet.max_row+1):

                 for k in range(1,excel_File_sheet.max_column+1):

                     list_column.append(excel_File_sheet.cell(j,k).value)

                 list_row.append(list_column)

                 list_column = []

             list_sheet.append(list_row)

             list_row = []

         excel_File.close()

         return list_sheet

     def write_Excel(self,file_path,sheetname,row,cloumn,T_value):

         '''

         向excel指定位置写入值

         :param file_path: 文件地址

         :param sheetname: sheet名

         :param row: 行

         :param cloumn:列

         :param T_value: 值

         :return: 无返回

         '''

         excel_File = load_workbook(file_path)

         excel_File[sheetname].cell(row,cloumn,T_value)

         excel_File.save(file_path)

         excel_File.close()

相关文章