Excel
Excel学习记录
结伴同行~
这个作者很懒,什么都没留下…
展开
-
Excel 自己常用的一些操作
Option Explicit '强制变量声明Dim nShts As Long, nSht As LongDim nRows As Long, nCols As LongDim time0' 判断是否存在指定名称的SheetFunction shtHas(wb As Workbook, shtName As String) nShts = wb.Sheets.Count shtHas = False For nSht = 1 To nShts Step 1 .原创 2022-01-26 17:56:50 · 287 阅读 · 0 评论 -
Excel 正则表达式的用法
判断【patten】和【字符串】是否匹配成功'Test:返回一个布尔值,该值指示正则表达式是否与字符串成功匹配。'Dim s As String '字符串'Dim p As String '正则表达式Function bTest(ByVal s As String, ByVal p As String, Optional ByRef val As String = "-10001") As Boolean Dim re As Object Set re = CreateObjec原创 2022-01-26 17:54:25 · 1396 阅读 · 0 评论 -
Excel 判断一个字符串是不是数字
' 判断一个字符串是不是数字Function isNumber(str, Optional blankIsNum As Boolean = False) isNumber = IsNumeric(str) If str = "" Then isNumber = IIf(blankIsNum, True, False) End IfEnd Function原创 2022-01-26 17:50:17 · 915 阅读 · 0 评论 -
Excel Power Query M 常用日期处理
Excel 数据分析里面,Power Query用来处理日期let源 = Excel.CurrentWorkbook(){[Name="表3"]}[Content],改为日期类型 = Table.TransformColumnTypes(重命名的列,{{"pt", type date}}),添加年 = Table.AddColumn(改为日期类型, "年", each Date.Year([pt])),添加月 = Table.AddColumn(添加年,...原创 2022-01-26 17:47:52 · 3761 阅读 · 0 评论