摘要:
Excel表格拆分可以用power query 数据-来自表格/区域-弹出Power Query编辑器 添加列-自定义列 Text.Select([列1],{"0":"9",":"}) 阅读全文
摘要:
造数过程中需要批量生成ID或者账号,可以利用for循环和列表,也可以是列表生成式。[str(i)+'aaa'for i in range(1000)] num = [] for i in range(1000, 2001): num_str = str(i) id = num_str + 'aaa' 阅读全文
摘要:
Excel造数用到的高频表达式 随机生成0与1,显示为“是”与“否” =if(randbetween(0,1)=1,"是","否") =if(randbetween(0,1)=1,"餐饮","生活日用") =if(randbetween(0,1)=1,"交通出行","购物") =if(A1="已激活 阅读全文