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")