Python生成二维码代码

q490525427

import xlwings as xw
import os
import glob
import qrcode
src_dir = os.getcwd()
files_list = glob.glob('*.xlsm')
if not files_list:
    files_list = glob.glob('*.xlsm')
if not files_list:
    print("No Excel files found.")
    exit()
excelfilepath = files_list[-1]
app = xw.App(visible=False, add_book=False)
excelbook = app.books.open(excelfilepath)
sheet = excelbook.sheets[-1]
value = sheet.range(1, 1).expand('down').value
excelbook.close()
app.quit()
def generate_qrcode(text):
    img = qrcode.make(text)
    img.save(os.path.join(src_dir, text + '.png'))
for text in value:
    generate_qrcode(text)
html_list = []
for text in value:
    html_list.append('<table><img src="{}" height="90"></table>'.format(os.path.join(src_dir, str(text) + ".png")))
with open('barcode_html.txt', 'w', encoding='utf-8') as f:
    for i in html_list:
        f.write(i + '\n')

需要把生成TXT文档里面的代码，复制到表格里面

q490525427

本机IP地址查看及获取，包括IPV6
pip install pyperclip
pip install psutil

1. import tkinter as tk
   
2. from tkinter import ttk
   
3. import socket
   
4. import psutil
   
5. import pyperclip
   
6. import subprocess
   
7. from tkinter import messagebox
   
8. 
   
9. 
   
10. def get_network_info():
    
11.     """获取网络接口信息"""
    
12.     network_info = []
    
13.     addrs = psutil.net_if_addrs()
    
14.     net_stats = psutil.net_if_stats()
    
15.     seen_interfaces = set()
    
16. 
    
17.     for interface in addrs.keys():
    
18.         if net_stats[interface].isup and interface not in seen_interfaces:
    
19.             ipv4_address, mac_address = "Not Available", "Not Available"
    
20.             ipv6_addresses = []
    
21. 
    
22.             for addr in addrs[interface]:
    
23.                 if addr.family == socket.AF_INET:
    
24.                     ipv4_address = addr.address
    
25.                 elif addr.family == socket.AF_INET6:
    
26.                     if addr.address.startswith("fe80"):
    
27.                         ipv6_addresses.append(f"{addr.address} （内网可用）")
    
28.                     else:
    
29.                         ipv6_addresses.append(addr.address)
    
30.                 elif addr.family == psutil.AF_LINK:
    
31.                     mac_address = addr.address
    
32. 
    
33.             # 将收集到的信息添加到列表中
    
34.             for ipv6_addr in ipv6_addresses:
    
35.                 network_info.append([interface, ipv4_address, ipv6_addr, mac_address])
    
36.             seen_interfaces.add(interface)
    
37. 
    
38.     return network_info
    
39. 
    
40. 
    
41. def copy_selected_value(tree, item_id, column):
    
42.     """复制选中的值并弹出提示框"""
    
43.     value = tree.item(item_id, 'values')[tree['columns'].index(column)]
    
44. 
    
45.     if column == "IPv6":
    
46.         value = value.split(" （")[0]  # 去掉备注
    
47. 
    
48.     pyperclip.copy(value)
    
49.     messagebox.showinfo("提示", f"{column} '{value}' 复制成功！")
    
50. 
    
51. 
    
52. def ping_ip(ip_address):
    
53.     """在新CMD窗口中对指定IP进行ping操作"""
    
54.     try:
    
55.         subprocess.Popen(f"start cmd /k ping {ip_address}", shell=True)
    
56.     except Exception as e:
    
57.         messagebox.showerror("错误", f"无法 ping IP 地址: {e}")
    
58. 
    
59. 
    
60. def show_context_menu(event, tree):
    
61.     """显示右键上下文菜单"""
    
62.     selected_item = tree.selection()
    
63.     if selected_item:
    
64.         column_index = int(tree.identify_column(event.x).replace("#", "")) - 1
    
65.         ip_address = tree.item(selected_item[0], 'values')[column_index]
    
66. 
    
67.         context_menu = tk.Menu(root, tearoff=0)
    
68.         context_menu.add_command(label="Ping", command=lambda: ping_ip(ip_address))
    
69.         context_menu.post(event.x_root, event.y_root)
    
70. 
    
71. 
    
72. def on_tree_item_double_click(event, tree):
    
73.     """处理双击事件以复制值"""
    
74.     selected_item = tree.selection()[0]
    
75.     column = tree.identify_column(event.x)
    
76.     column_index = int(column.replace("#", "")) - 1
    
77.     copy_selected_value(tree, selected_item, tree['columns'][column_index])
    
78. 
    
79. 
    
80. def setup_treeview(frame):
    
81.     """设置树形视图及其样式"""
    
