Excel VBA 隐藏和显示工作表
隐藏/取消隐藏工作表
sheet.Visible = xlSheetVisible '取消隐藏
sheet.Visible = xlSheetHidden '隐藏
sheet.Visible=xlSheetVeryHidden '高级隐藏(必需使用VBA才能恢复显示)
隐藏/取消隐藏工作表
sheet.Visible = xlSheetVisible '取消隐藏
sheet.Visible = xlSheetHidden '隐藏
sheet.Visible=xlSheetVeryHidden '高级隐藏(必需使用VBA才能恢复显示)
VBA对单元格数据进行批量修改时,可以暂时关闭自动计算和屏幕刷新,加快代码运行速度。
'关闭屏幕刷新
Application.ScreenUpdating = False
'关闭自动计算(调整为手动计算)
Application.Calculation = xlManual
'启动屏幕刷新
Application.ScreenUpdating = True
'启动自动计算
Application.Calculation = xlAutomatic
'计算——整个工作簿
Calculate
大于等于某个固定值
例如:大于等于3
举例:">=3"
大于等于某个单元格或函数
语法:">="&A3
Function FindColOfValue(ws As Worksheet, val As Variant, rowNum As Long, startCol As Long)
Dim i As Long
With ws
For i = startCol To .Range(.Cells(startCol, rowNum), .Cells(startCol, rowNum)).CurrentRegion.Columns.Count()
If .Cells(rowNum, i).Value = val Then
FindColOfValue = i
Exit Function
End If
Next
End With
FindColOfValue = -1
End Function
Function FindRowOfValue(ws As Worksheet, val As Variant, colNum As Long, startRow As Long)
Dim r As Long
With ws
For r = startRow To .Range(.Cells(startRow, colNum), .Cells(startRow, colNum)).CurrentRegion.Rows.Count()
If .Cells(r, colNum).Value = val Then
FindRowOfValue = r
Exit Function
End If
Next
End With
End Function
Sort a dictionary by value
依据字典的值进行排序
newDict = {k: v for k, v in sorted(x.items(), key=lambda item: item[1])}
import operator
# 示例字典
d = {'a': 3, 'e': 4, 'b': 2, 'c': 5, 'd': 1}
# 按 key 排序
def dict_sort_by_key(d: dict):
sorted_d = sorted(d.items(), key=operator.itemgetter(0))
return dict(sorted_d)
# 按 value 排序
def dict_sort_by_val(d: dict):
# sorted_dic = dict(sorted(d.items(), key=operator.itemgetter(1)))
sorted_keys=sorted(dict1, key=dict1.get)
for k in sorted_keys:
sorted_dic[k]=d[k]
return sorted_dic
print(dict_sort_by_key(d))
# {'a': 3, 'b': 2, 'c': 5, 'd': 1, 'e': 4}
print(dict_sort_by_val(d))
# {'d': 1, 'b': 2, 'a': 3, 'e': 4, 'c': 5}
let region = process.env.AWS_REGION
import os
region = os.environ['AWS_REGION']
更多运行时环境变量参考 AWS docs
Public DNS
几大公共DNS服务器的IP地址
提供商 | 主 DNS | 辅 DNS |
---|---|---|
Cloudflare | 1.1.1.1 | 1.0.0.1 |
8.8.8.8 | 8.8.4.4 | |
阿里云 | 223.5.5.5 | 223.6.6.6 |
Control D | 76.76.2.0 | 76.76.10.0 |
Cisco OpenDNS | 208.67.222.222 | 208.67.220.220 |
如何获得资产ID(asset id)、货币符号(symbol)等等信息?
由于Mixin Network 中有多条区块链的总计上千种资产,大多数一般也用不到。获取部分常用的,或者查询某个具体的资产即可。
def get_md5_string(content)->str:
"""
- content: bytes or string
"""
m = hashlib.md5()
if type(content) == bytes:
m.update(content)
elif type(content) == str:
m.update(content.encode())
else:
return None
return m.hexdigest()