python将png格式图片转换成bmp图片,并把图片添加到excel表中

 

import xlwt
import fnmatch
import os
import pandas as pd
import numpy as np
import sys
import cv2

# 创建函数,将png图片转换成bmp格式图片,stra代表路径,strb代表图片
def ReadSaveAddr1(Stra, Strb):
    print("Read :", Stra,Strb)
    a_list = fnmatch.filter(os.listdir(Stra), Strb)
    df = pd.DataFrame(np.arange(len(a_list)).reshape((len(a_list), 1)), columns=['Addr'])
    df.Addr = a_list
    for i in range(len(a_list)):
        path = Stra + '/' + a_list[i]
        img = cv2.imread(path, cv2.IMREAD_GRAYSCALE)
        t = a_list[i]
        t = t[:-4]
        t = './province_gray_BMP/' + t + '.bmp'
        cv2.imwrite(t, img)


wb = xlwt.Workbook()                            #创建excel表
ws = wb.add_sheet("Image")                    #创建sheet1并命名为Image
path = 'G:/PythonTest/view'
imagebmp1 = ReadSaveAddr1(path,"*.png")      #输入路径和图片
ws.insert_bitmap("Image1.bmp",0,0)
wb.save("Image.xls")