82.     columns = ("网络接口名称", "IPv4", "IPv6", "MAC")
    
83.     tree = ttk.Treeview(frame, columns=columns, show="headings")
    
84. 
    
85.     # 设置列标题和宽度
    
86.     for col in columns:
    
87.         tree.heading(col, text=col)
    
88.         tree.column(col, width=200 if col == "网络接口名称" else 300, anchor='center')
    
89. 
    
90.     style = ttk.Style()
    
91.     style.configure("Treeview", rowheight=25, fieldbackground="white", borderwidth=2, relief="solid")
    
92.     style.configure("Treeview.Heading", font=('Helvetica', 12, 'bold'), borderwidth=2, relief="solid")
    
93. 
    
94.     return tree
    
95. 
    
96. 
    
97. def show_network_info():
    
98.     global root  # 将root设置为全局变量
    
99.     root = tk.Tk()
    
100.     root.title("IP 地址查看器（双击复制）")
     
101. 
     
102.     frame = ttk.Frame(root)
     
103.     frame.pack(fill=tk.BOTH, expand=True)
     
104. 
     
105.     network_info = get_network_info()
     
106.     interface_tree = setup_treeview(frame)
     
107. 
     
108.     for info in network_info:
     
109.         interface_tree.insert("", tk.END, values=info)
     
110. 
     
111.     # 绑定事件
     
112.     interface_tree.bind("<Double-1>", lambda event: on_tree_item_double_click(event, interface_tree))
     
113.     interface_tree.bind("<Button-3>", lambda event: show_context_menu(event, interface_tree))
     
114. 
     
115.     scrollbar = ttk.Scrollbar(frame, orient=tk.VERTICAL, command=interface_tree.yview)
     
116.     interface_tree.configure(yscrollcommand=scrollbar.set)
     
117. 
     
118.     interface_tree.pack(side=tk.LEFT, fill=tk.BOTH, expand=True)
     
119.     scrollbar.pack(side=tk.RIGHT, fill=tk.Y)
     
120. 
     
121.     # 调整窗口大小以适应内容
     
122.     root.update_idletasks()
     
123.     row_count = len(network_info)
     
124.     root.minsize(root.winfo_width(), 25 * row_count + 100)
     
125. 
     
126.     root.geometry("")  # 根据内容动态调整窗口大小
     
127.     root.mainloop()
     
128. 
     
129. 
     
130. if __name__ == "__main__":
     
131.     show_network_info()

复制代码

q490525427

tk 库高分屏显示异常问题，代码头部插入一串代码

1. import ctypes
   
2. ctypes.windll.shcore.SetProcessDpiAwareness(1)

复制代码

q490525427

AI了一个小工具
电脑开机提示，显示IP，拍照并发送邮件。
要打包成文件，然后添加到开机自启动
代码中替换成自己的邮箱

1. import requests
   
2. from bs4 import BeautifulSoup
   
3. import re
   
4. import smtplib
   
5. from email.mime.multipart import MIMEMultipart
   
6. from email.mime.text import MIMEText
   
7. from email.mime.base import MIMEBase
   
8. from email import encoders
   
9. from email.header import Header
   
10. import os
    
11. import cv2  # 导入opencv库
    
12. 
    
13. 
    
14. def fetch_ip_info():
    
15.     ip_url = 'https://2025.ip138.com/'
    
16.     headers = {'User-Agent': 'Mozilla/5.0'}
    
17. 
    
18.     try:
    
19.         response = requests.get(ip_url, headers=headers, timeout=10)
    
20.         response.encoding = response.apparent_encoding
    
21.         ip_address = re.search(r'\d{1,3}\.\d{1,3}\.\d{1,3}\.\d{1,3}', response.text)
    
22.         if not ip_address:
    
23.             print("未能获取到本机公网IP地址")
    
24.             return None
    
25. 
    
26.         ip = ip_address.group()
    
27.         print(f"当前IP地址：{ip}")
    
28. 
    
29.         info_url = f"https://www.ipshudi.com/{ip}.htm"
    
30.         response = requests.get(info_url, headers=headers, timeout=10)
    
31.         response.encoding = 'utf-8'
    
32.         soup = BeautifulSoup(response.text, 'html.parser')
    
33.         table = soup.find('table')
    
34. 
    
35.         if not table:
    
36.             print("未找到数据表格")
    
37.             return None
    
38. 
    
39.         result = {}
    
40.         for tr in table.find_all('tr'):
    
41.             tds = tr.find_all('td')
    
42.             if len(tds) != 2: continue
    
43.             key, value = tds[0].get_text(strip=True), tds[1].get_text(" ", strip=True)
    
44. 
    
45.             if key == "归属地":
    
46.                 locations = [x for x in value.split("上报纠错")[0].strip().split() if x]
    
