Python
qq_42678477
这个作者很懒,什么都没留下…
展开
-
python获取桌面路径
import winregimport osdef get_desktop(): subkey = r'Software\Microsoft\Windows\CurrentVersion\Explorer\Shell Folders' key = winreg.OpenKey(winreg.HKEY_CURRENT_USER, subkey) (value, _) = winreg.QueryValueEx(key, 'Desktop') return value.原创 2021-01-07 21:37:12 · 306 阅读 · 0 评论 -
鼠标右键新建.py文件(python操作注册表)
import winregkey = winreg.CreateKey(winreg.HKEY_CLASSES_ROOT, 'pyfile')winreg.SetValueEx(key, '', 0, winreg.REG_SZ, 'Python文件')key = winreg.CreateKey(winreg.HKEY_CLASSES_ROOT, '.py')winreg.SetValueEx(key, '', 0, winreg.REG_SZ, 'pyfile')key = winre.原创 2021-01-07 21:15:43 · 642 阅读 · 0 评论 -
win7安装python3.7.4错误api-ms-win-crt-processl1-1-1-0.dll解决办法
win7安装python3.7.4有时会遇到以下错误:解决办法如下:1. 卸载python2. 在https://www.microsoft.com/zh-cn/download/details.aspx?id=48145下载vc_redist.x86.exe。3. 删除Windows\SysWOW64下文件api-ms-win-crt-runtime-l1-1-0.dll...原创 2019-07-27 11:52:06 · 2139 阅读 · 3 评论 -
pyodbc操作Access2013
# 测试环境:32位python access database engine 32位# pyodbc文档 https://github.com/mkleehammer/pyodbc/wiki import pyodbc# 驱动程序for x in [x for x in pyodbc.drivers()]: if 'Access' in x and 'accdb' in x: print(x)# 连接Access2013数据库path = r'C:\Users\.原创 2020-12-27 21:21:00 · 290 阅读 · 1 评论 -
xlwing操作excel(二)
import sysimport osimport tkinter as tkimport tkinter.filedialog as tkfimport xlwings as xwdef getbillfiles(path): list =os.listdir(path) result = [] for i in range(0,len(list)): temp = os.path.join(path,list[i]) if os.pa.原创 2020-11-27 19:13:44 · 471 阅读 · 1 评论 -
xlwings操作Excel
import osimport shutilimport datetimefrom string import Templateimport xlwings as xw# 整个流程测试# 1. 打开报表 (目前仅考虑单工作表)reportSheetdef getreportfilename(reportpath): # 如果模板文件不存在,如何抛出异常 if not os.path.exists(reportpath): raise '报表模板不存在' .原创 2020-11-25 20:32:17 · 680 阅读 · 0 评论 -
获取ATimeLogger数据并写入Sqlserver数据库
import requestsfrom requests.auth import HTTPBasicAuthimport jsonimport timeimport datetimeimport pymssqlimport uuiddef get_connection(): conn = pymssql.connect(server='127.0.0.1\sqlexpress',port=1433,user='xxx',password='xxx',database='xxxx'.原创 2020-07-27 20:00:38 · 308 阅读 · 0 评论 -
python创建目录并用资源管理器打开
# coding=utf-8 import osimport datetimecurrentday = datetime.date.today().strftime('%Y%m%d')dir = 'e:\\工作记录\\' + currentdayif not os.path.exists(dir): os.makedirs(dir)os.system('explorer...原创 2019-07-31 21:53:00 · 976 阅读 · 1 评论 -
Python操作xml
xml文件<?xml version="1.0" encoding="utf-8"?><config> <item> <item-name>Browser</item-name> <item-path>Appkit/Tools</item-path> ...原创 2019-07-27 17:56:21 · 109 阅读 · 0 评论