利用Python进行图片对Excel的批量导入

利用Excel的Unicode粘贴 选取图片组的大小

选取不同的起点并直接放入粘贴板 

在Excel中直接粘贴即可批量导入

 

# coding=utf-8
import os
import win32clipboard as w
import win32con
FileName = os.listdir()
Front = input("请输入前置文件名：")
Num = int(input("请输入文件数目："))
End = input("请输入扩展名：")
FilePosition = os.getcwd()
def settext(aString):
    w.OpenClipboard()
    w.EmptyClipboard()
    w.SetClipboardData(win32con.CF_UNICODETEXT, aString)
    w.CloseClipboard()
while 1 == 1:
    Start = input("请输入起始编号：")
    Name=Front+Start+'.'+End
    position = FileName.index(Name)
    
    Text=''
    for i in range(Num):
    	Name=FileName[i+position]
	
    	Long=FilePosition+'\\'+Name
    	Super='<table><img src=\''+Long+'\'width=\'300\' height=\'200\'>'
    	Text = Text+Super+'\n'
    settext(Text)
    print(Text)