47.                 location_mapping = {
    
48.                     '省份': locations[1] if len(locations) > 1 else 'N/A',
    
49.                     '城市': locations[2] if len(locations) > 2 else 'N/A',
    
50.                     '区县': locations[3] if len(locations) > 3 else 'N/A',
    
51.                 }
    
52.                 result[key] = f"{location_mapping['省份']}, {location_mapping['城市']}，{location_mapping['区县']}"
    
53.             else:
    
54.                 result[key] = value
    
55. 
    
56.         return ip, result
    
57.     except requests.exceptions.RequestException as e:
    
58.         print(f"获取IP信息失败：{str(e)}")
    
59.         return None
    
60. 
    
61. 
    
62. def capture_image(file_path='captured_photo.jpg'):
    
63.     cap = cv2.VideoCapture(0)
    
64. 
    
65.     if not cap.isOpened():
    
66.         print("无法打开摄像头")
    
67.         return False
    
68. 
    
69.     ret, frame = cap.read()
    
70.     if ret:
    
71.         cv2.imwrite(file_path, frame)
    
72.         print(f"图像已保存到 {file_path}")
    
73.         cap.release()
    
74.         return True
    
75.     else:
    
76.         print("未能捕获到图像")
    
77.         cap.release()
    
78.         return False
    
79. 
    
80. 
    
81. def send_email_with_attachments(ip_info, photo_path):
    
82.     sender = '填写163发件邮箱'  # 发件人邮箱
    
83.     password = '填写发件163邮箱授权码'  # 发件人邮箱授权码
    
84.     receiver = '填写收件任意邮箱'  # 收件人邮箱
    
85.     subject = '电脑已开机'
    
86. 
    
87.     if ip_info:
    
88.         ip, info = ip_info
    
89.         body = (f"IP地址：{ip}\n"
    
90.                 f"归属地：{info['归属地']}\n"
    
91.                 f"运营商：{info.get('运营商', 'N/A')}\n"
    
92.                 f"IP类型：{info.get('iP类型', 'N/A')}")
    
93.     else:
    
94.         body = "未能成功获取IP信息。\n"
    
95. 
    
96.     msg = MIMEMultipart()
    
97.     msg['From'] = Header(sender)
    
98.     msg['To'] = Header(receiver)
    
99.     msg['Subject'] = Header(subject, 'utf-8')
    
100.     msg.attach(MIMEText(body, 'plain', 'utf-8'))
     
101. 
     
102.     if os.path.exists(photo_path):
     
103.         with open(photo_path, 'rb') as f:
     
104.             mime = MIMEBase('image', 'jpg', filename=os.path.basename(photo_path))
     
105.             mime.add_header('Content-Disposition', 'attachment', filename=os.path.basename(photo_path))
     
106.             mime.add_header('X-Attachment-Id', '0')
     
107.             mime.add_header('Content-ID', '<0>')
     
108.             mime.set_payload(f.read())
     
109.             encoders.encode_base64(mime)
     
110.             msg.attach(mime)
     
111.             print(f"照片 {photo_path} 已附加到邮件中")
     
112.     else:
     
113.         print(f"警告：文件 {photo_path} 不存在，跳过该附件。")
     
114.         body += "\n注意：由于某种原因，未能成功拍摄并附加照片。"
     
115.         msg.attach(MIMEText(body, 'plain', 'utf-8'))
     
116. 
     
117.     try:
     
118.         smtpObj = smtplib.SMTP_SSL('smtp.163.com', 465)
     
119.         print("成功连接到 SMTP 服务器")
     
120. 
     
121.         smtpObj.login(sender, password)
     
122.         print("成功登录到 SMTP 服务器")
     
123. 
     
124.         smtpObj.sendmail(sender, [receiver], msg.as_string())
     
125.         print("邮件发送成功")
     
126. 
     
127.         # 如果有照片且邮件发送成功后才删除照片
     
128.         if os.path.exists(photo_path):
     
129.             os.remove(photo_path)
     
130.             print(f"本地文件 {photo_path} 已删除")
     
131.     except smtplib.SMTPException as e:
     
132.         print(f"无法发送邮件，错误信息：{str(e)}")
     
133. 
     
134. 
     
135. if __name__ == "__main__":
     
136.     ip_info = fetch_ip_info()
     
137. 
     
138.     # 手动指定其他路径
     
139.     photo_path = r"D:\ZQ.jpg"  # 示例：保存到 D 盘根目录
     
140. 
     
141.     # 确保目录存在（如果需要）
     
142.     #os.makedirs(os.path.dirname(photo_path), exist_ok=True)
     
143. 
     
144.     if ip_info:
     
145.         photo_taken = capture_image(photo_path)
     
146.         send_email_with_attachments(ip_info, photo_path)

复制代码