jackos521627的博客

自定义函数-正则表达式：Function TQ(rng, types As String) As StringDim obj As ObjectSet obj = CreateObject(“VBSCRIPT.REGEXP”)With obj.Global = TrueSelect Case typesCase Is = “-hz” '去汉字.Pattern = “[一-﨩]”Case Is = “-zm” '去字母.Pattern = “[a-zA-Z]”Case Is =

可能有的人使用Excel加密比较麻烦，这篇主要就是获取exce报文,提取需要加密的数据,python加密,替换原始数据,达到想要的加密报文。#-*- coding=utf-8 -*-import xlrdimport base64import re# 打开xlsm报文,启用宏的excelworkbook=xlrd.open_workbook(u'C:\\Users\\54105\\De...

前面一篇写了Excel拼接xml报文的方法,这一篇为使用Python读取启用宏的excel,来获取xml报文#-*- coding=utf-8 -*-import xlrd# 打开xlsm报文,启用宏的excelworkbook=xlrd.open_workbook(u'C:\\Users\\54105\\Desktop\\报文拼接器.xlsm')# 根据sheet名获取工作簿shee...

用到的方法1.CONCATENATE()拼接：=CONCATENATE("<",A4,">",C4,"</",A4,">")结果：2.NOW()获取现在日期输入：=NOW()输出为现在时间：3.YEAR(),MONTH(),DAY(),HOUR(),MINUTE()提取时间年,月,日,时,分以年为例:输入:=YEAR(=NOW())输出:20194....