2021年11月_nongcunqq

12月 11月 10月 09月 08月 07月 06月 05月 04月 03月 02月 01月

原创 excel python 保持格式复制粘贴 Excel.Application

import pyrfc, jsonimport tablibfrom datetime import datetimeimport win32com.client, os, shutil, timexl = win32com.client.Dispatch("Excel.Application")file = r'D:\code\maria_po_transfer\t2\dn_template.xls'xl.DisplayAlerts = Falsexl.Visible = Truew

2021-11-30 17:26:39 1175

原创两个全文检索工具

recoll支持mac、linux、windowswindows需付费下载，linux开源AnyText searcher参考http://www.brofive.org/?p=67201.26.3中文版http://www.xitongzhijia.net/soft/17615.html

2021-11-23 09:12:27 327

原创 python解析xml

import requestsimport xml.etree.ElementTree as ETurl = 'http:///WebService/EcusWebService.asmx/get_ecar_bya?p_bya14={}'# GET /WebService/EcusWebService.asmx/get_ecar_bya?p_bya14=string HTTP/1.1# Host: ecusweb9.efoxconn.comcar_num = 'C20163'wbda

2021-11-22 09:16:50 431

原创 win32操作Excel 保存文件

为什么用win32，既能打开excel又能操作xlrd只能读取xlwt保存的话需要重新设置格式，win32 excel.application不受影响from win32com.client import Dispatchxl = Dispatch('Excel.Application')wb = xl.Workbooks.Open(filename)time.sleep(60)wb.Close(True)wb.Close(True)代表保存后关闭参考https://stackov

2021-11-18 13:59:30 689

原创 python调用oracle存储过程

创建一个存储过程CREATE OR REPLACE PROCEDURE get_order_count( salesman_code NUMBER, year NUMBER, order_count OUT NUMBER)IS BEGIN SELECT COUNT(*) INTO order_count FROM orders WHERE salesman_id = salesman_code AND

2021-11-17 09:13:44 1569

原创 Bezos 2015 letters to shareholders

2015 letters to shareholdersTo our shareowners:This year, Amazon became the fastest company ever to reach $100 billion in annual sales. Also this year Amazon Web Service is reaching $10 billion in annual sales … doing so at a pace even faster than Amazon

2021-11-16 10:01:55 338

原创 html css 强制不换行

<th style="white-space:nowrap; display:inline;" >PO Material</th> <th style="white-space:nowrap; display:inline;" >Goods movement</th> <th style="white-space:nowrap; display:inline;" >SO Item</th> <t

2021-11-09 19:22:46 366

原创 sqlalchemy filter过滤计算字段长度或条件

error_results = ss.query(Hsj3).filter(Hsj3.transfer >= today_zero, or_(func.length(Hsj3.pgi) < 1, Hsj3.pgi == None) ).count()导入func、or_当值为null时，长度不为0，因此也不小于1or_ 作用等同于Python自带的 or ，或条件参考https://blog.csdn.net/lilygg/article/details/115006334htt.

2021-11-09 16:23:53 1254

原创无法以排程方式执行excel (-2147352567, ‘发生意外。‘, (0, ‘Microsoft Excel‘, ‘抱歉，无法找到 1.xlsx。是否可能被移动、重命名或删除?‘, ‘xl

错误码(-2147352567, ‘发生意外。’, (0, ‘Microsoft Excel’, ‘抱歉，无法找到 1.xlsx。是否可能被移动、重命名或删除?’, ‘xlmain11.chm’, 0, -2146827284), None)手动运行时可以正常执行操作系统为windows server 2016简单解决方法手动建一个"c:\windows\syswow64\config\systemprofile\desktop"文件夹原文如下https://blog.darkthread.

2021-11-08 14:22:42 4418

原创帆软tomcat根目录

C:\Users\Public\FineReport_10.02_2\bin\tomcat.8075\work\Tomcat\localhost\webroot

2021-11-06 11:08:10 465

原创 @classmethod 和 @staticmethod的区别

两者都不需要实例化，就能调用类方法@staticmethod不需要传参@classmethod需要传入cls# _*_ coding:utf_8 _*_class People: def hello(self): print("hello, Everyone.") @staticmethod def say_morning(): print("good morning") # print(People.hello()) 这

2021-11-04 16:53:30 84

原创冲击参数锂电多功能电锤插电电锤电镐风镐

焦耳 J锂电大艺电锤 1.7J博世插电冲击钻 2J大艺插电电锤 4.2-4.5J大艺电镐 9.7J大艺工业电镐 PDH0165 15.8kg 40J开山风镐 43-50J

2021-11-03 14:25:50 600

原创解決 Python 中 UnicodeDecodeError: ‘cp950‘ codec can‘t decode

解決 Python 中 UnicodeDecodeError: ‘cp950’ codec can’t decode写日志记录log到txt出现cp950错误加上f = open("data1109.txt","r",encoding="utf-8") #注意此行import ref = open("data1109.txt","r",encoding="utf-8") #注意此行line = f.read()arr = re.findall(r"[0-9]+:[0-9]+\s",

2021-11-03 09:36:45 2807

原创 Bezos写给股东的信贝索斯

20181.A builder’s mentality helps us approach big, hard-to-solve opportunities with a humble conviction that success can come through iteration: invent, launch, reinvent, relaunch, start over, rinse, repeat, again and again. They know the path to success

2021-11-02 14:56:27 162

空空如也

TA创建的收藏夹 TA关注的收藏夹

TA关注的人

nongcunqq的博客