利用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)